PBCS: Getting Error ORA-00040: active time limit exceeded - call aborted
(Doc ID 2295562.1)
Last updated on SEPTEMBER 28, 2023
Applies to:
Oracle Planning and Budgeting Cloud Service - Version N/A to N/A [Release 11.1]Hyperion Financial Data Quality Management, Enterprise Edition - Version 11.1.2.4.000 and later
Information in this document applies to any platform.
Symptoms
Customer is getting the following error:
2017-07-18 19:22:58,711 DEBUG [AIF]: Number of Rows deleted from TDATASEG: 0
2017-07-18 19:22:58,712 DEBUG [AIF]: CommData.purgeInvalidRecordsTDATASEG - END
2017-07-18 19:22:58,712 DEBUG [AIF]: AIFUtil.callOdiServlet - START
2017-07-18 19:22:58,733 INFO [AIF]: EssbaseService.exportData - START
2017-07-18 19:22:58,799 DEBUG [AIF]: appId:5, appType:HPL, mcFlag:false, dataLoadMethod:CLASSIC_VIA_EPMI, mDataFlowNode:LOCAL, textDataLoad:Y, isFccsLoad:false, isJournalLoad:false
2017-07-18 19:22:58,800 DEBUG [AIF]: LOAD_METHOD:HCM, LOAD_TYPE:DATA, EXPORT_MODE:REPLACE_DATA, CREATE_DRILL_REGION:false, PURGE_DATA_FILE:true, BATCH_SIZE:10000
2017-07-18 19:22:58,892 INFO [AIF]: cloudServiceType: Planning, Resolved user name for application access: cpatterson
2017-07-18 19:22:59,169 ERROR [AIF]: EPMFDM-140145:Application OPPLAN could not be found on Essbase server
2017-07-18 19:22:59,175 DEBUG [AIF]: Defaulting data load dimension to: Scenario
2017-07-18 19:22:59,175 DEBUG [AIF]: Defaulting driver dimension to: Account
2017-07-18 19:22:59,175 DEBUG [AIF]: dataLoadDim: Scenario, driverDim: Account
2017-07-18 19:22:59,175 DEBUG [AIF]: SELECT * FROM ( SELECT SCENARIO,ACCOUNT,DATA,'"'||ENTITY||','||UD1||','||UD2||','||UD3||','||UD4||','||YEAR||','||PERIOD||'"' "Point-of-View"
,'Finance' "Data Load Cube Name" FROM AIF_HS_BALANCES WHERE LOADID = 686 )
PIVOT XML( MAX(DATA) FOR (ACCOUNT) IN (SELECT ACCOUNT FROM AIF_HS_BALANCES WHERE LOADID = 686) )
2017-07-18 19:22:59,179 INFO [AIF]: Creating data file: /u03/inbox/outbox/OPPLAN_686.dat
2017-07-18 19:27:10,473 ERROR [AIF]: java.sql.SQLException: ORA-00040: active time limit exceeded - call aborted
Changes
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 |