This is an old revision of the document!
Table of Contents
Error Messages and Resolution
The settings in the MGR parameter file mean that any process that abends will be automatically restarted.
If, after 3 attempts, the process cannot restart then it is left in an abended state.
Supplemental Log Data Issues
OGG-01161 Bad column index (5) specified for table
OGG-01920 Missing COMPARECOLS column CHECKIN_INTERVAL in before image
OGG-01921 Missing GETBEFORECOLS with conflict detection enabled in target table …
When any of the above issues occur it is usually an issue with the supplemental data logging.
There is no way to add it for the current statement, so the best solution is to edit the parameter and remove the lines that relate to the table mentioned in the error statement. Now start the replicat process.
The following should now be done …
ALTER TABLE <TABLE_NAME> DROP SUPPLEMENTAL LOG DATA (ALL) COLUMNS; ALTER TABLE <TABLE_NAME> ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
Now you should be able to remove the comment and restart the replicat process.
Ignored Issues
OGG-00519 Fatal error executing DDL replication: error [Error code [24344] …]
Memory Issues
OGG-01841 CACHESIZE TOO SMALL
Other
OGG-00402 WILDCARDRESOLVE parameter must be set to DYNAMIC when DDL replication is enabled.
OGG-00446 No data selecting position from checkpoint table GGATE.CHKPTAB …
OGG-01044 The trail '…' is not assigned to extract '…'
OGG-01224 TCP/IP error 146 (Connection refused)
OGG-01296 Error mapping from … to …
OGG-01496 Failed to open target trail file
OGG-01907 Null column COMMENT_COUNT cannot be used in delta resolution