Nolio RA Service is not starting after upgrade

Products

• CA Release Automation - Release Operations Center (Nolio)

Issue/Introduction

After upgrading the environment, the service is not starting and the log show the following error:

INFO  (com.nolio.platform.server.dataservices.services.upgrade.UpgradeServiceImpl:144) - Start UpgradeServiceImpl upgrade process
INFO  (com.nolio.platform.server.dataservices.services.upgrade.UpgradeServiceImpl:1236) - Retrieved current version from file [conf/version] : [6.7.0.81]
INFO  (com.nolio.platform.server.dataservices.services.upgrade.UpgradeServiceImpl:155) - Current version retrieved from DB (version_table): 6.7.0.81
INFO  (com.nolio.platform.server.dataservices.services.upgrade.UpgradeServiceImpl:406) - Checking whether hibernate.hbm2ddl.auto = update is enabled in wrapperContext.xml
INFO  (com.nolio.platform.server.dataservices.services.upgrade.UpgradeServiceImpl:412) - File path is /apps/nolio/mgt_server/webapps/datamanagement/WEB-INF/wrapperContext.xml
INFO  (com.nolio.platform.server.dataservices.services.upgrade.UpgradeServiceImpl:437) - Current value of hbm2dll.auto: 
INFO  (com.nolio.platform.server.dataservices.services.upgrade.UpgradeServiceImpl:243) - Calling Flyway Migrate...
ERROR (org.flywaydb.core.internal.command.DbMigrate:52) - Migration of schema [dbo] to version 6.7.0.0.201910101000000 - remove health tables - MSSQL failed! Changes successfully rolled back.
ERROR (com.nolio.platform.server.dataservices.services.upgrade.UpgradeServiceImpl:268) - Error calling Flyway Migrate
org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException: 
Migration V6.7.0.0.201910101000000__remove_health_tables_-_MSSQL.sql failed
---------------------------------------------------------------------------
SQL State  : S0005
Error Code : 229
Message    : The EXECUTE permission was denied on the object 'spRemoveTable', database 'XXX', schema 'dbo'.
Location   : /apps/nolio/mgt_server/webapps/datamanagement/resources/db/migration/mssql/V6.7.0.0.201910101000000__remove_health_tables_-_MSSQL.sql (/apps/nolio/mgt_server/webapps/datamanagement/resources/db/migration/mssql/V6.7.0.0.201910101000000__remove_health_tables_-_MSSQL.sql)

Environment

CA Release Automation 6.7 and 6.8

Resolution

The error means that there is/are some DB permission(s) not granted to so the upgrade procedure was unable to be fulfilled. Request the DBA to grant the appropriate permissions to the used User.