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:
-
In Server Manager, expand your site node, and select the Settings node.
-
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.