IDM server, receiving the following SQL error messages whenever we click on a task in the user console.
ERROR [ims.ui] (default task-2) ORA-01653: unable to extend table IAMOBJECT_P_2.TASKSESSION12_5 by 32 in tablespace IAMOBJECT_P_2_DATA
: java.sql.SQLException: ORA-01653: unable to extend table IAMOBJECT_P_2.TASKSESSION12_5 by 32 in tablespace IAMOBJECT_P_2_DATA
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) [ojdbc8.jar:]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) [ojdbc8.jar:]
Release : 14.3
Component : IdentityMinder(Identity Manager)
This is due to tablespace run out of space
Add a new datafile on the existing tablespace or resize an existing datafile. You can find out the existing datafile location and size by run the following query
SELECT FILE_NAME, BYTES FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'IAMOBJECT_P_2_DATA';