IBM .dll Files are not being loaded.

Owned by Conor McCann
Last updated: Jun 24, 2020 by Daniel Stuart-KellyVersion comment

Environment:
iQSonar CR3 RC1
Windows 2012 R2 server, with SQL 2012 Standard Edition SP3
Installation is carried out using AD integrated user.
Expected Behaviour:
For .dlls to being loaded
Actual Behaviour:
ERROR - Load of file C:\Program Files\iQuate\iQSonar ScanEngine 4.0\bin\Protocols\iQuate.Sonar.Unity.Protocol.Informix.dll failed when trying to load IBM .dlls
Repro:
After installation > Open Locations > Create Credential
Select DB2 - No Connections available
No usable issue stored in the context, unable to resolve filename 'image-2017-03-13-16-38-13-254.png'
Select Informix - No Connections available
No usable issue stored in the context, unable to resolve filename 'image-2017-03-13-16-38-47-291.png'


Service log shows errors for both
Informix ERROR - Load of file C:\Program Files\iQuate\iQSonar ScanEngine 4.0\bin\Protocols\iQuate.Sonar.Unity.Protocol.Informix.dll failed
DB2 ERROR - Load of file C:\Program Files\iQuate\iQSonar ScanEngine 4.0\bin\Protocols\iQuate.Sonar.Unity.Protocol.DB2.dll failed


[13/03/2017 14:31:14 GMT Standard Time] - iQSonar ScanEngine - v4.0.1 (c) iQuate 2005-2015 (64-bit) {iQuate.iQSonar.Server.NotScan/?:0 @iQuate.iQSonar.ScanEngine.exe}
[13/03/2017 14:31:14 GMT Standard Time] - Initialising iQSonar service {iQuate.iQSonar.Server.NotScan/iQuate.iQSonar.Service:0 @iQuate.iQSonar.ScanEngine.exe}
[13/03/2017 14:31:22 GMT Standard Time] - Connected to database: iQSonarSECR2 {iQuate.iQSonar.Audit.DAL/iQuate.iQSonar.DAL.NHibernateDAL.NHibernateHelper:0 @iQuate.iQSonar.ScanEngine.exe}
[13/03/2017 14:31:22 GMT Standard Time] - Initializing Protocol Catalog: C:\Program Files\iQuate\iQSonar ScanEngine 4.0\bin\Protocols {iQuate.iQSonar.Server.NotScan/iQuate.iQSonar.Connections.ConnectionFactoryLoader:0 @iQuate.iQSonar.ScanEngine.exe}
[13/03/2017 14:31:22 GMT Standard Time] - Authenticode certificate confirmed for iQuate.Sonar.Unity.Protocol.CertficateAnalysis, Version=1.0.0.0, Culture=neutral, PublicKeyToken=7ab60d41c2cec0e2 {iQuate.iQSonar.Server.NotScan/iQuate.iQSonar.Util.InitialisationUtils:0 @iQuate.iQSonar.ScanEngine.exe}
[13/03/2017 14:31:22 GMT Standard Time] - Authenticode certificate confirmed for iQuate.Sonar.Unity.Protocol.Common, Version=1.0.0.0, Culture=neutral, PublicKeyToken=7ab60d41c2cec0e2 {iQuate.iQSonar.Server.NotScan/iQuate.iQSonar.Util.InitialisationUtils:0 @iQuate.iQSonar.ScanEngine.exe}
[13/03/2017 14:31:22 GMT Standard Time] - Authenticode certificate confirmed for iQuate.Sonar.Unity.Protocol.DB2, Version=1.0.0.0, Culture=neutral, PublicKeyToken=7ab60d41c2cec0e2 {iQuate.iQSonar.Server.NotScan/iQuate.iQSonar.Util.InitialisationUtils:0 @iQuate.iQSonar.ScanEngine.exe}
[13/03/2017 14:31:22 GMT Standard Time] - *ERROR - Load of file C:\Program Files\iQuate\iQSonar ScanEngine 4.0\bin\Protocols\iQuate.Sonar.Unity.Protocol.DB2.dll failed *{iQuate.iQSonar.Server.NotScan/iQuate.iQSonar.Connections.ConnectionFactoryLoader:0 @iQuate.iQSonar.ScanEngine.exe}
System.ComponentModel.Composition.CompositionException: The composition produced a single composition error. The root cause is provided below. Review the CompositionException.Errors property for more detailed information.

