search cancel

ORA-01653: unable to extend table IAMOBJECT_P_2.TASKSESSION12_5 by 32 in tablespace IAMOBJECT_P_2_DATA

book

Article ID: 201564

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Governance CA Identity Portal CA Identity Suite

Issue/Introduction

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:]

Cause

This is due to tablespace run out of space

Environment

Release : 14.3

Component : IdentityMinder(Identity Manager)

Resolution

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';