Timeout period elapsed for SQL Server - SmartPlant Foundation - IM Update 46 - Help - Hexagon

SmartPlant Foundation Help

Language
English
Product
SmartPlant Foundation
Search by Category
Help
SmartPlant Foundation / SDx Version
10
SmartPlant Markup Plus Version
10.0 (2019)
Smart Review Version
2020 (15.0)

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 SmartPlant Foundation 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.