1) Could not load file or assembly 'IBM.Data.DB2, Version=9.7.4.4, Culture=neutral, PublicKeyToken=7c307b91aa13d208' or one of its dependencies. The system cannot find the file specified.

Resulting in: An exception occurred while trying to create an instance of type 'iQuate.iQSonar.Connection.DB2.DB2Client'.



[13/03/2017 14:31:22 GMT Standard Time] - Authenticode certificate confirmed for iQuate.Sonar.Unity.Protocol.DNS, Version=1.0.0.0, Culture=neutral, PublicKeyToken=7ab60d41c2cec0e2 {iQuate.iQSonar.Server.NotScan/iQuate.iQSonar.Util.InitialisationUtils:0 @iQuate.iQSonar.ScanEngine.exe}
[13/03/2017 14:31:22 GMT Standard Time] - Authenticode certificate confirmed for iQuate.Sonar.Unity.Protocol.ICMP, Version=1.0.0.0, Culture=neutral, PublicKeyToken=7ab60d41c2cec0e2 {iQuate.iQSonar.Server.NotScan/iQuate.iQSonar.Util.InitialisationUtils:0 @iQuate.iQSonar.ScanEngine.exe}
[13/03/2017 14:31:22 GMT Standard Time] - Authenticode certificate confirmed for iQuate.Sonar.Unity.Protocol.Informix, Version=1.0.0.0, Culture=neutral, PublicKeyToken=7ab60d41c2cec0e2 {iQuate.iQSonar.Server.NotScan/iQuate.iQSonar.Util.InitialisationUtils:0 @iQuate.iQSonar.ScanEngine.exe}
[13/03/2017 14:31:22 GMT Standard Time] -* ERROR - Load of file C:\Program Files\iQuate\iQSonar ScanEngine 4.0\bin\Protocols\iQuate.Sonar.Unity.Protocol.Informix.dll failed *{iQuate.iQSonar.Server.NotScan/iQuate.iQSonar.Connections.ConnectionFactoryLoader:0 @iQuate.iQSonar.ScanEngine.exe}
System.ComponentModel.Composition.CompositionException: The composition produced a single composition error. The root cause is provided below. Review the CompositionException.Errors property for more detailed information.

1) Could not load file or assembly 'IBM.Data.Informix, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7c307b91aa13d208' or one of its dependencies. The system cannot find the file specified.

Resulting in: An exception occurred while trying to create an instance of type 'iQuate.iQSonar.Connection.Informix.InformixClient'.

Resulting in: Cannot activate part 'iQuate.iQSonar.Connection.Informix.InformixClient'.
Element: iQuate.iQSonar.Connection.Informix.InformixClient -->  iQuate.iQSonar.Connection.Informix.InformixClient -->  AssemblyCatalog (Assembly="iQuate.Sonar.Unity.Protocol.Informix, Version=1.0.0.0, Culture=neutral, PublicKeyToken=7ab60d41c2cec0e2")


Checked the installation folder for the .dlls are they are present.
No usable issue stored in the context, unable to resolve filename 'image-2017-03-14-11-34-13-445.png'


Step-by-step guide

To resolve


  1. The files are installed currently during the MSI installation and are located here:

    C:\Program Files\iQuate\iQSonar ScanEngine 4.0\bin\Protocols\Drivers

  2. Stop Scan engine

  3. Copy IBM.Data.DB2.dll and IBM.Data.Informix.dll from there above folders to C:\Program Files\iQuate\iQSonar ScanEngine 4.0\bin

  4.  Restart Scan Engine