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 comments and restart the replicat process.
Ignored Issues
OGG-00519 Fatal error executing DDL replication: error [Error code [24344] …]
If there are DDL errors that you know can be ignored then you can add a line to the replicat parameter file.
For example the following line will discard any ORA-24344 errors related to DDL …
DDLERROR 24344 DISCARD
Memory Issues
OGG-01841 CACHESIZE TOO SMALL
This error suggests that the OS has run out of virtual memory or swap.
Run a “swap -s” command to check on how much free swap space there is.
Other
OGG-00402 WILDCARDRESOLVE parameter must be set to DYNAMIC when DDL replication is enabled.
This error message is particular to GoldenGate 11g only and applies only to extracts.
When using CDR I had to use the parameter NODYNAMICRESOLUTION.
Then, further down the parameter file, switch back to DYNAMICRESOLUTION and include the DDL parameters and Wildcard parameters.
OGG-00446 No data selecting position from checkpoint table GGATE.CHKPTAB …
The replicat process is looking in the wrong place in the trail file.
Adjust the position by using the following command …
ALTER REPLICAT REPMOL01, EXTSEQNO <TRAILFILE_NO>, EXTRBA <TRAILFILE_POSITION>
OGG-01044 The trail '…' is not assigned to extract '…'
You must register the trail file with the extract process.
Use the following command to register it …
ADD EXTTRAIL <TRAIL_LOCATION>, EXTRACT <EXTRACT_NAME, MEGABYTES <TRAIL_FILE_SIZE>
OGG-01907 Null column COMMENT_COUNT cannot be used in delta resolution
When using deltas to resolve CDR issues, you must ensure that the column will never be a null value.