Error: F_JD21BA DBMS Error: Relation Does Not Exist

Issue

After activation and refresh, integrate jobs fails with the following error:

F_JD21BA: DBMS error [ERROR: relation "dds.hvr_<channelname>_<targetlocationname>" does not exist LINE 1: update "dds"."dds.hvr_<channelname>_<targetlocationname>" set ^]. Last query [update "dds"."hvr_<channelname>_<targetlocationname>" set "is_busy" = $1, "tbl_name" = $2, "hvr_op" = $3]

Environment

• HVR 6
• Source: Oracle
• Target: Aurora PostgreSQL
• Channel: Oracle to Aurora PostgreSQL replication

Resolution

To resolve this issue, reactivate the target location and restart the integrate job:

1. Rerun activation and initialization for the affected target location using the HVR UI or CLI. Select the State Tables and Burst/Change Tables, and ensure you use the correct hub connection details. When using the CLI, include the following options for the affected channel:

   -l <target_location> -o sc
   

2. Confirm that the missing internal tables are recreated.
3. Restart the integrate job.

Cause

This issue occurs when target database maintenance deletes HVR internal tables. A channel refresh doesn't recreate these tables because state and burst/change tables must be explicitly initialized during activation.