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

Installation and Setup for HxGN SDx Application Server

Language
English
Product
HxGN SDx
Search by Category
Installation & Upgrade

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 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 be set to 25.

  • If you are exporting a large data set using the http/https protocol, we recommend increasing the Maximum allowed content length (Bytes) setting to 3000000000 in the Edit Request Filtering Settings dialog box in the application pool of your primary site. This will prevent timeout issues when exporting large data sets.

File name and location

Property

Recommended value

IIS Application Pools Request Filtering > [Primary Site]

Maximum allowed content length (Bytes)

3000000000