Timeout errors on SQL server - HxGN SDx - Update 63 - Administration & Configuration

Administration and Configuration of HxGN SDx

Language
English
Product
HxGN SDx
Search by Category
Administration & Configuration
SmartPlant Foundation / SDx Version
10

Error Message

Timeout expired. The timeout period elapsed prior to completion of the operation, or the server is not responding.

Problem

Timeout errors occur on a SQL Server site when loading published documents and executing queries.

Solution

Run the following SQL on your database. Replace <Databasename> with the name of your database.

ALTER DATABASE <Databasename> SET READ_COMMITTED_SNAPSHOT ON.

If the errors persist, then increase the value for the DBCommandTimeoutSeconds setting for your site. This property is available in HxGN SDx Server Manager, on the Settings node under each site node.

This issue is specific to SQL Server.