Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When i tired changing the Transactional apply to Batch Optimized in replicate and resume the cdc I'm getting an error that Unable to get table definition for table '0'. I tired to reload the target tables and after the full load has completed that error again came up and stopped the task. Does anyone have any ide of why is this happening?
Below is what came up in the log file.
00014984: 2020-11-12T22:19:30 [SOURCE_CAPTURE ]E: Unable to get table definition for table '0' [1021802] (oracle_endpoint_capture.c:658)
00013432: 2020-11-12T22:19:30 [TASK_MANAGER ]I: Task error notification received from subtask 0, thread 0, status 1021802 (replicationtask.c:2938)
00014984: 2020-11-12T22:19:30 [SOURCE_CAPTURE ]E: Error executing command [1021802] (streamcomponent.c:2007)
00014984: 2020-11-12T22:19:30 [TASK_MANAGER ]E: Stream component failed at subtask 0, component st_0_Dev Source [1021802] (subtask.c:1368)
00014984: 2020-11-12T22:19:30 [SOURCE_CAPTURE ]E: Stream component 'st_0_Dev Source' terminated [1021802] (subtask.c:1537
The error you are seeing points to a problem in the process that is reading the changes from the source, this is not related to the apply of changes to the target (transactional apply vs. bulk apply is target related).
It would help if you turned on "trace" for "source_capture" logger and rerun the scenario.
@OritCuriel I have set Trace for source_capture and saw some sql statements that was being executed. Out of which I saw one only one statement having trouble executing.
00001920: 2021-02-11T10:36:14 [SOURCE_CAPTURE ]T: Going to execute the statement 'select 1 from GV$TRANSACTION where 1=0 ' (oracle_endpoint_utils.c:3067)
When i ran this query in oracle I'm getting this error.
ORA-00942: table or view does not exist
Same came in the log.
00001920: 2021-02-11T10:36:14 [SOURCE_CAPTURE ]T: ORA-00942: table or view does not exist [1020416] (oracle_endpoint_utils.c:3077)
Other than that i couldn't find any other issues in the log.
@OritCuriel Actually there is one more error in the log
00001920: 2021-02-11T10:36:14 [SOURCE_CAPTURE ]T: Going to execute the statement 'drop directory attrep_dir_test' (without select) (oracle_endpoint_utils.c:3105)
00001920: 2021-02-11T10:36:14 [SOURCE_CAPTURE ]T: ORA-01031: insufficient privileges [1022317] (oracle_endpoint_utils.c:3115)
Also I tried executing these statement in another region in which I didn't have any issue in resuming the task and the same error came up.
I'm not able to resume CDC for this particular task.