UIM Upgrade from 8.5.1 to 9.0.2

[ca support]

Hi All,

In our environment, we are trying to upgrade UIM  8.5.1 to 9.02.The problem here the server version 2008 which is not compatible with 9.0.2.

So first we planned to upgrade the OS version from 2008 to 2012 and start the upgrade.To try the os in place upgrade we have taken the clone of the current production setup and assigned the different IP and hostname to the cloned machines , post the application was up and running on the cloned machines.

We have upgrade the OS from 2008 to 2012(inplace upgrade) and verified the application status.Everything was fine.Now when I try to run the installer for 9.0.2 upgrade I am getting the below error.

sharing the installation logs as well.Could someone help me with to find out the issue.

2020-09-09 09:51:20,636 DEBUG impl.UIMServerUpgradePreparationController:retrieveConfigurationInfo:144 [SwingWorker-pool-1-thread-2] - strNMSRootDir: D:\Program Files (x86)\Nimsoft
2020-09-09 09:51:20,637 DEBUG impl.UIMServerUpgradePreparationController:retrieveConfigurationInfo:149 [SwingWorker-pool-1-thread-2] - robotCfg: D:\Program Files (x86)\Nimsoft\.\robot\robot.cfg
2020-09-09 09:51:20,638 DEBUG impl.UIMServerUpgradePreparationController:retrieveConfigurationInfo:154 [SwingWorker-pool-1-thread-2] - controller/robotip: 172.17.110.81
2020-09-09 09:51:20,639 INFO impl.UIMServerUpgradePreparationController:retrieveConfigurationInfo:156 [SwingWorker-pool-1-thread-2] - nms_primary_robot_ip: 172.17.110.81
2020-09-09 09:51:20,639 INFO impl.UIMServerUpgradePreparationController:retrieveConfigurationInfo:162 [SwingWorker-pool-1-thread-2] - controller/hubip: 172.17.110.81
2020-09-09 09:51:20,639 INFO impl.UIMServerUpgradePreparationController:retrieveConfigurationInfo:173 [SwingWorker-pool-1-thread-2] - nms_primary_hub_ip: 172.17.110.81
2020-09-09 09:51:20,639 DEBUG impl.UIMServerUpgradePreparationController:retrieveConfigurationInfo:178 [SwingWorker-pool-1-thread-2] - controller/domain: SMR-UIMP1dom-test
2020-09-09 09:51:20,639 INFO impl.UIMServerUpgradePreparationController:retrieveConfigurationInfo:179 [SwingWorker-pool-1-thread-2] - nms_domain_name: SMR-UIMP1dom-test
2020-09-09 09:51:20,639 DEBUG impl.UIMServerUpgradePreparationController:retrieveConfigurationInfo:184 [SwingWorker-pool-1-thread-2] - controller/hub: SMR-UIMP1-Test1
2020-09-09 09:51:20,639 INFO impl.UIMServerUpgradePreparationController:retrieveConfigurationInfo:185 [SwingWorker-pool-1-thread-2] - nms_primary_hub_name: SMR-UIMP1-Test1
2020-09-09 09:51:20,640 INFO impl.UIMServerUpgradePreparationController:retrieveConfigurationInfo:190 [SwingWorker-pool-1-thread-2] - controller/robotname: SMR-UIMP1-Test1
2020-09-09 09:51:20,640 INFO impl.UIMServerUpgradePreparationController:retrieveConfigurationInfo:198 [SwingWorker-pool-1-thread-2] - nms_primary_robot_name: SMR-UIMP1-Test1
2020-09-09 09:51:20,640 DEBUG impl.UIMServerUpgradePreparationController:retrieveConfigurationInfo:205 [SwingWorker-pool-1-thread-2] - strHubRobotName: SMR-UIMP1-Test1
2020-09-09 09:51:20,640 INFO impl.UIMServerUpgradePreparationController:retrieveConfigurationInfo:219 [SwingWorker-pool-1-thread-2] - controller/first_probe_port: 48000
2020-09-09 09:51:20,640 INFO impl.UIMServerUpgradePreparationController:retrieveConfigurationInfo:228 [SwingWorker-pool-1-thread-2] - nms_first_probe_port: 48000
2020-09-09 09:51:20,640 INFO impl.UIMServerUpgradePreparationController:retrieveConfigurationInfo:233 [SwingWorker-pool-1-thread-2] - controller/strict_ip_binding: 48000
2020-09-09 09:51:20,640 INFO impl.UIMServerUpgradePreparationController:retrieveConfigurationInfo:245 [SwingWorker-pool-1-thread-2] - Successfully retrieved information from robot.cfg.
2020-09-09 09:51:20,640 DEBUG impl.UIMServerUpgradePreparationController:retrieveConfigurationInfo:253 [SwingWorker-pool-1-thread-2] - dataEngineCfgFile: D:\Program Files (x86)\Nimsoft\.\probes\slm\data_engine\data_engine.cfg
2020-09-09 09:51:20,642 DEBUG provider.DataEngineDBProviderInfo:getNormalizedProviderName:149 [SwingWorker-pool-1-thread-2] - de_provider_name_lc: microsoft
2020-09-09 09:51:20,642 DEBUG provider.DataEngineDBProviderInfo:getNormalizedProviderName:176 [SwingWorker-pool-1-thread-2] - normalized_provider_name: sqlserver
2020-09-09 09:51:20,643 DEBUG impl.UIMServerUpgradePreparationController:retrieveConfigurationInfo:274 [SwingWorker-pool-1-thread-2] - strNormalizedProviderName: sqlserver
2020-09-09 09:51:20,643 DEBUG impl.UIMServerUpgradePreparationController:retrieveConfigurationInfo:280 [SwingWorker-pool-1-thread-2] - 1-strDBPort: 1433
2020-09-09 09:51:20,643 DEBUG impl.UIMServerUpgradePreparationController:parseDBServer:397 [SwingWorker-pool-1-thread-2] - sbDBServerOut: 172.17.110.80
2020-09-09 09:51:20,643 DEBUG impl.UIMServerUpgradePreparationController:parseDBServer:398 [SwingWorker-pool-1-thread-2] - sbDBPortOut: 1433
2020-09-09 09:51:20,647 DEBUG impl.UIMServerUpgradePreparationController:retrieveConfigurationInfo:290 [SwingWorker-pool-1-thread-2] - 2-strDBPort: 1433
2020-09-09 09:51:20,647 DEBUG impl.UIMServerUpgradePreparationController:retrieveConfigurationInfo:293 [SwingWorker-pool-1-thread-2] - sbDBServer: 172.17.110.80
2020-09-09 09:51:20,647 DEBUG impl.UIMServerUpgradePreparationController:retrieveConfigurationInfo:306 [SwingWorker-pool-1-thread-2] - strDBName: CA_UIM
2020-09-09 09:51:20,647 DEBUG impl.UIMServerUpgradePreparationController:retrieveConfigurationInfo:311 [SwingWorker-pool-1-thread-2] - strUsername: camadmin
2020-09-09 09:51:20,647 DEBUG impl.UIMServerUpgradePreparationController:retrieveConfigurationInfo:316 [SwingWorker-pool-1-thread-2] - data_engine strParams: Network Library=dbmssocn;Language=us_english
2020-09-09 09:51:20,650 DEBUG provider.DataEngineDBProviderInfo:getCryptKey:266 [SwingWorker-pool-1-thread-2] - No crypt key
2020-09-09 09:51:20,651 ERROR impl.UIMServerUpgradePreparationController:retrieveConfigurationInfo:368 [SwingWorker-pool-1-thread-2] - Exception caught.
(110) Security error, Illegal base64 char found '@'
at com.nimsoft.nimbus.NimBase64.get(NimBase64.java:151)
at com.nimsoft.nimbus.NimBase64.decode(NimBase64.java:111)
at com.nimsoft.nimbus.NimSecurity.decrypt(NimSecurity.java:249)
at com.nimsoft.nimbus.NimSecurity.decryptISO(NimSecurity.java:192)
at com.nimsoft.nimdbprovider.de.provider.DataEngineDBProviderInfo.decryptContents(DataEngineDBProviderInfo.java:94)
at com.nimsoft.install.uimserver.action.impl.UIMServerUpgradePreparationController.retrieveConfigurationInfo(UIMServerUpgradePreparationController.java:333)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.nimsoft.install.nimcommon.method.NimMethodCallback.invokeMethod(NimMethodCallback.java:532)
at com.nimsoft.install.nimcommon.method.NimMethodCallback.invokeMethod(NimMethodCallback.java:516)
at com.nimsoft.install.uimserver.action.impl.UIMServerUpgradePreparationController.doConfigure(UIMServerUpgradePreparationController.java:124)
at com.nimsoft.install.uimserver.panel.impl.UIMServerUpgradePreparationPanel$UpgradePreparationSwingWorkerThread.doInBackground(UIMServerUpgradePreparationPanel.java:268)
at com.nimsoft.install.uimserver.panel.impl.UIMServerUpgradePreparationPanel$UpgradePreparationSwingWorkerThread.doInBackground(UIMServerUpgradePreparationPanel.java:245)
at javax.swing.SwingWorker$1.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at javax.swing.SwingWorker.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2020-09-09 09:51:20,651 INFO impl.UIMServerUpgradePreparationPanel:notifyStepComplete:151 [SwingWorker-pool-1-thread-2] - step complete: counter: 1
2020-09-09 09:51:23,178 ERROR impl.UIMServerUpgradePreparationPanel$UpgradePreparationSwingWorkerThread:doInBackground:278 [SwingWorker-pool-1-thread-2] - Exception caught during validation checks.
(90) Configuration error, Failed to retrieve necessary information from configuration files for upgrade.
An uninstall and re-install of the product is required.: Illegal base64 char found '@'
at com.nimsoft.install.uimserver.action.impl.UIMServerUpgradePreparationController.retrieveConfigurationInfo(UIMServerUpgradePreparationController.java:373)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.nimsoft.install.nimcommon.method.NimMethodCallback.invokeMethod(NimMethodCallback.java:532)
at com.nimsoft.install.nimcommon.method.NimMethodCallback.invokeMethod(NimMethodCallback.java:516)
at com.nimsoft.install.uimserver.action.impl.UIMServerUpgradePreparationController.doConfigure(UIMServerUpgradePreparationController.java:124)
at com.nimsoft.install.uimserver.panel.impl.UIMServerUpgradePreparationPanel$UpgradePreparationSwingWorkerThread.doInBackground(UIMServerUpgradePreparationPanel.java:268)
at com.nimsoft.install.uimserver.panel.impl.UIMServerUpgradePreparationPanel$UpgradePreparationSwingWorkerThread.doInBackground(UIMServerUpgradePreparationPanel.java:245)
at javax.swing.SwingWorker$1.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at javax.swing.SwingWorker.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: (110) Security error, Illegal base64 char found '@'
at com.nimsoft.nimbus.NimBase64.get(NimBase64.java:151)
at com.nimsoft.nimbus.NimBase64.decode(NimBase64.java:111)
at com.nimsoft.nimbus.NimSecurity.decrypt(NimSecurity.java:249)
at com.nimsoft.nimbus.NimSecurity.decryptISO(NimSecurity.java:192)
at com.nimsoft.nimdbprovider.de.provider.DataEngineDBProviderInfo.decryptContents(DataEngineDBProviderInfo.java:94)
at com.nimsoft.install.uimserver.action.impl.UIMServerUpgradePreparationController.retrieveConfigurationInfo(UIMServerUpgradePreparationController.java:333)
... 15 more

