Hi again,

sorry I was on other tasks in-between. So as per building an ER with 12.10 and 14.10, it finally worked great on the production environment, and apparently much faster that 12.10 =<> 12.10. (We integrated a new HDR pair of servers in 14.10, while the other servers are still on 12.10). So the product specs (any version above 11.70) are OK

Now, back to the initial issue of the 'weird' errors, or should I call them 'speechless' errors. This time this is between 14.10 FC1 and 14.10 FC2, where I am not supposed to have issues anyway.

cdr define server works ok on both ways. The problem comes with the cdr define repl command, which works fine in the other environment and not in this one.
When I run:
cdr define replicate --master source_grp --immediate --autocreate --conflict=ignore --scope=tran --ats replicate_name \
"P src_db@src_grp:informix.src_table" "select * from src_table" \
"R target_db@target_grp:informix.target_table" "select * from target_table"

here is the stderr output:

Verification of src_db@src_grp:informix.src_table started
Verification of src_db@src_grp:informix.src_table is successful
Verification of target_db@target_grp:informix.target_table started
Verification of target_db@target_grp:informix.target_table failed
Master Replicate Verification Total errors:1
command failed -- undefined replicate (31)

the last verif fails although the table is created on the target side, but no clue on what failed. The communication seems to be ok else I would not have my table created on the target side.
I looked in the syscdr:cdrerrors table and nothing about this operation.

My problem is that I don't know WHAT failed in the last verification phase during the cdr define statement.

Is there a log file or something that could lead me somewhere? By the way, the online.log file says nothing about this operation on both sides

@Paul: is the solution you suggest consist in copying the most recent $INFORMIXDIR/bin/cdr binary to the 'older' servers and only this ?

Thanks
Eric

​

Hi again,

sorry I was on other tasks in-between. So as per building an ER with 12.10 and 14.10, it finally worked great on the production environment, and apparently much faster that 12.10 =<> 12.10. (We integrated a new HDR pair of servers in 14.10, while the other servers are still on 12.10). So the product specs (any version above 11.70) are OK

Now, back to the initial issue of the 'weird' errors, or should I call them 'speechless' errors. This time this is between 14.10 FC1 and 14.10 FC2, where I am not supposed to have issues anyway.

cdr define server works ok on both ways. The problem comes with the cdr define repl command, which works fine in the other environment and not in this one.
When I run:
cdr define replicate --master source_grp --immediate --autocreate --conflict=ignore --scope=tran --ats replicate_name \
"P src_db@src_grp:informix.src_table" "select * from src_table" \
"R target_db@target_grp:informix.target_table" "select * from target_table"

here is the stderr output:

Verification of src_db@src_grp:informix.src_table started
Verification of src_db@src_grp:informix.src_table is successful
Verification of target_db@target_grp:informix.target_table started
Verification of target_db@target_grp:informix.target_table failed
Master Replicate Verification Total errors:1
command failed -- undefined replicate (31)

the last verif fails although the table is created on the target side, but no clue on what failed. The communication seems to be ok else I would not have my table created on the target side.
I looked in the syscdr:cdrerrors table and nothing about this operation.

My problem is that I don't know WHAT failed in the last verification phase during the cdr define statement.

Is there a log file or something that could lead me somewhere? By the way, the online.log file says nothing about this operation on both sides

@Paul: is the solution you suggest consist in copying the most recent $INFORMIXDIR/bin/cdr binary to the 'older' servers and only this ?

Thanks
Eric

​

Hi again,

sorry I was on other tasks in-between. So as per building an ER with 12.10 and 14.10, it finally worked great on the production environment, and apparently much faster that 12.10 =<> 12.10. (We integrated a new HDR pair of servers in 14.10, while the other servers are still on 12.10). So the product specs (any version above 11.70) are OK

Now, back to the initial issue of the 'weird' errors, or should I call them 'speechless' errors. This time this is between 14.10 FC1 and 14.10 FC2, where I am not supposed to have issues anyway.

cdr define server works ok on both ways. The problem comes with the cdr define repl command, which works fine in the other environment and not in this one.
When I run:
cdr define replicate --master source_grp --immediate --autocreate --conflict=ignore --scope=tran --ats replicate_name \
"P src_db@src_grp:informix.src_table" "select * from src_table" \
"R target_db@target_grp:informix.target_table" "select * from target_table"

here is the stderr output:

Verification of src_db@src_grp:informix.src_table started
Verification of src_db@src_grp:informix.src_table is successful
Verification of target_db@target_grp:informix.target_table started
Verification of target_db@target_grp:informix.target_table failed
Master Replicate Verification Total errors:1
command failed -- undefined replicate (31)

the last verif fails although the table is created on the target side, but no clue on what failed. The communication seems to be ok else I would not have my table created on the target side.
I looked in the syscdr:cdrerrors table and nothing about this operation.

My problem is that I don't know WHAT failed in the last verification phase during the cdr define statement.

Is there a log file or something that could lead me somewhere? By the way, the online.log file says nothing about this operation on both sides

@Paul: is the solution you suggest consist in copying the most recent $INFORMIXDIR/bin/cdr binary to the 'older' servers and only this ?

Thanks
Eric

​