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
How to update a Windows Web Express 1.2.1 to the latest patches 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 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 Access Fulfillment Express (AFX) for RSA Identity Governance and Lifecycle 6.9.1 P15 and above resends auto-fulfillment re… Number of Views
Trending Articles
RSA SecurID software token .sdtid file fails to import into RSA SecurID Software Token 5.0 for Windows RSA Authentication Manager Patch Updates Unable to login to RSA Authentication Manager Security Console as super admin RSA Authentication Manager Upgrade Process How to Download OTP Token Seed Files from myRSA
Don't see what you're looking for?
