- August 12, 2019 at 11:34 am #22205Donna ZehlKeymaster
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.