Indirect Relationship processing slow or fail with ORA-01652 on TEMP table space using Identity Governance and Lifecycle
2 years ago
Originally Published: 2018-10-09
Article Number
000041670
Applies To
RSA Product Set: Identity Governance and Lifecycle
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
Indirect Relationship Processing takes a long time to run and or fails with ORA-01652 on TEMP table space.

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