APEX Application Fails with "ORA-00040 Active Timeout Reached. Call Aborted" on the Database Cloud Schema Service
Last updated on NOVEMBER 20, 2017
Applies to:Oracle Database Cloud Service - S5 - Version N/A and later
Oracle Database Cloud Service - S20 - Version N/A and later
Oracle Database Cloud Service - S50 - Version N/A and later
Information in this document applies to any platform.
When uploading data through an APEX application on the Database Cloud Schema Service, the application fails with the following error:
1 error has occurred
ORA-00040: active time limit has exceeded.
This error does not occur when using a on a smaller .csv file that has a smaller amount of data, but fails with a larger .csv file that contains a larger amount of data.
This failure occurs when running through the customer application, but not when running through the standard data loading in SQL Workshop.
A similar error can also be at install time when importing large applications. The error seen is:
ORA-20001: WWV_FLOW_API.ERR_REPORT_LAYOUT_CREATE ORA-00040: active time limit exceeded - call aborted
Return to application.
How do you resolve this error?
Migrating and APEX application from on-premise to the Oracle Database Cloud Service (DBCS) and Application Express (APEX).
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms