000033950 - 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"

Document created by RSA Customer Support Employee on Sep 20, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000033950
Applies ToRSA Product Set: RSA Identity Governance and Lifecycle (RSA G&L)
RSA Version/Condition: 7.0 P02 and P03
IssueFollowing 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
CauseDuring 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.
ResolutionThis issue is being investigated by the Engineering team in order to provide a permanent resolution in a future release.
WorkaroundAfter applying the patch restart the database and application server.

Attachments

    Outcomes