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 SEPTEMBER 21, 2022

Applies to:

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

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