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 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 BASE libraries can't be used on platforms that haven?t been upgraded with the latest MSVCRT libraries. Number of Views Unification and collectors get stuck at calculating role metrics after applying P01 to Via L&G v7.0.0 Number of Views
Trending Articles
RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide User Event Monitor Messages for Cloud Access Service (1501 - 20406) How to test RSA Identity Router (IDR) Secure Connector connectivity to the RSA ID Plus Cloud Access Service RSA Release Notes for RSA Authentication Manager 8.8 Troubleshooting RSA MFA Agent for Microsoft Windows
Don't see what you're looking for?
