000038803 - RSA Archer Control Panel: Unable to open the instance after an upgrade

Document created by RSA Customer Support Employee on May 6, 2020
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000038803
Applies ToRSA Product Set: RSA Archer
RSA Product/Service Type: RSA Archer (On-Premise)
RSA Version/Condition: 6.5.0.7
IssueIn the Archer Control Panel, the instance will not open after an upgrade.

The following error is seen in the output window: 
 

ArcherTech.ControlPanel Error: 0 : ArcherTech.ControlPanel.Plugins.Instance.InstanceInitializationException, ArcherTech.ControlPanel.Plugins.Instance, Version=6.5.700.1008, Culture=neutral, PublicKeyToken=nullAn error occurred loading the instance.ArcherTech.ControlPanel.Plugins.Instance   at ArcherTech.ControlPanel.Plugins.Instance.ViewModels.InstanceViewModelBase.InitializeInstanceProperties()
                 at ArcherTech.ControlPanel.Plugins.Instance.ViewModels.InstanceDBSettingsViewModel..ctor(IEventAggregator eventAggregator, InstanceProperties properties, DialogFunc dialog)
                 at ArcherTech.ControlPanel.Plugins.Instance.ViewModels.InstanceTabViewModel.InitializeViewModel()
                 at ArcherTech.ControlPanel.Plugins.Instance.Views.InstanceTab.<Initialize>b__23_0()System.ArgumentException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089Keyword not supported: 'az32ouabcpdielr57/pabterunccumnjwxr1w+1hle5qkddlc6rildcmsm13zgt8xvmckjbir6othn5pgco5qd1j9xto+m4vkk2cto7ojy01za1qihst6m/qaralre7gng+rk0qyoh9utfzdm2e06q=;transparentnetworkipresolution'.System.Data   at System.Data.SqlClient.SqlConnectionStringBuilder.GetIndex(String keyword)
                 at System.Data.SqlClient.SqlConnectionStringBuilder.set_Item(String keyword, Object value)
                 at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value)
                 at System.Data.SqlClient.SqlConnectionStringBuilder..ctor(String connectionString)
                 at ArcherTech.ControlPanel.Plugins.Instance.ViewModels.InstanceDBSettingsViewModel.MapProperties()
                 at ArcherTech.ControlPanel.Plugins.Instance.ViewModels.InstanceViewModelBase.InitializeInstanceProperties()


 
CauseThe connection string for the instance database is either corrupted or not valid.
Resolution
  1. Run the following sql script against the configuration database.


delete tblXPropertyTag where property_id in(select property_id from tblproperty where property_key='ConnectionString')



delete tblProperty where property_key='ConnectionString'


  1. Open the Archer Control Panel, Go to Instance.
  2. Go to the Database tab. 
  3. Update the Database Server Name and Instance DB details.

Attachments

    Outcomes