search cancel

Database errors post Upgrade from to


Article ID: 108028


Updated On:


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


After restoring and upgrading the cemdb to, I upgraded the EM to the same version and started it. However, the EM failed to start with the following error:

[ERROR] [main] [Apm.Data.Model] APM Database is not reachable. Please check the connectivity...
org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select as id5_0_, as name5_0_, this_.creation_date as creation3_5_0_, this_.update_date as update4_5_0_, this_.user_name as user5_5_0_ from apm_vertex_type this_ where]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

    at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(
    at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
    at org.hibernate.exception.SQLStateConverter.convert(
    ... 73 more
Caused by: org.postgresql.util.PSQLException: ERROR: relation "apm_vertex_type" does not exist
  Position: 161
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(
    ... 81 more



CA Application Performance Management


Upon further troubleshooting, we found out that the cemdb was actually empty. The restore process did not complete properly.


Re-run the restore process with the 10.7 script, which restores and upgrade the schemas to 10.7 successfully.


Additional Information

Restore the APM Database