ER error defining template
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) 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
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 >