Question

4
Replies
1201
Views
SatishAnnam Member since 2017 2 posts
Standard Chartered Bank
Posted: 2 years ago
Last activity: 2 years 7 months ago
Closed
Solved

Maximum elapsed time in seconds for export

In one of our report definition we have below parameter values under data access

Maximum elapsed time in seconds: 60

Maximum elapsed time in seconds for export: 30

We happened to see below exception while exporting the retrieved data to excel through report.

SQLState 72000, Error code 1013: java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation

In few threads it says, configure the value in Maximum elapsed time in seconds for export parameter to be greater than or equal to the value in Maximum elapsed time inseconds parameter. Is it mandatory/advised to have Maximum elapsed time in seconds for export >= Maximum elapsed time inseconds.

Will there be any DB sessions or performance issue by increasing Maximum elapsed time in seconds for export from 30 seconds to 60 seconds.

Please guide with your valuable suggestions.

System Administration
Moderation Team has archived post
Share this page LinkedIn