search cancel

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


Article ID: 5024


Updated On:


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


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 - 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 ( - Error calling Flyway Migrate

org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:Migration V6. 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. (/opt/ReleaseAutomationServer/webapps/datamanagement/resources/db/migration/mysql/V6.

Line       : 2

Statement  : CALL fixContainerId()


Release Automation 6.3 upgrade on Linux with Mysql database.


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

Follow these steps:


  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. Replace the file with the one from the following attachment, 


On the Database server,

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

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

On the NAC,

  1. restart the NAC service


Verify if the RA landing page opens without errors.