Configure timeout and other settings for exporting large data sets - HxGN SDx - Update 31 - Installation & Upgrade

Installation and Setup for HxGN SDx Application Server

Language
English (United States)
Product
HxGN SDx
Search by Category
Installation & Upgrade
SmartPlant Foundation / SDx Version
10

The following default timeout settings are set in the Server Manager Settings node, the web.config file, and the IIS Application Server Manager in both the staging and target sites. When exporting large data sets using Data Validator, these default settings allow for the successful export of a data set of 50,000 documents, each with files attached less than 1 KB in size:

File name and location

Property

Default value

Site Settings node in SDx Server Manager

Connection Timeout [SQL Server]

1200 seconds

FileServiceTimeout

300000 seconds

InternalRequestTimeout

108000000 milliseconds

DBCommandTimeoutSeconds [Oracle]

108000 seconds

VTLExportFileUploadTimeout

108000000 milliseconds

VTLExportFileUploadBatchSize

25

Web.config file located at [Install drive]\SDx Server Files\Web_Sites\[your_SDVsite_name]

httpRuntime executionTimeout

108000 seconds

closeTimeout, openTimeout, receiveTimeout, and sendTimeout of netNamedPipeBinding, netTcpBinding, netTcpBindingNoSecurity

04:00:00 (hh:mm:ss)

closeTimeout of WebHttpBinding

00:59:00 (hh:mm:ss)

IIS Application Pools Advanced Settings

IdleTime-out (minutes) for site

0

IdleTime-out (minutes) for site FileService

0

If any timeouts are seen using these default settings, you can increase the settings for the larger data set, such as for 150,000 tags or more. However, any changes made are dependent on other factors, such as the system's setup, processor speed, network speed, and so on. Contact your administrator for the correct timeout setting.

When exporting large data sets using Data Validator, we also recommend that you increase the maximum number of worker processes for the SDx server application pool of your primary site for a successful export. For example, <Product_Short>Server. However, this is dependent on your system's setup.

File name and location

Property

Recommended value

IIS Application Pools Advanced Settings > [Primary Site]

Maximum Worker Processes for site

4

  • The optimal value to use is dependent on your system usage and available resources, such as the number of processors, number of applications, number of users, and so on.

  • If you are exporting a large data set of 10,000 or more documents with attached files, we recommend that the VTLExportFileUploadBatchSize property in the Site Settings node in the SDx Server Manager is set to 25.