Regards,
Usha

[Luc Christiaens]

I think that the installer verification found an illegal '@'​ sign.
Is there perhaps a @ in the administrators password?​

[ca support]

Hi Christiaens,

Yes, @ is available in the password.

Regards,
Usha​

[Luc Christiaens]

Try with another password and see if this goes better.

[ca support]

Hi ,

I have tried, but still getting the same error.

Regards,
Usha

[Luc Christiaens]

Did you see the same error ((110) Security error, Illegal base64 char found '@') in the log file?
If yes, is there something else with a "@"? A directory or a file?

[ca support]

Yes , I do get the same error in the logs.

Regards,
Usha

[Luc Christiaens]

Do you have a "@" in the password (or user) to connect to the CA_UIM database?

[Garin Walsh]

And I have to ask but you have made sure that the IP address information in all of the UIM configuration on the cloned machines was changed to reflect the new IP? 

Did you change the domain name of the cloned system?

Is there any network connectivity between this cloned central hub and the existing production one? 

The error message seems to be referring to DataEngineDBProviderInfo with respect to the error. And a failure to decrypt that value - that might be a red herring since 8.51 doesn't encrypt this value. 

Any chance this is not a clean 8.51 install and that you are dealing with leftovers from a failed prior upgrade?

What does the connection string look like in the data_engine.cfg file, is it readable text or an encrypted string?

[Andrew Cooper]

Its been I while since we did the upgrade from 8.5.x to 9.0.2 and we had the same issue in that the OS needed to be upgraded.  In our case we created a new VM with the (at the time) our current server OS (Windows Server 2016).  Then we:

• stopped both the primary hub, db server (both running 2008).
• made a cold clone of the DB (on top of the standard backups we had)
• restarted just the DB server
• ran the install of 9.0.2 on the new server using the old DB server (which worked)
• updated the secondary level hubs to connect to the new primary hub
• added the queues back into the new primary hub

We ran the process through several times on test setup to make sure that we had everything covered and confirm the downtime. One early Saturday morning it worked.  Later that month we moved the database to a new server with a new version of ms-sql

This side-stepped all the inplace upgrade issues you tend to get both for the OS and UIM

Cheers, Andrew

------------------------------
Knows a little about UIM/DXim, AE, Automic
------------------------------

[ca support]

Thank you, yes it was an issue with the DB passoword.It had "@" in it.

After changing the password, installer started properly and the upgrade was successful.

Regards,
Usha