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… 180Number of Views Collections are slow in Indirect Relationship Processing step in RSA Identity Governance & Lifecycle 149Number of Views Indirect Relationship Processing slower in Step 11/12 Calculate Role Metrics in RSA Governance & Lifecycle 197Number of Views RSA Identity Governance and Lifecycle Account Data Collector (ADC) and Entitlement Data Collectors (EDC) are slow in step … 304Number of Views
Trending Articles
RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide RSA MFA Agent for UNIX Platform Support Matrix Unable to login to RSA Authentication Manager Security Console as super admin Authentication Manager Security Console and Operations Console Inaccessible After Certificate Update Authentication Manager How to Retrieve the LDAPS Certificate and Configure an External Identity Source to Use LDAPS
Don't see what you're looking for?