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

Views:: 442

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\"}}"