User Import Mechanism

[delvs77]

I'm currently using Checkbox 4.5.3.46. I'm having difficultly importing users into the Checkbox survey system via the user import utility.

Approximately 80 seconds after the import begins I receive an error message: "Request Timed Out".

Here are the details of the import:
total record count: 3475
total fields per record: 17
format: comma delimited

The time out occurs approximately 1200 records into the process.

I tried changing various memory settings on the destination SQL server. I also changed some time out settings in IIS and still no luck.

When the web process times out, the SQL spid goes from runnable to sleeping and blocks part of the table in doing so. Eventually (after about 5 minutes) the spid will stop and the import will be incomplete.

Does anyone have any ideas on how I can get around this? Is there a setting somewhere that needs change to increase the timeout?

[pwiesner]

It sounds like you are exceeding the maximum execution timeout. By default ASP.NET sets the timeout to 110 seconds.

The following setting is most likely not in your web.config and as a result the default values are being used. Please add the following under the <system.web> node in your web.config file:

<httpRuntime
executionTimeout="110 - WILL NEED TO CHANGE"
maxRequestLength="4096 - WILL NEED TO CHANGE"
/>

Please note that these are the default values. You will need to substitute larger values as is appropriate for your environment and files. ExecutionTimeout is measured in seconds and maxRequestLength in kilobytes.

[delvs77]

This solved the problem. Thanks for your help today. I'm impressed with the level of support that you provided.