Issue

Integrate fails with the following error:

F_JD21B4: DBMS error [SQL compilation error: Object 'HVR_<table>_<table>' does not exist or not authorized].

Environment

5.x.x Multiple DBMS

Resolution

Re-initialize with State Tables and Scripts & Jobs to move forward.

Cause

The table mentioned in the error is created if burst is enabled for integrate, but in this case, there is no state table on the target so HVR is not able to complete the action and throws the error.