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
>
>