Error: The given key was not present in the dictionary - Substation CONNECT

 Product(s):OpenUtilities Substation CONNECT
 Version(s):10.00.XX.XX to 10.07.XX.XX
 Subarea:Installation Error 

Error or Warning Messages

When OpenUtilities Substation CONNECT is launched the following error messages occur pops up.

Internal Error:                Ul Error Message The given key was not present in the dictionary
TargetSite:            Void FillTaNe(lnt32. System String. System Data DataTaNe ByRef)
DeclarmgType:     MDBProxy ConnectionManager
Attributes:              internal
Member:                Type Method


The below Error Message might be coming may be due to the Reason that the machine on which OpenUtilities Substation CONNECT is installed might have 32bit version of Microsoft Office or 32bit version of Access Database Engine installed. Since Substation CONNECT is a 64 bit software its compatible with Microsoft Office 64bit or to be specific Access Database Engine 64bit. You can refer the below Compatibility Chart Wiki Link for Promis.e CONNECT for more details.

In Some cases it is seen that this issue is also seen when more than one Access Database Engine are installed on a Machine.

How to Check if MS Office is 32bit / 64 bit 

1. Launch any MS Office Application like Word / Excel /  Power Point, then click on Account >> About e.g. Word. See below image for reference.


How to Check for Multiple Access Database Engine

1. Go to Control Panel >> Programs and Features and search for Access Database Engine in Search. 

Steps to Resolve:

For Machine with 32bit Microsoft Office

1. Install Microsoft Office 64bit after Uninstalling Microsoft Office 32bit.

Note: Please contact your IT Team before uninstalling MS Office / Access Database Engine from your machine.

For Machine with Multiple Access Database Engine. 

1. Go to Control Panel > Programs & Features and uninstall all the versions of Access Database Engine. 

2. Next Install a Access Database Engine 2016 64bit using the below Link.

 Original Author:Satish Saptasagar