Return
-
Title
Post core dump on LOB Operation and rowid caching -
Description
Post cored dumps and the debug opo log indicates this:
OPOLOG:
update "LODSTAR"."LSCHANNELCUTDATA" t set "VALUECODES"=:V001
where rowid=:V002 -
Cause
Post was not key caching the target rowid for the operations when it had an update to a lob column only.
-
Resolution
WORKAROUND:
Disable the object for posting and resync later.
Issue on the target system using the object ID of the source table as the value
sp_ctrl> set param SP_OPO_DISABLE_OBJECT_NUM <OBJ_ID>
sp_ctrl> start post
When you are ready to begin posting to the target table again, set SP_OPO_DISABLE_OBJECT_NUM to 0.
STATUS:
Issue fixed in version 5.1.7 and higher . The latest version of Shareplex for Oracle can be downloaded at: https://support.quest.com/shareplex/download-new-releases -
Defect ID
CR0087349