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

Document ID : KB000005024
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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.