Windows ActiveIQ UM upgrade to 9.7 fails because the jboss user does not have the correct permissions set

Last updated
Save as PDF
Share
1. Share
2. Tweet

Views:: 2

Visibility:: Public

Votes:: 0

Category:: active-iq-unified-manager

Specialty:: OM

Last Updated:

Applies to

Upgrade to ActiveIQ Unified Manager 9.7 (UM)
Windows based installation

Issue

The OCIE service fails to start after an upgrade to UM 9.7

In the deployment file <installation path>\essentials\jboss\standalone\deploymentsdfm-app.war.failed we see:

"{\"WFLYCTL0080: Failed services\" => {\"jboss.deployment.unit.\\\"dfm-app.war\\\".undertow-deployment\" => \"java.lang.RuntimeException: org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
    Caused by: java.lang.RuntimeException: org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
    Caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
    Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
    Caused by: java.sql.SQLSyntaxErrorException: (conn=42) Table 'netapp_model_view.cluster' doesn't exist
    Caused by: java.sql.SQLException: Table 'netapp_model_view.cluster' doesn't exist\"}}"