Issue:
The “ORA-01688 unable to extend table” error message was reported by different NexOSS applications.
Log Message:
2016-03-12 19:40:35|CDRRate |ERROR |SQLException: ORA-01688: unable to extend table ORACLE.RATEDCDR partition SYS_P2572 by 8192 in tablespace NEXOSS
2016-03-12 19:45:27|CDRAsm |ERROR |ORA-01688: unable to extend table ORACLE.REPORTABLECDR partition SYS_P2573 by 8192 in tablespace NEXOSS
2016-03-12 19:45:28|CDRAsm |ERROR |Exception:
java.sql.BatchUpdateException: ORA-01688: unable to extend table ORACLE.REPORTABLECDR partition SYS_P2573 by 8192 in tablespace NEXOSS
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10070)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:213)
at com.transnexus.Mediation.executeBatch(Mediation.java:459)
at com.transnexus.CDRAsm.assembleFile(CDRAsm.java:574)
at com.transnexus.CDRAsm.assembleFiles(CDRAsm.java:411)
at com.transnexus.CDRAsm.mediate(CDRAsm.java:358)
at com.transnexus.Mediation.goMediate(Mediation.java:344)
at com.transnexus.CDRAsmApplication.main(CDRAsmApplication.java:47)
2016-03-12 19:50:54|CDRRate |ERROR |SQLException: ORA-01688: unable to extend table ORACLE.RATEDCDR partition SYS_P2572 by 8192 in tablespace NEXOSS
Troubleshoot:
The error message identified that DB run out of tablespace.
Solution:
Extend Oracle DB tablespace. The instructions are in NexOSS Oracle Unable to Extend Table in Tablespace page.