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:
[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
Release : 6.x
Component: Reporter Server + Oracle Database
Database issue: tablespace ran out of space so the autoextend could not be performed anymore.
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.
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.