Reports in COINS ERP+ can time out when processing large volumes of data or complex queries. This is a protective feature, not an error condition. It prevents reports from running indefinitely and consuming excessive system resources.
Reports can time out under the following conditions:
Large datasets: processing extensive data takes longer than the configured timeout.
Complex queries: intricate calculations or joins require more processing time.
System load: high server activity slows report execution.
Configuration: the SY/WEBPTO system parameter is set too low for the report’s needs.
If not explicitly configured, the default setting for SY/WEBPTO is 30 seconds (30,000 milliseconds). Do not increase the SY/WEBPTO parameter beyond its default value without consulting COINS first, as doing so can cause system delays and negatively impact overall performance.
Best practices to avoid timeouts
Use Print instead of Export.
The Print option runs reports in the background and allows you to download them later from the Report Status screen.
Limit fields and records.
Avoid selecting all available fields for large workbenches. There is a hardcoded limit of 100 fields to prevent exceeding the 32k character limit.
Run multiple smaller reports.
Break down large exports into smaller, manageable reports.