Symptoms
We have upgrade our development environment from BlackPearl v4.6.7 to v4.6.10. Generally, everything seems to be working fine.
The only issue we have found is in some custom SSRS reporting we have. The SOURECODE data source type is still available in the list, but when we test a data source using it, we get the following:
Could not load file or assembly 'SourceCode.HostClientAPI, Version=4.0.0.0, Culture=neutral, PublicKeyToken=16a2c5aaaa1b130d' or one of its dependencies. The system cannot find the file specified.
The SSRS log files don't reveal much more:
library!ReportServer_0-2!2ad0!07/06/2015-16:02:23:: Call to GetPermissionsAction(/Data Sources/ErpACcessWorkflow).
library!ReportServer_0-2!804!07/06/2015-16:02:23:: Call to GetSystemPermissionsAction().
extensionfactory!ReportServer_0-2!2ad0!07/06/2015-16:02:23:: i INFO: A wrapper has been created for the connection to the SOURCECODE data source.
library!ReportServer_0-2!804!07/06/2015-16:02:23:: Call to GetSystemPropertiesAction().
library!ReportServer_0-2!2ad0!07/06/2015-16:02:23:: Call to TestConnectForItemDataSourceAction(/Data Sources/ErpACcessWorkflow).
extensionfactory!ReportServer_0-2!2ad0!07/06/2015-16:02:23:: i INFO: A wrapper has been created for the connection to the SOURCECODE data source.
processing!ReportServer_0-2!2ad0!07/06/2015-16:02:23:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'ErpACcessWorkflow'. ---> System.IO.FileNotFoundException: Could not load file or assembly 'SourceCode.HostClientAPI, Version=4.0.0.0, Culture=neutral, PublicKeyToken=16a2c5aaaa1b130d' or one of its dependencies. The system cannot find the file specified.
File name: 'SourceCode.HostClientAPI, Version=4.0.0.0, Culture=neutral, PublicKeyToken=16a2c5aaaa1b130d'
at SourceCode.Data.SmartObjectsClient.SOConnection.Open()
at Microsoft.ReportingServices.DataExtensions.ConnectionWrapper.Open()
at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.OpenDataSourceExtensionConnection(IProcessingDataSource dataSourceObj, String connectString, DataSourceInfo dataSourceInfo, String datasetName)
--- End of inner exception stack trace ---
Diagnoses
The issue was caused by using wrong version of the DLL (HostClientAPI.dll).
Resolution
After using the correct version of the DLL the issue resolved.
