Problem Summary: F_JD21B4 which indicates ORA-00942 table or view not found
Description:
This is a screenshot of the error when we tried to initialize the replication set.
Along with the error from the log file
2019-5-21T13:37:15+200: all-integ-edtrg: F_JD21B4: DBMS error [Invalid object name 'hvr_stisall_edtrg'. Statement(s) could not be prepared]. Last query select HVR_CAP_LOC NOT NULL VARCHAR2(5) HVR_TX_SEQ RAW(24) HVR_TX_COUNTDOWN NOT NULL NUMBER INTEG_ROWS_DONE NOT NULL NUMBER INTEG_BLOCKED NOT NULL NUMBER INTEG_UNBLOCKED NOT NULL NUMBER HISTORY_SCAN_START_TSTAMP NOT NULL NUMBER HISTORY_SCAN_START_ADDR NOT NULL VARCHAR2(50) HISTORY_EMIT_SEQ NOT NULL VARCHAR2(24)
Answer:
Each transaction performed by an integrate job contains an update statement to an integrate state table (named hvr_stin* or hvr_stis*). This allows log-based capture jobs to recognize the session name defined by an integrate job, but this is ignored by trigger-based capture jobs.
HVR_STINPLTABLES_<ABCD> is a hvr technical table or as refer to a state table.
If this table was not found in the target, re-initializing for the integrate location for the channel with options “Scripts and Jobs” and “State Tables” selected. This will recreate it then it will resolve your issue.