Issue

The following error appears when testing a connection on a location:

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

Environment

Local Data Processing

Resolution

HVR_SQL_INIT is an environment variable that is sometimes added to a channel to avoid locking of the target tables when running HVR compare. The error F_JD21D5 may sometimes be returned from a Test Connection when one of the channels for this hub has this variable set.

The underlying cause for this is when doing a Test Connection to the database, HVR may pick up this variable and after successfully connecting to the database, try to run the statement even if it is not correct for that database type (such as Oracle) and get a syntax error.

This is a harmless error when received as a result of a Test Connection. In fact, since it reports a database error, it confirms that HVR has in fact successfully connected to the database. This error will still allow you to create channel as you would create any other channel.

However, if after receiving this error you are not able to create channels or if you run into other issues, please log a support ticket.