Error During Grid Upload for Large Number of Line Items

In the Axpertlog table, we can track the duration of the import service. The browser typically waits up to 90 minutes before triggering a timeout error and stopping the process.

We need to analyze the SQL queries within the grid and evaluate their execution costs. During the import process, these queries are executed for each row, which can significantly increase the overall time required.

My situation is straightforward: I have a single transaction with 15 columns, which is a relatively simple query. The grid displays a maximum of 4 rows per entry, resulting in a total of around 500 records. In Excel, this amounts to fewer than 1,000 rows.

Could we schedule a call for 11 a.m. today, if that works for you?

As discussed in the meeting, the browser has a 90-second load time limit. If the data load exceeds this duration, a timeout error will occur. Please adjust the query to ensure that records load within this 90-second window on the web. Additionally, create a dummy screen to test the scenario as we discussed.

There is a developer option called "WebService Timeout" that allows you to extend the timeout for a specific tstruct. The default value is set to 100,000 milliseconds, but you can increase it if needed.

To adjust this setting:

1. Go to Settings → Developer Options.
2. Select WebService Timeout in the Property Field.
3. Enter the desired time in the Property Value field.
4. Choose the relevant form name.
5. Save the changes.

Please note that this setting should be used with caution, as it will extend the timeout for all calls within that tstruct, not just for imports.