Non-Query Execution Failure

Before going through this section, see Prerequisites for Debugging Exceptions.

Issue:

Error on the Central Configuration: ExecuteNonQuery failed for the Database <databaseName>.

Probable Cause:

Workflow.NET.sql script located at <AVEVA Work Tasks installed path>\DatabaseScripts\SQLServer could not run on the database Instance.

Solution:

Run the Workflow.NET.sql file located at [ AVEVA Work Tasks Installed Folder]\DatabaseScripts\SQLServer on the Database manually and in case of any issues while running the script, contact support.

Recommended collation for the SQL server are:

• SQL_Latin1_General_CP1_CI_AS

• SQL_Latin1_General_CP1_CS_AS

Note: This is valid only for SQL Server data source type.