Re: extract failing for 1 table OGG-01004

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

Interesting..

1)Do you see any syntax errors when you copy&paste the following SQL into TOAD or similar editor and check?

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

2)Do you have some blank CLOBS in those tables?
Check with LENGTH(blabla."Value") > 0..

Blank CLOBS may be causing this.

3)Also send me the definition of the tables in question + GG version + versions of the related databases.