extract failing for 1 table OGG-01004

Posted by Roshan on Sep 16, 2019; 8:37am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/extract-failing-for-1-table-OGG-01004-tp7666.html

Oracle Golden Gate 18.0

Solaris 11.4

 

Hi,

 

I am getting error below for 1 table whenever I start replication

 

019-09-14 06:41:57 WARNING OGG-02544 Unhandled error (ORA-00907: missing right parenthesis) while processing the record at SEQNO 50, RBA 320085425 in Integrated mode. REPLICAT will retry in Direct mode.

2019-09-14 06:41:57 WARNING OGG-01004 Aborted grouped transaction on CBSOGG.WF_WORKFLOW, Database error 907 (OCI Error ORA-00907: missing right parenthesis (status = 907), SQL <UPDATE /*+ CURSOR_SHARING_EXACT */ "CBSOGG"."WF_WORKFLOW" x SET x."WRKFLW_DATA_X" = updatexml(x."WRKFLW_DATA_X", '/WorkFlow/Activity[@sequenceNumber='jsx_c37851']', NULL, '/WorkFlow/Activity/DependentParents/DependentActivity[@sequenceNumber='jsx_c37851']', NULL, 'xmlns:xd="http://xmlns.oracle.com/xdb/xdiff.xsd" ') WHERE x."WRKFLW_INSTANCE_ID_N" = :b0>).

2019-09-14 06:41:57 WARNING OGG-01003 Repositioning to rba 320084771 in seqno 50.

2019-09-14 06:41:57 WARNING OGG-01154 SQL error 907 mapping CLM_TT.WF_WORKFLOW to CBSOGG.WF_WORKFLOW OCI Error ORA-00907: missing right parenthesis (status = 907), SQL <UPDATE /*+ CURSOR_SHARING_EXACT */ "CBSOGG"."WF_WORKFLOW" x SET x."WRKFLW_DATA_X" = updatexml(x."WRKFLW_DATA_X", '/WorkFlow/Activity[@sequenceNumber='jsx_c37851']', NULL, '/WorkFlow/Activity/DependentParents/DependentActivity[@sequenceNumber='jsx_c37851']', NULL, 'xmlns:xd="http://xmlns.oracle.com/xdb/xdiff.xsd" ') WHERE x."WRKFLW_INSTANCE_ID_N" = :b0>.

 

 

I have checked with Oracle and they say it is related to clob column in tables which has some syntax issue. Please check the clob value to fix the issue.

 

Application team have no idea of this error. Please advise.

 

Regards,

 

Roshan