Error 404 shown in Nolio UI after upgrade
search cancel

Error 404 shown in Nolio UI after upgrade

book

Article ID: 444916

calendar_today

Updated On:

Products

CA Release Automation - Release Operations Center (Nolio) CA Release Automation - DataManagement Server (Nolio)

Issue/Introduction

After an upgrade was performed in NAC, the UI loads but it shows a 404 error:

Environment

Release Automation 6.8 and 6.9

Cause

Checking “nolio_dm_all” log, the following database connection error appears:

INFO  (com.nolio.platform.server.dataservices.services.upgrade.UpgradeServiceImpl:83) - Start UpgradeServiceImpl upgrade process

INFO  (com.nolio.platform.server.dataservices.services.upgrade.UpgradeServiceImpl:373) - Retrieved current version from file [conf/version] : [6.9.4.2211]

WARN  (com.nolio.platform.server.dataservices.services.upgrade.UpgradeServiceImpl:402) - Could not retrieve version info from DB. org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (Cannot open database “DB_HOST]” requested by the login. The login failed. ClientConnectionId:00000-000-000-000-00000)

INFO  (com.nolio.platform.server.dataservices.services.upgrade.UpgradeServiceImpl:87) - Current version retrieved from DB (version_table): null

INFO  (com.nolio.platform.server.dataservices.services.upgrade.UpgradeServiceImpl:158) - Calling Flyway Migrate...

ERROR (com.nolio.platform.server.dataservices.services.upgrade.UpgradeServiceImpl:184) - Error calling Flyway Migrate 

org.flywaydb.core.api.FlywayException: Unable to obtain Jdbc connection from DataSource

Resolution

In latest versions, specifically after 6.9.3 release, there is a change in the JDBC Driver used, so it’s possible that the connection string is also overwritten by the upgrade process.

The file that holds the database connection string is “database.properties” and it’s located under ../webapps/datamanagement/WEB-INF/, it’s recommended to verify that the database information is correct (if there is a backup of the server, it can be compared to the value it had before the upgrade).

Powered by Wolken Software