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

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 SDx 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.