Differences

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

--- error_messages [2016/10/11 10:11] – [Other] 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>
+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] ...] \\
+**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 ... \\
+<code>DDLERROR 24344 DISCARD</code>
 ==== Memory Issues ====
-OGG-01841  CACHESIZE TOO SMALL \\
+**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. \\
+**OGG-00402**  WILDCARDRESOLVE parameter must be set to DYNAMIC when DDL replication is enabled. \\
-OGG-01224  TCP/IP error 146 (Connection refused) \\
+This error message is particular to GoldenGate 11g only and applies only to extracts.\\
-OGG-01496  Failed to open target trail file \\
+When using CDR I had to use the parameter NODYNAMICRESOLUTION.\\
-OGG-01044  The trail '...' is not assigned to extract '...' \\
+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 ... \\
-OGG-01907  Null column COMMENT_COUNT cannot be used in delta resolution \\
+**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.