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 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.