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 fails with 'ORA-12899 value too large for column' error in RSA Identity Governance & Life… 180Number of Views Indirect Relationship Processing slower in Step 11/12 Calculate Role Metrics in RSA Governance & Lifecycle 197Number of Views Collections are slow in Indirect Relationship Processing step in RSA Identity Governance & Lifecycle 149Number of Views E-mail Template Example for the Self-Service Console 83Number of Views Canceled Change Requests show as Canceled by System instead of the User who Canceled the Request in RSA Identity Governanc… 60Number of Views
Trending Articles
Using Vault instead of cleartext password in WildFly configuration file in RSA Identity Governance & Lifecycle Authentication Manager Security Console and Operations Console Inaccessible After Certificate Update How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Assigned token list shows tokens assigned to <UNKNOWN> for RSA Authentication Manager Unable to login to RSA Authentication Manager Security Console as super admin
Don't see what you're looking for?