Post stopped due to error and the following errors showed up in event_log:
sp_ctrl>show log reverse
Info 2017-02-14 08:52:12.567126 16040 1 Poster exited with code=1, pid = 26573 (posting from sourceSID, queue queue_name, to targetSID)
Notice 2017-02-14 08:52:12.495536 26573 1 Poster: Shutting down by request (posting from sourceSID, queue queue_name, to targetSID) [module opo]
Error 2017-02-14 08:52:12.305177 26573 3 s:3 Poster: [SP-OPO01001] Post process stopped due to missing column "SHAREPLEX_OPERATION_SEQ" on target table "SHA86"."CDCTABLE". <CAUSE> Target table "SHA86"."CDCTABLE" is missing column "SHAREPLEX_OPERATION_SEQ". This is often caused by the target structure table not matching either the source table structure or the Post object cache structure. <ADVICE> Compare the source and target tables and add column if it is missing. Otherwise dump the Post object cache and then compare it with the table structure. Next, either correct the target table structure or copy the latest object cache from the source to the target. See 'http://advice.shareplex.com/SP-OPO01001' for additional advice and support. (posting from sourceSID, queue queue_name, to targetSID) [module opo]
Notice 2017-02-14 08:52:12.185105 26573 3 s:3 Poster: ORA-00904: "SHAREPLEX_OPERATION_SEQ": invalid identifier (posting from sourceSID, queue queue_name, to targetSID) [module osp]
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center