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"

[#1]

Article Number

000033950

Applies To

RSA Product Set: RSA Identity Governance and Lifecycle (RSA G&L)
RSA Version/Condition: 7.0 P02 and P03

Issue

Following an install of 7.0.0 Patch 02 or 03 (P02 and P03), the following error is seen in the aveksaServer log:
 

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 more

Cause

During the installation of the patch the application server, Wildfly, is maintaining a number of database connections and attempts to reuse them leading to the error reported.

Resolution

This issue is being investigated by the Engineering team in order to provide a permanent resolution in a future release.

Workaround

After applying the patch restart the database and application server.