- August 12, 2019 at 11:34 am #22205
Problem Summary: Resolving HVR error F_JD21B4 which indicates ORA-00942 table or view not found or DBMS error [Invalid object name]
Tag: 28988, 29072
This is a screen shot 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)
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 techical 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.
You must be logged in to reply to this topic.