Applying the latest RSA Identity Governance and Lifecycle 7.0.0 P02 or P03 generates error "java.sql.SQLException: ORA-04068: existing state of packages has been discarded"
Originally Published: 2016-09-02
Article Number
Applies To
RSA Version/Condition: 7.0 P02 and P03
Issue
03/30/2016 08:25:49.455 ERROR (Exec Task Consumer#0) [com.aveksa.server.xfw.TaskExecutor] Failed method=Execute ExecutionTask[TaskID=53 RunID=22 S
ource=1 Type=DataObjectProcessing Status=InProgress]
com.aveksa.server.xfw.ExecutionException: com.aveksa.server.collector.DataProcessorException: com.aveksa.server.db.PersistenceException:
java.sql.SQLException: ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package "AVUSER.COMMON_CONSTANTS_PKG" has been invalidated
ORA-04065: not executed, altered or dropped package "AVUSER.COMMON_CONSTANTS_PKG"
ORA-06508: PL/SQL: could not find program unit being called: "AVUSER.COMMON_CONSTANTS_PKG"
ORA-06512: at "AVUSER.REFERENCE_RESOLUTION_PKG", line 1471
ORA-04061: existing state of package "AVUSER.COMMON_CONSTANTS_PKG" has been invalidated
ORA-04065: not executed, altered or dropped package "AVUSER.COMMON_CONSTANTS_PKG"
ORA-06508: PL/SQL: could not find program unit being called: "AVUSER.COMMON_CONSTANTS_PKG"
ORA-06512: at "AVUSER.REFERENCE_RESOLUTION_PKG", line 1379
ORA-06512: at "AVUSER.ADC_TABLES", line 137
ORA-06512: at "AVUSER.ADC_DATA_COLLECTOR", line 166
ORA-06512: at "AVUSER.ADC_DATA_COLLECTOR", line 450
ORA-06512: at line 1
at com.aveksa.server.xfw.DataObjectProcessingExecutor.executeFullTask(DataObjectProcessingExecutor.java:119)
at com.aveksa.server.xfw.DataObjectProcessingExecutor.executeTask(DataObjectProcessingExecutor.java:58)
at com.aveksa.server.xfw.TaskExecutor.execute(TaskExecutor.java:99)
at com.aveksa.server.xfw.ExecutionTaskQueue$Worker.run(ExecutionTaskQueue.java:116)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.aveksa.server.collector.DataProcessorException: com.aveksa.server.db.PersistenceException: java.sql.SQLException:
ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package "AVUSER.COMMON_CONSTANTS_PKG" has been invalidated
ORA-04065: not executed, altered or dropped package "AVUSER.COMMON_CONSTANTS_PKG"
ORA-06508: PL/SQL: could not find program unit being called: "AVUSER.COMMON_CONSTANTS_PKG"
ORA-06512: at "AVUSER.REFERENCE_RESOLUTION_PKG", line 1471
ORA-04061: existing state of package "AVUSER.COMMON_CONSTANTS_PKG" has been invalidated
ORA-04065: not executed, altered or dropped package "AVUSER.COMMON_CONSTANTS_PKG"
ORA-06508: PL/SQL: could not find program unit being called: "AVUSER.COMMON_CONSTANTS_PKG"
ORA-06512: at "AVUSER.REFERENCE_RESOLUTION_PKG", line 1379
ORA-06512: at "AVUSER.ADC_TABLES", line 137
ORA-06512: at "AVUSER.ADC_DATA_COLLECTOR", line 166
ORA-06512: at "AVUSER.ADC_DATA_COLLECTOR", line 450
ORA-06512: at line 1
at com.aveksa.server.xfw.DefaultAccountObjectDataFilter.loadData(DefaultAccountObjectDataFilter.java:110)
at com.aveksa.server.xfw.DefaultAccountObjectDataFilter.process(DefaultAccountObjectDataFilter.java:72)
at com.aveksa.server.xfw.DefaultAccountObjectDataFilter.process(DefaultAccountObjectDataFilter.java:60)
at com.aveksa.server.xfw.DataProcessor.process(DataProcessor.java:85)
at com.aveksa.server.xfw.DataProcessor.process(DataProcessor.java:64)
at com.aveksa.server.xfw.DataObjectProcessingExecutor.executeFullTask(DataObjectProcessingExecutor.java:116)
... 4 more
Caused by: com.aveksa.server.db.PersistenceException: java.sql.SQLException: ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package "AVUSER.COMMON_CONSTANTS_PKG" has been invalidated
ORA-04065: not executed, altered or dropped package "AVUSER.COMMON_CONSTANTS_PKG"
ORA-06508: PL/SQL: could not find program unit being called: "AVUSER.COMMON_CONSTANTS_PKG"
ORA-06512: at "AVUSER.REFERENCE_RESOLUTION_PKG", line 1471
ORA-04061: existing state of package "AVUSER.COMMON_CONSTANTS_PKG" has been invalidated
ORA-04065: not executed, altered or dropped package "AVUSER.COMMON_CONSTANTS_PKG"
ORA-06508: PL/SQL: could not find program unit being called: "AVUSER.COMMON_CONSTANTS_PKG"
ORA-06512: at "AVUSER.REFERENCE_RESOLUTION_PKG", line 1379
ORA-06512: at "AVUSER.ADC_TABLES", line 137
ORA-06512: at "AVUSER.ADC_DATA_COLLECTOR", line 166
ORA-06512: at "AVUSER.ADC_DATA_COLLECTOR", line 450
ORA-06512: at line 1
at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1473)
at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1331)
at com.aveksa.server.db.PersistenceManager.runStoredProcedure(PersistenceManager.java:235)
at com.aveksa.server.xfw.DefaultAccountObjectDataFilter.loadData(DefaultAccountObjectDataFilter.java:104)
... 9 more
Caused by: java.sql.SQLException: ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package "AVUSER.COMMON_CONSTANTS_PKG" has been invalidated
ORA-04065: not executed, altered or dropped package "AVUSER.COMMON_CONSTANTS_PKG"
ORA-06508: PL/SQL: could not find program unit being called: "AVUSER.COMMON_CONSTANTS_PKG"
ORA-06512: at "AVUSER.REFERENCE_RESOLUTION_PKG", line 1471
ORA-04061: existing state of package "AVUSER.COMMON_CONSTANTS_PKG" has been invalidated
ORA-04065: not executed, altered or dropped package "AVUSER.COMMON_CONSTANTS_PKG"
ORA-06508: PL/SQL: could not find program unit being called: "AVUSER.COMMON_CONSTANTS_PKG"
ORA-06512: at "AVUSER.REFERENCE_RESOLUTION_PKG", line 1379
ORA-06512: at "AVUSER.ADC_TABLES", line 137
ORA-06512: at "AVUSER.ADC_DATA_COLLECTOR", line 166
ORA-06512: at "AVUSER.ADC_DATA_COLLECTOR", line 450
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:204)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1007)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4694)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1086)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404)
at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1436)
... 12 more
03/30/2016 08:25:49.534 INFO (Exec Task Consumer#0) [com.aveksa.server.xfw.TaskExecutor] UNSetting thread on 384095607 method=Execute
03/30/2016 08:25:49.550 INFO (Thread-439) [com.aveksa.server.core.DBEventUtilities] Published 0 DB events for run 22
03/30/2016 08:25:49.551 INFO (Thread-439) [com.aveksa.server.xfw.ExecutionContext] Successful method=Execute 22, AccountLoad
03/30/2016 08:25:49.593 INFO (Exec Task Consumer#0) [com.aveksa.server.xfw.TaskExecutor] Setting thread ThreadExec
Task Consumer#0,5,Execution Queue on 139209579 method=Execute
03/30/2016 08:25:49.607 ERROR (Exec Task Consumer#0) [com.aveksa.server.xfw.TaskExecutor] Failed method=Execute
ExecutionTask[TaskID=55 RunID=23 Source=1 Type=EntitlementExplosionPreProcessing Status=InProgress]
com.aveksa.server.xfw.ExecutionException: com.aveksa.server.db.PersistenceException: java.sql.SQLException:
ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package "AVUSER.COMMON_EXPLODER" has been invalidated
ORA-04065: not executed, altered or dropped package "AVUSER.COMMON_EXPLODER"
ORA-06508: PL/SQL: could not find program unit being called: "AVUSER.COMMON_EXPLODER"
ORA-06512: at line 1
at com.aveksa.server.xfw.EntitlementExplosionPreProcessingExecutor.executeTask(EntitlementExplosionPreProcessingExecutor.java:51)
at com.aveksa.server.xfw.TaskExecutor.execute(TaskExecutor.java:99)
at com.aveksa.server.xfw.ExecutionTaskQueue$Worker.run(ExecutionTaskQueue.java:116)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.aveksa.server.db.PersistenceException: java.sql.SQLException: ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package "AVUSER.COMMON_EXPLODER" has been invalidated
ORA-04065: not executed, altered or dropped package "AVUSER.COMMON_EXPLODER"
ORA-06508: PL/SQL: could not find program unit being called: "AVUSER.COMMON_EXPLODER"
ORA-06512: at line 1
at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1473)
at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1331)
at com.aveksa.server.db.PersistenceManager.runStoredProcedure(PersistenceManager.java:235)
at com.aveksa.server.xfw.EntitlementExplosionPreProcessingExecutor.executeTask(EntitlementExplosionPreProcessingExecutor.java:49)
... 3 more
Caused by: java.sql.SQLException: ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package "AVUSER.COMMON_EXPLODER" has been invalidated
ORA-04065: not executed, altered or dropped package "AVUSER.COMMON_EXPLODER"
ORA-06508: PL/SQL: could not find program unit being called: "AVUSER.COMMON_EXPLODER"
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:204)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1007)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4694)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1086)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404)
at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1436)
... 6 moreCause
Resolution
Workaround
Related Articles
Android and iOS Users Must Upgrade RSA SecurID Authenticate 2.x App the Latest Version by October 12 2020 Number of Views How can a Customer obtain the latest version of the AA Mobile SDK Number of Views SA: Q4 Apply Security Patch is unable to complete due to the latest gdb package incompatible with old gdb package Number of Views Unable to load form fields when using a form element of control type "Drop Down with Web Service" in RSA Identity Governan… Number of Views Exception on form validation: java.lang.illegalStateException: Already connected error in RSA Identity Governance & Lifecy… Number of Views
Trending Articles
How to generate a PASSCODE for manual entry on a Ericsson R380 WAP phone How to Understand the Difference Between RSA Authentication Manager Licenses and SecurID Token Assignments How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device RSA Authentication Manager 8.9 Release Notes (January 2026) IDR SSO - Step 3: Deploy the Identity Router
Don't see what you're looking for?
