Timeout period elapsed for SQL Server - HxGN SDx - Update 64 - 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 expire. The timeout period elapsed prior to completion of the operation or the server is not responding.

Problem

When performing exports of large data sets, such as data sets with 100,000 objects or more, the database Connection Timeout setting for the SQL Server site may need to be increased so that your specific SDx system does not close the SQL connection.

Solution

Use the following operation to increase the timeout value:

  1. In Server Manager, expand your site node, and select the Settings node.

  2. Double-click the Connection Timeout option, and increase the value provided. For example, 1200 seconds is the default. This value may need to be increased, depending on factors such as the system's processor speed, network speed, and so on.

For more information on the timeout setting to use, contact your system administrator.