Re: ER error defining template

There is a primary key Table schema follows: create table 'informix'.action ( a_employee_id CHAR(6) not null, a_loworg CHAR(4), a_schedule_cd CHAR(2), a_pos_id CHAR(8), a_job_title CHAR(50), a_auth_job_id CHAR(6), a_job_id CHAR(6), a_dps_eff_dt DATE not null, a_seq_no SMALLINT not null, a_action_cd CHAR(5), a_hrly_rate MONEY(6,2), a_sal_step CHAR(3), a_long_step CHAR(3), a_min_step CHAR(3), a_max_step CHAR(3), a_min_hrly MONEY(6,2), a_max_hrly MONEY(6,2), a_full_part CHAR(1), a_normal_hrs INT, a_percent_time DECIMAL(3,2), a_range CHAR(5), a_flsa CHAR(1), a_mep_ind CHAR(1), a_comments TEXT ) extent size 16000 next size 64 lock mode row; create unique index 'informix'.idx_action on 'informix'.action ( a_employee_id, a_dps_eff_dt desc, a_seq_no desc ); alter table 'informix'.action add constraint foreign key (a_employee_id) references 'informix'.individual (i_employee_id) constraint fk_actempid; alter table 'informix'.action add constraint primary key (a_employee_id, a_dps_eff_dt, a_seq_no) constraint u375_399; Laurie Gustin IT Programmer Analyst Department of Public Safety lgustin@utah.gov 801-965-4410 >>> Madison Pruet <mpruet@tx.rr.com> 12/18/06 11:06 PM >>> Laurie Gustin wrote: > HPUX 11.11 IDS 10.00 FC5 > > I am new to ER, but have successfully defined and realized several templates. > > On my last endeavor, I got this error > > Obtaining dictionary for personnel@g_psproda:''informix''.action > Not all columns in PK are selected for repl > command failed -- An error occurred concerning a mastered replicate (125) Is there a primary key defined on the table "action". Could we see the schema definition for the table? > > > This is my define statement... > > > cdr define template personnel --connect=psproda --conflict=timestamp --master=g_psproda --database=personnel --all > > I have also tried just defining the single replicate with this command. > > > cdr define replicate personnel_action --connect=psproda --conflict=timestamp --master=g_psproda "personnel@g_psproda:informix.action" "select * from action" "personnel@g_psprodr:informix.action" "select * from action" > > I get pretty much the same error, no matter which way I go. > > > I am confused as to why not all columns would be selected. Is there something I need to do > extra for this? All the other database templates worked beautifully. > > Any insight would be appreciated. > > > > > Laurie Gustin > IT Programmer Analyst > Department of Public Safety > lgustin@utah.gov > 801-965-4410 >