000037134 - "Initialization Failed" error in RSA Archer Offline access after upgrading to Archer 6.5

Document created by RSA Customer Support Employee on Jan 28, 2019
Version 1Show Document
  • Comment • 0
  • View in full screen mode

Article Content

Article Number000037134
Applies ToRSA Product Set: Archer
IssueWhile attempting to use RSA Archer Offline Access, the following error is displayed:
User-added image
 
CauseOffline Access for version 6.5 and 6.5.x does not upgrade the Microsoft SQL Server 2012 Express LocalDB to Microsoft SQL 2017 Express LocalDB.

Note: After upgrading to RSA Archer 6.5.x versions, this issue does not impact the user’s upgrade of their Offline Access to later versions of 6.5.x releases as SQL Server 2017 Express LocalDB will already be installed.
ResolutionThis issue will be addressed in a future Archer release.
WorkaroundUpgrading offline access from a previous version of 6.5 to 6.5 or later requires the below installation steps:
 
  1. Before upgrading the primary Archer Platform, be sure to run an Offline Sync from Offline Access to update the unsynchronized data from Offline Access to the Archer Platform.
  2. Open the Windows Control Panel in your offline access VM or laptop (running Windows 10).
  3. Go to Programs and Features > Uninstall a Program.
  4. Locate the Offline Access program.
  5. Right-click, and then select Uninstall Offline Access.

Uninstall Offline Access also uninstalls the following programs:
- IIS 8.0 Express
- Microsoft SQL Server 2012 Express LocalDB
- Microsoft Sync Framework 2.1 Database Providers
- Microsoft Sync Framework 2.1 Core Components
- IIS Express Application Compatibility Database x86
- IIS Express Application Compatibility Database x64
 


  1. Open the Registry Editor on the same Offline Access machine by entering regedit at the command prompt.
  2. Locate the key to delete.  Go to:

Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Microsoft SQL Server\UserInstances\{A673408F-0241-4C84-9C59-47282AAF960E}

The registry key depends on unique IDs and usernames but it will look similar to the following:
{A673408F-0241-4C84-9C59-47282AAF960E}
 


The Key that needs to be removed has a DataDirectory value similar to the following:
C:\Users\UsernameGoesHere\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\OfflineArcher


  1. Delete the key that was located in the step above.
  2. Close the registry editor.
  3. Run the installer for Offline Access 6.5 or 6.5.x.
  4. Wait for the installer to finish.
  5. After installation is complete, you can run an Offline Sync.

Attachments

    Outcomes