Question

4
Replies
1229
Views
Close popover
Satish Annam (SatishAnnam)
Standard Chartered Bank

Standard Chartered Bank
IN
SatishAnnam Member since 2017 2 posts
Standard Chartered Bank
Posted: February 21, 2018
Last activity: February 26, 2018
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