Informix - Problem description
Problem IC56825 | Status: Closed |
CDR CHECK WITH REPAIR OPTION CAN ORDER SYNC REPLICATES SUCH THAT RELATIONAL CONSTRAINTS WILL CAUSE A FAILURE | |
product: | |
IBM IDS / 5724L2300 / A10 - IDS 10.00 | |
Problem description: | |
When you try to run cdr check with repair a failure occurs with this error in the target's message log: 16:11:45 CDR CDRDS: transaction aborted (Error return from SQL for the commit command) with sql error 691 isam error 111. One thing that may lead to this is defining a template using the --file option which will influence the order the tables are replicated when there is a mismatch between source and target servers. If the order is incorrect when there is a foreign key relationship the above error will occur due to missing values not replicated yet. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * IDS 10.00, 11.10, 11.50 ER users * **************************************************************** * PROBLEM DESCRIPTION: * * When you try to run cdr check with repair a failure occurs * * with * * this error in the target's message log: * * 16:11:45 CDR CDRDS: transaction aborted (Error return from * * SQL * * for the commit command) with sql error 691 isam error 111. * **************************************************************** * RECOMMENDATION: * * Upgrade to IDS 10.00.xC10, 11.10.xC3, or 11.50.xC5 or above. * **************************************************************** | |
Local Fix: | |
Solution | |
Problem has been fixed. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.06.2008 28.08.2009 28.08.2009 |
Problem solved at the following versions (IBM BugInfos) | |
10.00.xC10, 11.10.xC3, 11.50.xC5 | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.0.xC9 |