Question

4
Replies
1335
Views
Satish Annam (SatishAnnam)
Standard Chartered Bank
Sr Technical Manager
Standard Chartered Bank
IN
SatishAnnam Member since 2017 2 posts
Standard Chartered Bank
Posted: February 21, 2018
Last activity: February 26, 2018
Posted: 21 Feb 2018 11:41 EST
Last activity: 26 Feb 2018 5:35 EST
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 in seconds parameter. Is it mandatory/advised to have Maximum elapsed time in seconds for export >= Maximum elapsed time in seconds.

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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.