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.


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.