cancel
Showing results for 
Search instead for 
Did you mean: 

Failed to load database information Error After publishing the code IN IIS

0 Kudos
946

Hi,

We are migrating our all the reports from the old version of Crystal report to new CR2016. I have done the development phase of this application. At the time it shows "Failed to load database information" error for resolving that I have installed the 32 bit oracle and the issue is resolved. Now I have hosted the same application in the IIS of the same machine. But now it showing the same error message for those reports that have the error before installing the 32 bit oracle client. At the time of publishing I have I have enabled the 32bit application to "False". After that error is changed to "The type initializer for 'CrystalDecisions.CrystalReports.Engine.ReportDocument' threw an exception" for all the reports. Please suggest a way to resolve this issue.

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Why are you using 32 SP 27 and 64 bit SP 26?

Uninstall both 32 and 64 bit MSI's, if you read the download WIKI DO NOT install both, it causes problems.

https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads

Once you uninstall the MSI's then uninstall the Cr for VS ( last one in the list ).

Now reinstall the SP 27 EXE only, and select the 64 bit runtime at the end of the EXE install.

Test again.

On the WEB server install only the MSI's, CR runtime is for your platform and not the OS platform, so if IIS apppool is running in x86 mode then you only need to install the x86 MSI.

Don't mix versions we don't support it.

Don

Answers (2)

Answers (2)

0 Kudos

CR runtime is for your app platform and in this case what IIS is set for.

So if your app pool is set to 32 bit then you need the 32 bit runtime package installed, for x64 then the x64 bit MSI installed on the IIS Server.

Error simply means it can't find the CR runtime.

So depending on the platform you also need to matching 32/64 bit Oracle client installed.

Don

0 Kudos

Hi,

In my system have installed 32 bit and 64 bit clients, Installed Crystal report runtime engine for 32 bit and 64 bit , SAP crystal report version for Visual studio. I have tested my application in different ways in IIS that is enabled 32 bit to True and False. When 32 bit is True it will gives the error as "Error in File rptAuditRequisitionAndBuycard 34532_34560_{76207945-B343-41AE-93BD-0CB8C7D1190F}.rpt: Failed to load database information.".If Enable 32bit = false it will return the error "The type initializer for 'CrystalDecisions.CrystalReports.Engine.ReportDocument' threw an exception." This issue is arised after hosting the application in IIS.

While I debug(Run using Visual studio) these are working fine. Please help me to sort out this issue.

S_Sriram
Active Contributor
0 Kudos
0 Kudos

Hi Sriram,

I have installed SAP Crystal report runtime engine for .net Framework (64 bit) and SAP crystal report version for Crystal report in my system. Only after that reports are worked perfectly at the run time of development with VS. But when I deployed some of the reports are showing the database load information error.