Problem with ER : cdr sync replicate

Hi all, I use IDS 10.00.UC4 on both root and leaf server. ER is running fine, in particular the ‘upsert’ mechanism. I have installed and tested the UDR checksum functions. When testing the checksum function, I get some errors : select checksum(tabid,0) from systables where tabid = 1 ; 1784518769 -> OK with serial columns select checksum(tabname,0) from systables where tabid = 1 ; # ^ # 9700: Routine (checksum) ambiguous - more than one routine resolves to given s ignature. # -> ERROR with varchar columns select checksum(handlesnulls,0) from sysaggregates where aggid = 1 ; # ^ # 674: Routine (checksum) can not be resolved. # -> ERROR with boolean columns Now, I am trying to use the ‘cdr sync replicate’ command. The participants in the replicate My_Repl have no varchar nor boolean columns. Nevertheless, I get an error : # cdr sync replicate --master=g_root --repl=My_Repl --extratargetrows=delete g_leaf Segmentation fault Any suggestion should be welcome. Thank you, Philippe

philippe wrote: > Hi all, > > I use IDS 10.00.UC4 on both root and leaf server. > ER is running fine, in particular the ‘upsert’ mechanism. > > I have installed and tested the UDR checksum functions. > > When testing the checksum function, I get some errors : > > select checksum(tabid,0) from systables where tabid = 1 ; > 1784518769 > > -> OK with serial columns > > select checksum(tabname,0) from systables where tabid = 1 ; > # ^ > # 9700: Routine (checksum) ambiguous - more than one routine resolves to > given s > ignature. > # > > -> ERROR with varchar columns > The CDR utility casts columns to LVARCHAR that it does not have a specific routine for. > > select checksum(handlesnulls,0) from sysaggregates where aggid = 1 ; > # ^ > # 674: Routine (checksum) can not be resolved. > # > > -> ERROR with boolean columns > > > Now, I am trying to use the ‘cdr sync replicate’ command. The > participants in the replicate My_Repl have no varchar nor boolean > columns. Nevertheless, I get an error : > > # cdr sync replicate --master=g_root --repl=My_Repl > --extratargetrows=delete g_leaf > Segmentation fault First of all, whenever the cdr utility detects an error, it kills itself with a segv so we can get a core file. Please run the command under a debugger so that we can get a stack trace. That will help to see where the error is occurring. We will probably need to have the schema definition of the table being synced. Can you get a case opened on this? M.P. > > > Any suggestion should be welcome. > > Thank you, > Philippe > >

You don't need checksum UDRs for 'cdr sync' - only 'cdr check' will use them. Regarding the 'cdr sync' failure, can we see this stack/core file/PMR opened? Come back if you need help on this! (Platform information would be handy as well.) Andreas