Symptom
We recently finished migrating our CR from an old version to the new Crystal Report Server 2016 SP04.
We are in the process of migrating our applications and web services to use the newer DLL versions of this new platform. One of the most important of the applications that need to be converted is the one that open one or more Crystal Reports (CR), pass parameter values and then save the report as pdf. This application worked perfectly under the older version of Crystal Enterprise server but on the CRS 2016 installation is giving us headaches. After much reading on the SAP portal documentation and elsewhere on the web we were able to make it run successfully on the development tool (Visual Studio 2016).
Here is the actual code that do the work:
ReportDocument cryRpt = new ReportDocument();
cryRpt.Load(reportName); // pass the logon credentials
ConnectionInfo crConnectionInfo = new ConnectionInfo
{
ServerName = GetConfigKeyValue("DBServer"),
DatabaseName = GetConfigKeyValue("DBName"),
UserID = GetConfigKeyValue("DBUser"),
Password = GetConfigKeyValue("DBPwd")
};
var crTables = cryRpt.Database.Tables;
foreach (Table crTable in crTables)
{
var crtableLogoninfo = crTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
crTable.ApplyLogOnInfo(crtableLogoninfo);
}
int y = 0;
foreach (string parameterName in cmcParameterCollection)
{
if (queryParamList != null) cryRpt.SetParameterValue(parameterName, queryParamList[y]);
y++;
}
cryRpt.ExportToDisk(ExportFormatType.PortableDocFormat, fullPathTempPdfFile);
cryRpt.Close();
cryRpt.Dispose();
The problem comes when we try to migrate the application to the production web server. The application complies without problems but when we try to publish it on our production server it errors out with the following:
Could not load file or assembly 'BusinessObjects.Enterprise.Sdk' or one of its dependencies. An attempt was made to load a program with an incorrect format.
No matter what we do (re-reference the DLLs, create a new application from scratch, move the publishing to a different server) we get the same error. We even tried to add as many Crystal and Business Object dlls as possible in the references but still the error persists. We installed the latest BO .NET SDK (both 32 and 64 bit) and even the CR for Visual Studio Runtimes (again, both 32 and 64 bit) but no success.
We even installed Visual Studio in the actual production server where the CRS 2016 is installed (a big security risk but our desperation forced us to take desperate measures) and created the deployment package there but the final outcome is the same: the 'BusinessObjects.Enterprise.Sdk' assembly still has problems.
Read more...
Environment
Crystal reports for Visual Studio
Product
Keywords
Could not load file or assembly 'BusinessObjects.Enterprise.Sdk' or one of its dependencies , KBA , BI-DEV-NET , BI Software Development Kits (SDKs) - .NET or Other , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.