Differences

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

--- error_messages [2016/10/11 15:11] – [Ignored Issues] z0hpvk
+++ error_messages [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 4: / Line 4: @@
 ==== Supplemental Log Data Issues ====
-OGG-01161  Bad column index (5) specified for table \\
+**OGG-01161**  Bad column index (5) specified for 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 ... \\
+**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. \\
@@ Line 15: / Line 15: @@
 ALTER TABLE <TABLE_NAME> ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;</code>
-Now you should be able to remove the comment and restart the replicat process.
+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-00446  No data selecting position from checkpoint table GGATE.CHKPTAB ... \\
+This error message is particular to GoldenGate 11g only and applies only to extracts.\\
-OGG-01044  The trail '...' is not assigned to extract '...' \\
+When using CDR I had to use the parameter NODYNAMICRESOLUTION.\\
-OGG-01224  TCP/IP error 146 (Connection refused) \\
+Then, further down the parameter file, switch back to DYNAMICRESOLUTION and include the DDL parameters and Wildcard parameters. \\
-OGG-01296  Error mapping from ... to ... \\
-OGG-01496  Failed to open target trail file \\
+**OGG-00446**  No data selecting position from checkpoint table GGATE.CHKPTAB ... \\
-OGG-01907  Null column COMMENT_COUNT cannot be used in delta resolution \\
+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.