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 66Number of Views Indirect Relationship Processing fails with 'ORA-12899 value too large for column' error in RSA Identity Governance & Life… 169Number of Views RSA Governance and Lifecycle 8.0 Oracle Database Collector Datasheet Guide 60Number of Views How to tell if the Oracle database on an appliance is Local or Remote in RSA Identity Governance & Lifecycle 60Number of Views Data purging fails with ORA-02292: integrity constraint (AVUSER.FK_xxxxxx violated - child record found) in RSA Identity G… 180Number of Views
Trending Articles
Passwordless Authentication in Windows MFA Agent for Active Directory – Quick Setup Guide RSA Authentication Manager Upgrade Process RSA Authentication Manager 8.9 Release Notes (January 2026) An example of SSO using SAML and ADFS with RSA Identity Management and Governance 6.9.x RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?