{"id":7012,"date":"2019-03-26T14:58:38","date_gmt":"2019-03-26T14:58:38","guid":{"rendered":"https:\/\/ittutorial.org\/?p=7012"},"modified":"2021-06-08T06:14:57","modified_gmt":"2021-06-08T06:14:57","slug":"ogg-01296-error-mapping-from-ogg-01154-sql-error-in-goldengate","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/ogg-01296-error-mapping-from-ogg-01154-sql-error-in-goldengate\/","title":{"rendered":"OGG-01296 Error mapping from OGG-01154 SQL error in Goldengate"},"content":{"rendered":"<p>Hi,<\/p>\n<p>You can get frequently &#8221; OGG-01296 Error mapping from OGG-01154 SQL error &#8221; error from Goldengate.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5119\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/01\/oracle_goldengate.png\" alt=\"\" width=\"574\" height=\"211\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/01\/oracle_goldengate.png 574w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/01\/oracle_goldengate-300x110.png 300w\" sizes=\"auto, (max-width: 574px) 100vw, 574px\" \/><\/p>\n<p><!--more--><\/p>\n\n<p>&nbsp;<\/p>\n<h1><span style=\"color: #ff0000;\">OGG-01296 Error mapping from<\/span><\/h1>\n<p>Goldengate replicat is abended with &#8221; OGG-01296 Error mapping from &#8221; error like below.<\/p>\n<p>&nbsp;<\/p>\n<pre>GGSCI (MehmetSalih) 1&gt; info REPDEV\r\n\r\nREPLICAT REPDEV Last Started 2019-02-28 10:03 Status ABENDED\r\nCheckpoint Lag 00:00:03 (updated 03:11:14 ago)\r\nLog Read Checkpoint File \/data\/Goldengate\/dirdat\/rt059801\r\n2019-03-26 14:15:20.257167 RBA 11016012<\/pre>\n<p>&nbsp;<\/p>\n<p>I have checked replicat report file with following command.<\/p>\n\n<p>&nbsp;<\/p>\n<pre>GGSCI (MehmetSalih) 5&gt; view report REPDEV<\/pre>\n<p>&nbsp;<\/p>\n<pre>2019-03-26 17:26:54 WARNING OGG-00869 OCI Error ORA-20000: \r\nORA-06512: at \"DEVECI.GG_TEST_TABLE\", line 9\r\nORA-04088: error during execution of trigger 'DEVECI.GG_TEST_TABLE' (status = 20000), SQL &lt;INSERT INTO \"DEVECI\".\"GG_TEST_TABLE2\" (\"ACCOUNTID\",\"CREATETSTAMP\",\"C\r\n\",\"EXTERNALID\",\"BILLNUMBER\",\"NAME\",\"IPID\",\"HEALTHPLANID\",\"HEA&gt;.\r\n\r\n2019-03-26 17:26:54 WARNING OGG-01004 Aborted grouped transaction on 'DEVECI.GG_TEST_TABLE2', Database error 20000 (OCI Error ORA-20000: \r\n***\r\nORA-06512: at \"DEVECI.GG_TEST_TABLE\", line 9\r\nORA-04088: error during execution of trigger 'DEVECI.GG_TEST_TABLE' (status = 20000), SQL &lt;INSERT INTO \"DEVECI\".\"GG_TEST_TABLE2\" (\"ACCOUNTID\",\"CREATETSTAMP\",\"C\r\n\",\"EXTERNALID\",\"BILLNUMBER\",\"NAME\",\"IPID\",\"HEALTHPLANID\",\"HEA&gt;).\r\n\r\n2019-03-26 17:26:54 WARNING OGG-01003 Repositioning to rba 11016012 in seqno 59801.\r\n\r\n2019-03-26 17:26:54 WARNING OGG-01154 SQL error 20000 mapping DEVECI.GG_TEST_TABLE2 to DEVECI.GG_TEST_TABLE2 OCI Error ORA-20000: \r\nORA-06512: at \"DEVECI.GG_TEST_TABLE\", line 9\r\nORA-04088: error during execution of trigger 'DEVECI.GG_TEST_TABLE' (status = 20000), SQL &lt;INSERT INTO \"DEVECI\".\"GG_TEST_TABLE2\" (\"ACCOUNTID\",\"CREATETSTAMP\",\"C\r\n\",\"EXTERNALID\",\"BILLNUMBER\",\"NAME\",\"IPID\",\"HEALTHPLANID\",\"HEA&gt;.\r\n\r\n2019-03-26 17:26:54 WARNING OGG-01003 Repositioning to rba 11016012 in seqno 59801.\r\n\r\nSource Context :\r\nSourceModule : [er.main]\r\nSourceID : [\/scratch\/angorant\/view_storage\/angorant_ogg_12978807_x64\/oggcore\/OpenSys\/src\/app\/er\/rep.c]\r\nSourceFunction : [take_rep_err_action]\r\nSourceLine : [16134]\r\nThreadBacktrace : [8] elements\r\n: [\/data1\/Goldengate\/replicat(CMessageContext::AddThreadContext()+0x26) [0x5f0516]]\r\n: [\/data1\/Goldengate\/replicat(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x7b2) [0x5e6fe2]]\r\n: [\/data1\/Goldengate\/replicat(_MSG_ERR_MAP_TO_TANDEM_FAILED(CSourceContext*, DBString&lt;777&gt; const&amp;, DBString&lt;777&gt; const&amp;, CMessag\r\n: [\/data1\/Goldengate\/replicat [0x83178f]]\r\n: [\/data1\/Goldengate\/replicat [0x90e282]]\r\n: [\/data1\/Goldengate\/replicat(main+0x84b) [0x507deb]]\r\n: [\/lib64\/libc.so.6(__libc_start_main+0xf4) [0x31f261d9c4]]\r\n: [\/data1\/Goldengate\/replicat(__gxx_personality_v0+0x1da) [0x4e43ca]]\r\n\r\n<span style=\"color: #ff0000;\"><strong>2019-03-26 17:26:54 ERROR OGG-01296 Error mapping from DEVECI.GG_TEST_TABLE2 to DEVECI.GG_TEST_TABLE2.<\/strong><\/span><\/pre>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<h2><span style=\"color: #ff0000;\">OGG-01154 SQL error<\/span><\/h2>\n<p>When you get &#8221;\u00a0OGG-01296 Error mapping from &#8221; error, firstly check replicat table constraints and triggers.<\/p>\n<p>&nbsp;<\/p>\n<p>You can also see that replicat report file says &#8221;\u00a0ORA-04088: error during execution of trigger &#8221; error.<\/p>\n<p>So when I check related table triggers and constraints, problem is occured because of trigger.<\/p>\n<p>&nbsp;<\/p>\n<p>I have disabled triggers with following command.<\/p>\n<pre>alter trigger TRIGGER_NAME disable;\r\n\r\n<\/pre>\n\n<p>&nbsp;<\/p>\n<p>You can disabled all triggers with following command.<\/p>\n<pre>--\u00a0trigger enable \/ disable\r\nALTER TRIGGER trigger_name ENABLE;\r\nALTER TRIGGER trigger_name DISABLE;<\/pre>\n<p>&nbsp;<\/p>\n<pre>-- enable \/ disable all triggers for a specific table\r\nALTER TABLE table_name ENABLE ALL TRIGGERS;\r\nALTER TABLE table_name DISABLE ALL TRIGGERS;\r\n\r\n<\/pre>\n\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">After disabling triggers I have started replicat and it is run and try to reduce lag.<\/span><\/strong><\/p>\n<p>&nbsp;<\/p>\n<pre>GGSCI (MehmetSalih) 7&gt; start REPDEV\r\n\r\nSending START request to MANAGER ...\r\nREPLICAT REPDEV starting\r\nREPLICAT REP9 is already running.\r\n\r\n\r\nGGSCI (MehmetSalih) 8&gt; info REPDEV\r\n\r\nREPLICAT REPDEV Last Started 2019-03-26 17:29 Status RUNNING\r\nCheckpoint Lag 00:00:03 (updated 03:14:13 ago)\r\nLog Read Checkpoint File \/data\/Goldengate\/dirdat\/rt059801\r\n2019-03-26 14:15:20.257167 RBA 11016012\r\n\r\n\r\nGGSCI (MehmetSalih) 35&gt; !\r\ninfo REPDEV\r\n\r\nREPLICAT REPDEV Last Started 2019-03-26 17:29 Status RUNNING\r\nCheckpoint Lag 02:49:31 (updated 00:00:00 ago)\r\nLog Read Checkpoint File \/data\/Goldengate\/dirdat\/rt059802\r\n2019-03-26 14:52:53.259983 RBA 42593328\r\n\r\n\r\nGGSCI (MehmetSalih) 36&gt; !\r\ninfo REPDEV\r\n\r\nREPLICAT REPDEV Last Started 2019-03-26 17:29 Status RUNNING\r\nCheckpoint Lag 02:49:24 (updated 00:00:00 ago)\r\nLog Read Checkpoint File \/data\/Goldengate\/dirdat\/rt059802\r\n2019-03-26 14:53:03.259848 RBA 42958057\r\n\r\n<\/pre>\n\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #ff0000;\">Do you want to learn Oracle Goldengate, then read the following articles.<\/span><\/h4>\n<blockquote class=\"wp-embedded-content\" data-secret=\"iolpSLq3NP\"><p><a href=\"https:\/\/ittutorial.org\/goldengate-tutorials-oracle-for-beginners\/\">Oracle Goldengate Tutorials for Beginners<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Oracle Goldengate Tutorials for Beginners&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/goldengate-tutorials-oracle-for-beginners\/embed\/#?secret=SFnnD3Vrby#?secret=iolpSLq3NP\" data-secret=\"iolpSLq3NP\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, You can get frequently &#8221; OGG-01296 Error mapping from OGG-01154 SQL error &#8221; error from Goldengate.<\/p>\n","protected":false},"author":1,"featured_media":5119,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[2465],"tags":[7780,7781,2672,2781,2773,2517,2516,2780,2774,2486,2513,2515,2770,2473,2521,2520,2785,2514,7784,10827,8543,2775,8544,2777,2776,2778,10829,2772,2771,13684,10828,4368,10830,2783,2782,2779],"class_list":["post-7012","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-goldengate","tag-allownonvalidatedkeys","tag-allownoopupdates","tag-database-tutorial","tag-enable-disable-all-triggers-for-a-specific-table","tag-error-ogg-01296-error-mapping-from","tag-gg-mon","tag-gg-monitor","tag-goldengate-error-mapping","tag-goldengate-error-ogg-01296-error-mapping-from","tag-goldengate-extract-process","tag-goldengate-monitor-script","tag-goldengate-monitoring-script","tag-goldengate-ogg-01296-error-mapping-from-ogg-01154","tag-goldengate-tutorial","tag-goldengate-useful-script","tag-goldengate-useful-scripts","tag-how-to-disable-oracle-trigger","tag-monitor-goldengate","tag-ogg-00199","tag-ogg-10103","tag-ogg-00665-oci-error-calling-ocitranscommit","tag-ogg-00869","tag-ogg-00870-database-error-27144","tag-ogg-01003","tag-ogg-01004","tag-ogg-01154","tag-ogg-01154-sql-error","tag-ogg-01296-error-mapping-from","tag-ogg-01296-error-mapping-from-ogg-01154","tag-ogg-01296-error-mapping-from-ogg-01154-sql-error","tag-ogg-01296-error-mapping-from-ogg-01154-sql-error-in-goldengate","tag-ogg-01668","tag-ora-04088-error-during-execution-of-trigger","tag-oracle-alter-trigger-trigger_name-disable","tag-oracle-enable-disable-all-triggers-for-a-specific-table","tag-warning-ogg-01003-repositioning-to-rba"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/01\/oracle_goldengate.png","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/7012","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=7012"}],"version-history":[{"count":5,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/7012\/revisions"}],"predecessor-version":[{"id":19490,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/7012\/revisions\/19490"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/5119"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=7012"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=7012"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=7012"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}