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

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

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

Environment:
RA 6.2 being upgraded to build 3057
Cause:

log contains following error:

2016-12-02 13:31:05,082 [localhost-startStop-1] ERROR (com.nolio.platform.server.dataservices.services.upgrade.UpgradeServiceImpl:267) - Error calling Flyway Migrate 

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

 

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

Resolution:

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 = '6.3.0.0.201609071055001'; 

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

5. Copy the script "V6.3.0.0.201609071055001__create_nac_broker_id_column_in_exec_servers_idempotent_-_MYSQL.sql” 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.