Problem Summary: F_JD21B4 which indicates ORA-00942 table or view not found

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #22205

    Donna Zehl
    Keymaster

    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

     

    Description:

    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)

     

     

    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 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.

     

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

© 2019 HVR

Live demo Contact us