My Oracle Support Banner

Delete a Data Load Rule Gives Error: "ORA-00040: active time limit exceeded - call aborted" Delete a Data Load Rule (Doc ID 2611144.1)

Last updated on MARCH 02, 2020

Applies to:

Oracle Planning and Budgeting Cloud Service - Version 18.01.42 and later
Information in this document applies to any platform.

Symptoms

On : NA version, Financial Data Quality Management EE

When attempting to delete a Data Load Rule, it does not get deleted.

There were no errors showing up in the UI.

But the aif-WebApp.log had the following errors -
[2019-11-14T16:48:29.746+00:00] [EPMServer0] [ERROR] [] [oracle.apps.erpi.model] [tid: [STUCK].ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: USERID] [ecid: ECID] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.data.userinterface.backing.DataRuleBacking] [SRC_METHOD: deleteRule] An error occured while deleting data rule[[
java.sql.SQLException: ORA-00040: active time limit exceeded - call aborted

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)

Changes

When a data rule is deleted, we delete all the data associated with it. If the rule is associated with a lot of data, the deletion of data will take time.
On PBCS, Oracle Ops team has implemented resource management limits so the SQL statements that exceed the threshold. It gets terminated with "ORA-40: active time limit exceeded" error.
 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.