APEX Application Fails with "ORA-00040 Active Timeout Reached. Call Aborted" on the Database Cloud Schema Service

(Doc ID 1606668.1)

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms