ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Upgrade systems based on MySQL running on LNX will fail to run flyway script,the RA UI will open with errors after the upgrade.

book

Article ID: 5024

calendar_today

Updated On:

Products

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

Issue/Introduction

Linux users running MySQL encounter a landing page error message when upgrading to CA Release Automation 6.3.0.

The following error appears in the nolio_dm_all.log file:

2016-12-17 06:43:26,511 [localhost-startStop-1] ERROR (org.flywaydb.core.internal.command.DbMigrate:52) - Migration of schema olio_db` to version 6.3.0.0.201609281230001 - execute fix container id in executable - MYSQL failed! Please restore backups and roll back database and code!

2016-12-17 06:43:26,517 [localhost-startStop-1] ERROR (com.nolio.platform.server.dataservices.services.upgrade.UpgradeServiceImpl:267) - Error calling Flyway Migrate

org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:Migration V6.3.0.0.201609281230001__execute_fix_container_id_in_executable_-_MYSQL.sql failed

---------------------------------------------------------------------------------------------

SQL State  : 42S02

Error Code : 1146

Message    : Table 'nolio_db.EXECUTABLE' doesn't exist

Location   : /opt/ReleaseAutomationServer/webapps/datamanagement/resources/db/migration/mysql/V6.3.0.0.201609281230001__execute_fix_container_id_in_executable_-_MYSQL.sql (/opt/ReleaseAutomationServer/webapps/datamanagement/resources/db/migration/mysql/V6.3.0.0.201609281230001__execute_fix_container_id_in_executable_-_MYSQL.sql)

Line       : 2

Statement  : CALL fixContainerId()

Environment

Release Automation 6.3 upgrade on Linux with Mysql database.

Resolution

To resolve the landing page error that occurs after upgrading to CA Release Automation 6.3 .

Follow these steps:

ON THE NAC’s MACHINE,

  1. On the NAC  server, stop the NAC service, and backup the following file to a location outside the NAC root directory.
  2. <NAC ROOT>/webapps/datamanagement/resources/db/migration/mysql/V6.3.0.0.201609281209001__declare_fix_container_id_in_executable_-_MYSQL.sql
  3. Replace the file with the one from the following attachment, 

V6.3.0.0.201609281209001__declare_fix_container_id_in_executable_-_MYSQL....sql

On the Database server,

  1. select the RA database, and run the following SQL script,

DELETE FROM schema_version WHERE version IN ('6.3.0.0.201609281209001', '6.3.0.0.201609281230001');


On the NAC,

  1. restart the NAC service

 

Verify if the RA landing page opens without errors.