Continuously getting errors related to SQL and model synchronization
search cancel

Continuously getting errors related to SQL and model synchronization

book

Article ID: 129951

calendar_today

Updated On:

Products

CA Application Performance Management Agent (APM / Wily / Introscope) INTROSCOPE

Issue/Introduction

We are continuously getting the following errors in APM logs:

[ERROR] [Thread-ModelSynchronization] [Manager.AppMap] Unable to complete model synchronization with storage! org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO appmap_attribs (vertex_id, start_time, end_time, fork, attrib_name, value) VALUES (?, ?, ?, ?, ?, ?)]; SQL state [72000]; error code [1653]; ORA-01653: unable to extend table APMADMIN.APPMAP_ATTRIBS by 128 in tablespace APMDATA ; nested exception is java.sql.SQLException: ORA-01653: unable to extend table APMADMIN.APPMAP_ATTRIBS by 128 in tablespace APMDATA Caused by: java.sql.SQLException: ORA-01653: unable to extend table APMADMIN.APPMAP_ATTRIBS by 128 in tablespace APMDATA at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1046) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3694) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1354) at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:916) at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:909) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644) ... 58 more 

Environment

Release:
Component: APMISP

Resolution

  • These errors are occurring due to table space issues on the Oracle side.
  • It seems like some type of limitation on the Oracle side which is causing this issue.
  • Please share these errors with Oracle DB admin, and ask them to address the table space issue.
  • Once the table space issue is resolved on the Oracle side, APM should not encounter these errors.