search cancel

HTTP 404 - /datamanagement/index.jsp error after upgrade to latest build


Article ID: 4800


Updated On:


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


RA is no longer accessible after upgrade to latest build. It results in error:

HTTP 404 - /datamanagement/index.jsp error after upgrade to latest build


RA 6.2 being upgraded to build 3057


log contains following error:

2016-12-02 13:31:05,082 [localhost-startStop-1] ERROR ( - Error calling Flyway Migrate 

org.flywaydb.core.api.FlywayException: Schema olio_ctd` contains a failed migration to version ! 


Problem most likely due to corrupt or not present file "V6.” within <RA_HOME>/webapps/datamanagement/resources/db/migration/mysql 


1. Take a snapshot of the current situation (just as a precaution)

2. Stop the NAC 

3. Connect to the MySQL RA database schema and execute the following two SQL commands: 

- drop table upgrade_mal_art_sc; 

- delete from schema_version where version = ''; 

4. On the NAC, locate the following directory: <RA_HOME>/webapps/datamanagement/resources/db/migration/mysql 

5. Copy the script "V6.” from the patch's Fix_Maintenance\RA620cumulativeb3057_40221299429688309\RA_620_Cumulative_b3057\webapps\datamanagement\resources\db\migration\mysql to the above directory, replacing the existing file of the same name in this location. 

6. Start the NAC

Additional Information

the techdoc is written for mysql but similar errors may appear for mssql or oracle. In that case adjust the script name to the one reported in the logs and copy it from the proper <RA_HOME>/webapps/datamanagement/resources/db/migration/ path: mssql or oracle.