Database timeout for Oracle or 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

SPF.Server.SPFException: Failed to Execute Stored Procedure ---> Oracle.DataAccess.Client.OracleException: ORA-01013: user requested cancel of current operation

or

ORA-01013: user requested cancel of current operation

Problem

When performing exports of large data sets, such as data sets with 250,000 objects or more, the database timeout setting for the staging site may need to be increased so that your specific SmartPlant Foundation system does not close the Oracle or 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 DBCommandTimeoutSeconds option, and increase the value provided. The default value is 108000 seconds (30 hours). This value can be increased or decreased, 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.