Reporter extraction or purge Aborts with ORA-01653: unable to extend table

Products

• CA Automic Dollar Universe

Issue/Introduction

Reporter Server with Oracle Database fails to perform extractions or purges.

The error that appears in the server.log states a problem with the tablespace being full:

ORA-01653: unable to extend table REPORTER_DB_USER.UNI_EVT_JOBLOGS by 128 in tablespace TABLESPACE_NAME.

If we launch a Reporter purge, it also fails with this kind of error:

(server.log)

[ERROR] 03 Jan 2023 12:03:20 [pool-1-thread-109] com.orsyp.reppub.server.process.ReporterPurgeExtractionSource - SQLException thrown by the purge operation for the [PurgeCriterionDuas - company = * uvmsName = * node = * areaCode = * mu = * session = * uproc = * limit = 90]; operation will be rollbacked
java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP_01

 

Environment

Release : 6.x

Component: Reporter Server + Oracle Database

Cause

Database issue: tablespace ran out of space so the autoextend could not be performed anymore.

Resolution

As per the errors:

ORA-01653: unable to extend table REPORTER_DB_USER.UNI_EVT_JOBLOGS by 128 in tablespace TABLESPACE_NAME

ORA-01652: unable to extend temp segment by 128 in tablespace TEMP_01

Either the tablespaces were not in autoextend or the maximum size for those tablespaces was reached.

To fix it, please ask your Database Administrator (DBA) to either increase the tablespace size adding one or several additional data files with several GBs and then perform a purge of Reporter to avoid this from occurring again and ask the DBA to reorg and rebuild the tables indexes to gain some place.

Additional Information

To avoid this from ocurring again, it is advised that a Scheduled Purge is set on Reporter with the desired amount of days to keep in the database, as else it will grow undefinitely.

Else, the DBAs should regularly check that there is enough space in the associated Tablespaces and add space when necessary.