Indirect Relationship processing slow or fail with ORA-01652 on TEMP table space using Identity Governance and Lifecycle
Originally Published: 2018-10-09
Article Number
Applies To
RSA Product/Service Type: Appliance
RSA Version/Condition: 7.0.2
Platform: null
Platform (Other): 7.0.2P07+
O/S Version: null
Product Name: null
Product Description: null
Issue
The following is the stack that can be found in the aveksaServer.log:
ERROR (Exec Task Consumer#0) [TaskExecutor] - Failed method=Execute ExecutionTask[TaskID=440813 RunID=880030 Source=2161 Type=EntitlementExplosionProcessing Status=InProgress] com.aveksa.server.xfw.ExecutionException: com.aveksa.server.db.PersistenceException: java.sql.SQLException: ORA-01652: unable to extend temp segment by 256 in tablespace TEMP ORA-06512: at "AVUSER.CE_ACCOUNTS", line 665 ORA-06512: at "AVUSER.CE_ACCOUNTS", line 975 ORA-06512: at "AVUSER.COMMON_EXPLODER", line 298 ORA-06512: at "AVUSER.COMMON_EXPLODER", line 117 ORA-06512: at line 1 at com.aveksa.server.xfw.EntitlementExplosionProcessingExecutor.executeTask(EntitlementExplosionProcessingExecutor.java:54) 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-01652: unable to extend temp segment by 256 in tablespace TEMP ORA-06512: at "AVUSER.CE_ACCOUNTS", line 665 ORA-06512: at "AVUSER.CE_ACCOUNTS", line 975 ORA-06512: at "AVUSER.COMMON_EXPLODER", line 298 ORA-06512: at "AVUSER.COMMON_EXPLODER", line 117 ORA-06512: at line 1 at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1601) at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1459) at com.aveksa.server.db.PersistenceManager.runStoredProcedure(PersistenceManager.java:267) at com.aveksa.server.xfw.EntitlementExplosionProcessingExecutor.executeTask(EntitlementExplosionProcessingExecutor.java:52) ... 3 more Caused by: java.sql.SQLException: ORA-01652: unable to extend temp segment by 256 in tablespace TEMP ORA-06512: at "AVUSER.CE_ACCOUNTS", line 665 ORA-06512: at "AVUSER.CE_ACCOUNTS", line 975 ORA-06512: at "AVUSER.COMMON_EXPLODER", line 298 ORA-06512: at "AVUSER.COMMON_EXPLODER", line 117 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:220) at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:48) at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:938) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4901) at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:5631) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385) at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:105) at com.aveksa.server.db.persistence.PersistenceServiceProvider.executeCallableStatement(PersistenceServiceProvider.java:1636) at com.aveksa.server.db.persistence.PersistenceServiceProvider.runStoredProcedure(PersistenceServiceProvider.java:1564) ... 6 more
Related Articles
Indirect Relationship Processing slower in Step 11/12 in RSA Governance & Lifecycle 69Number of Views Indirect Relationship Processing fails with 'ORA-12899 value too large for column' error in RSA Identity Governance & Life… 179Number of Views Collections are slow in Indirect Relationship Processing step in RSA Identity Governance & Lifecycle 146Number of Views Indirect Relationship Processing slower in Step 11/12 Calculate Role Metrics in RSA Governance & Lifecycle 197Number of Views Indirect relationship processing is failing at step 11 on "AVUSER.ROLE_MANAGEMENT_PKG", line 3376 in RSA Governance & Life… 249Number of Views
Trending Articles
RSA Authentication Manager 8.9 Setup and Configuration Guide How to 'Trust' the RSA Authentication Manager Security Console Self-Signed Root CA certificate and prevent Cert warnings. RSA Authentication Manager 8.9 Release Notes (January 2026) Configure RSA Authentication Manager as a Secure Proxy Server for Cloud Access Service RSA Authentication Manager Upgrade Process
Don't see what you're looking for?