"cdr define repl"-Problem after migration to 12.10

Hi All, IBM Informix Dynamic Server Version 12.10.UC4W1 (after migration from 11.70.UC7W3) OS: Suse Linux Enterprise Server 11 SP1 We have a Enterprise Replication Environment with 15 Server`s with update anywhere. Our Replicate defintions are inherited from the IDS7.31th-World. We`ve got no master-replicates or replicatesets. We have inplace upgraded from 7.31 to 11.70 2 years ago. Now we have inplace-upgraded the first server from 11.70 to 12.10 and made a test defining new replicates. But when we want to define a replicate with the following syntax we`ve run into the following error: cdr define repl R_replicate1 -Ctimestamp -Stran -A -T --classic \\\\ "ifxdb@olserver1cdr:root.table1" \\\\ "select * from table1 " \\\\ "ifxdb@olserver2cdr:root.table1" \\\\ "select * from table1 " \\\\ "ifxdb@olserver3cdr:root.table1" \\\\ "select * from table1 " \\\\ ...and so on Output: cdr error: Cannot open cursor - ldIndices SQL code -217 :Column (jparam) not found in any table in the query (or SLV is undefined). ISAM 0 : When we execute this "cdr define repl ..."-Statement on a 11.70-Server we`ve got no Problems. The 12.10-Server receive this define-Statement without errors. But when we made this "cdr define repl ..." on the 12.10-Server, error -217 is issued and no connected Server receive the Statement. Now we search for a possibility to define the replicates (respectively to fix this error) on the 12.10-Server when all other Servers in our ER-Environment are still under 11.70. Thanks in advance for your help. Sascha

Please execute the following query on all of the servers in the ifxdb database. select c.colname from syscolumns c, systables t where t.tabname =3D "sysindices" and t.tabid =3D c.tabid order by c.colno; From: "SASCHA KURATIS" <sascha.kuratis@westfleisch.de> To: ids@iiug.org Date: 11/03/2014 07:04 AM Subject: "cdr define repl"-Problem after migration to 12.10 [34083] Sent by: ids-bounces@iiug.org Hi All, IBM Informix Dynamic Server Version 12.10.UC4W1 (after migration from 11.70.UC7W3) OS: Suse Linux Enterprise Server 11 SP1 We have a Enterprise Replication Environment with 15 Server`s with upda= te anywhere. Our Replicate defintions are inherited from the IDS7.31th-World. We`ve = got no master-replicates or replicatesets. We have inplace upgraded from 7.31 = to 11.70 2 years ago. Now we have inplace-upgraded the first server from 11.70 to 12.10 and m= ade a test defining new replicates. But when we want to define a replicate with the following syntax we`ve = run into the following error: cdr define repl R_replicate1 -Ctimestamp -Stran -A -T --classic \\\\ "ifxdb@olserver1cdr:root.table1" \\\\ "select * from table1 " \\\\ "ifxdb@olserver2cdr:root.table1" \\\\ "select * from table1 " \\\\ "ifxdb@olserver3cdr:root.table1" \\\\ "select * from table1 " \\\\ ....and so on Output: cdr error: Cannot open cursor - ldIndices SQL code -217 :Column (jparam) not found in any table in the query (or = SLV is undefined). ISAM 0 : When we execute this "cdr define repl ..."-Statement on a 11.70-Server we`ve got no Problems. The 12.10-Server receive this define-Statement without= errors. But when we made this "cdr define repl ..." on the 12.10-Server, error = -217 is issued and no connected Server receive the Statement. Now we search for a possibility to define the replicates (respectively = to fix this error) on the 12.10-Server when all other Servers in our ER-Environment are still under 11.70. Thanks in advance for your help. Sascha ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

Bug 504313 I think that you could try to use the cdr utility from 11.70. From: "SASCHA KURATIS" <sascha.kuratis@westfleisch.de> To: ids@iiug.org Date: 11/03/2014 07:04 AM Subject: "cdr define repl"-Problem after migration to 12.10 [34083] Sent by: ids-bounces@iiug.org Hi All, IBM Informix Dynamic Server Version 12.10.UC4W1 (after migration from 11.70.UC7W3) OS: Suse Linux Enterprise Server 11 SP1 We have a Enterprise Replication Environment with 15 Server`s with upda= te anywhere. Our Replicate defintions are inherited from the IDS7.31th-World. We`ve = got no master-replicates or replicatesets. We have inplace upgraded from 7.31 = to 11.70 2 years ago. Now we have inplace-upgraded the first server from 11.70 to 12.10 and m= ade a test defining new replicates. But when we want to define a replicate with the following syntax we`ve = run into the following error: cdr define repl R_replicate1 -Ctimestamp -Stran -A -T --classic \\\\ "ifxdb@olserver1cdr:root.table1" \\\\ "select * from table1 " \\\\ "ifxdb@olserver2cdr:root.table1" \\\\ "select * from table1 " \\\\ "ifxdb@olserver3cdr:root.table1" \\\\ "select * from table1 " \\\\ ....and so on Output: cdr error: Cannot open cursor - ldIndices SQL code -217 :Column (jparam) not found in any table in the query (or = SLV is undefined). ISAM 0 : When we execute this "cdr define repl ..."-Statement on a 11.70-Server we`ve got no Problems. The 12.10-Server receive this define-Statement without= errors. But when we made this "cdr define repl ..." on the 12.10-Server, error = -217 is issued and no connected Server receive the Statement. Now we search for a possibility to define the replicates (respectively = to fix this error) on the 12.10-Server when all other Servers in our ER-Environment are still under 11.70. Thanks in advance for your help. Sascha ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

Thanks for your response Madison. The cdr utility works from 11.70 and the 12.10-Server receive the replicate definitions. This is a workaround, but not the perfect solution. Will this Bug be fixed in the next FixPack ? Knows anyone the date when the next FixPack for 12.10 will be released ? Sascha