Differences

This shows you the differences between two versions of the page.

--- error_messages [2016/10/11 09:45] – z0hpvk
+++ error_messages [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 ===== 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-01161**  Bad column index (5) specified for table \\
-OGG-01921  Missing GETBEFORECOLS with conflict detection enabled in target table ... \\
+**OGG-01920**  Missing COMPARECOLS column CHECKIN_INTERVAL in before image \\
-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 ... \\
+<code>ALTER TABLE <TABLE_NAME> DROP SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
+ALTER TABLE <TABLE_NAME> ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;</code>
-ERROR   OGG-00402  Oracle GoldenGate Capture for Oracle, extmol01.prm:  WILDCARDRESOLVE parameter must be set to DYNAMIC when DDL replication is enabled.
+Now you should be able to remove the comments and restart the replicat process.
-ERROR   OGG-01224  Oracle GoldenGate Capture for Oracle, dpoth01.prm:  TCP/IP error 146 (Connection refused)
+==== Ignored Issues ====
-ERROR   OGG-01496  Oracle GoldenGate Capture for Oracle, dpoth01.prm:  Failed to open target trail file
+**OGG-00519**  Fatal error executing DDL replication: error [Error code [24344] ...] \\
-ERROR   OGG-01044  Oracle GoldenGate Capture for Oracle, extmol01.prm:  The trail './dirdat/ml' is not assigned to extract 'EXTMOL01'.
-                   Assign the trail to the extract with the command "ADD EXTTRAIL/RMTTRAIL ./dirdat/ml, EXTRACT EXTMOL01".
-Supplemental Log Data Issues
-----------------------------
+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 ... \\
+<code>DDLERROR 24344 DISCARD</code>
-Ignored Errors
+==== Memory Issues ====
---------------
+**OGG-01841**  CACHESIZE TOO SMALL \\
-ERROR   OGG-00519  Oracle GoldenGate Delivery for Oracle, repmol02.prm:  Fatal error executing DDL replication: error [Error code [24344], ORA-24344: success with compilation error SQL ALTER PACKAGE "MAILONLINE"."CE_SEARCH" COMPILE BODY REUSE SETTINGS  /* GOLDENGATE_DDL_REPLICATION */], no error handler present.
+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. \\
-ERROR   OGG-01841  Oracle GoldenGate Capture for Oracle, extoth02.prm:  CACHESIZE TOO SMALL
+**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 ... \\
+<code>ALTER REPLICAT REPMOL01, EXTSEQNO <TRAILFILE_NO>, EXTRBA <TRAILFILE_POSITION></code>
+**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 ...
+<code>ADD EXTTRAIL <TRAIL_LOCATION>, EXTRACT <EXTRACT_NAME, MEGABYTES <TRAIL_FILE_SIZE></code>
+**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.