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 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 issue on Oracle side. It seems like some type of limitation on Oracle side which is causing this issue. Please share these error with Oracle admin, and ask them to address the table space issue. Once table space issue is resolved on Oracle side, APM should not encounter these errors.