Error: F_JD21D5: The Above Error Occurred While Attempting To Execute SQL Statement

Issue

While testing a connection to a database, the following error appears:

F_JD21D5: The above error occurred while attempting to execute SQL statement(s) from environment variable HVR_SQL_INIT

Environment

• HVR 5

Resolution

HVR_SQL_INIT is an environment variable sometimes added to a channel to avoid locking the target tables when running HVR Compare. The above error may appear when one of the channels for this hub has this variable set.

When running a test connection to the database, HVR may pick up this variable, successfully connect to the database, then attempt to run the statement even if it is incorrect for that database type, such as Oracle.

This error does not cause any issues when received during a test connection. Since the reported error is a database error, it confirms that HVR has successfully connected to the database.

After receiving this error, you can continue to create channels without issues. If you are unable to create channels, contact our support team.