I took VM snapshot, stopped all services and upgraded CA RA from v5 to 6.1 and from 6.1 to 6.2 version.After successful upgrade activities, I am not able to launch the dashboard/console. (Meanwhile, I am using mysql database for CA RA env!) Below error is been noticed:- HTTP Status 404 - /datamanagement/index.jsp Can you please help me on the same?Errors noticed in logs:Caused by: java.lang.RuntimeException: Update of database schema version 220.127.116.11 for application version 18.104.22.16817 needs to be carried out by upgrading first to 6.1.0 GA. at com.nolio.platform.server.dataservices.services.upgrade.UpgradeServiceImpl.checkHibernateAutoUpdateSettings(UpgradeServiceImpl.java:396) at com.nolio.platform.server.dataservices.services.upgrade.UpgradeServiceImpl.init(UpgradeServiceImpl.java:157) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:349) at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:300) at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:133)
2016-09-27 05:00:23,574 [localhost-startStop-1] ERROR (com.nolio.platform.server.dataservices.services.upgrade.UpgradeServiceImpl:391) - Update of database schema version 22.214.171.124 for application version 126.96.36.19917 needs to be carried out by upgrading first to 6.1.0 GA.
From the logs snippet shared I want to ask when you upgrade to 6.1 did you started RA service and login to RA.
After the 6.1 upgrade did you start NAC and confirm that you were able to login? the database upgrade takes place the first time you start the NAC after an upgrade.
Thanks for your response.
No, I didn't logged into console. Just saw that Nolio services were started automatically after 6.1 upgrade steps and performed 6.2 upgrade.
It looks like you haven't given the enough time to RA service post upgrade to 6.1 to update the schema and ran with 6.2 upgrade which is resulting in the error seen above which tells that schema of DB is still of 5.5.2 which need to be of 6.1
I will request you to re-ran the upgrade to 6.1 and browse and post successful browse upgrade to 6.2.
Thanks! Will be performing above steps right away.
You guys were highly helpful. More updates to come!
Yes, upgrading to 6.1 and validating DB schema before 6.2 upgrade resolved the issue!
Logs are upgrading to 6.1 and 6.2 version!
2016-09-28 00:50:24,719 [localhost-startStop-1] INFO (com.nolio.platform.server.dataservices.services.upgrade.service.utility.VendorManipulations:30) - Successfully removed old_origin_id column from executable_aud table.2016-09-28 00:50:24,719 [localhost-startStop-1] DEBUG (com.nolio.platform.server.dataservices.services.upgrade.service.utility.SharedComponentsUpgrader:95) - Finished Upgrade origin Id in audit table2016-09-28 00:51:03,751 [localhost-startStop-1] DEBUG (com.nolio.platform.server.dataservices.services.upgrade.UpgradeServiceImpl:1014) - Running sql script: scripts\indexes\6_1_0_1\mysql_update.sql2016-09-28 00:51:03,767 [localhost-startStop-1] INFO (com.nolio.platform.server.dataservices.services.upgrade.UpgradeServiceImpl:1266) - Insert foreign key indexes2016-09-28 00:51:04,048 [localhost-startStop-1] INFO (com.nolio.platform.server.dataservices.services.upgrade.UpgradeDBServiceImpl:508) - Previous is [188.8.131.52], current version is [184.108.40.2062] - starting upgrade...