The Post is stopped due to error and the following messages appear in the event_log in a CDC (Change Data Capture or Change History) environment:
Info 2017-08-28 19:47:45.275078 15859 1911934688 Poster launched, pid = 15859 (posting from SID1, queue shareplex3, to SID2)
Warning 2017-08-28 19:48:57.810570 15859 1873299776 s:2 Poster: 15022 - Error posting ODR_INSERT1 to table "!CDC:TEST_DATA"."T_MYAPP_ORDERS_HIST". (posting from SID1, queue shareplex3, to SID2) [module opo]
Notice 2017-08-28 19:48:57.810939 15859 1873299776 s:2 Poster: Oracle error: ORA-00942: table or view does not exist. rowid:AAASwDAAGAAAABtAAA (posting from SID1, queue shareplex3, to SID2) [module opo]
Error 2017-08-28 19:48:57.810996 15859 1873299776 s:2 Poster stopped: Internal error encountered; cannot continue (posting from SID1, queue shareplex3, to SID2)
Notice 2017-08-28 19:48:57.811488 15859 1849716112 Poster: Last committed SCN 0. (posting from SID1, queue shareplex3, to SID2) [module opo]
Info 2017-08-28 19:48:57.813053 15857 1911934688 Poster exited with code=1, pid = 15859 (posting from SID1, queue shareplex3, to SID2).
The target table does exist.
Here is the config file
datasource:o.SID1
#source tables target tables routing map
TEST_DATA.T_MYAPP_ORDERS !cdc:TEST_DATA.T_MYAPP_ORDERS_HIST target_server_name@o.SID2
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