Error: F_JD22D4 DBMS Error ERROR: Syntax Error at or Near "OFF" LINE 1: SET NOCOUNT OFF

Issue

The following errors appear:

• F_JD22D4 DBMS error [ERROR: syntax error at or near "OFF" LINE 1: SET NOCOUNT OFF ^]
• F_JD21D5 The above error occurred while attempting to execute SQL statement(s) from Environment variable DSS_SQL_INIT with value SET NOCOUNT OFF
• F_JR057A The previous error occurred while connecting to the repository.
• F_JW0513 The previous error occurred during start of worker 'w7'.

Environment

• DSS 6
• Database: PostgreSQL
• Configuration: Worker_Environment property set at the Hub level.

Resolution

To resolve this issue, do the following:

1. Go to the $DSS_CONFIG/etc/dsshubserver.conf file on the Hub server.
2. Locate the Worker_Environment property in the file, then remove the DSS_SQL_INIT entry with the value SET NOCOUNT OFF from the JSON string.
3. Save the updated configuration file.
4. Restart the DSS service on the Hub server.

Cause

PostgreSQL does not support the SET NOCOUNT OFF command. As a result, this issue occurs when you configure the environment variable DSS_SQL_INIT with the value SET NOCOUNT OFF through the Worker_Environment property at the Hub level.