Error While loading Crystal reports deployed on IIS 7.5

[Former Member]

Hi ,

We are encountering below error while loading Crystal reports deployed on IIS 7.5 for an asp.net mvc project 

Here is what we have done so far

1.       Downloaded Support Pack 14 (v.13.0.14.1720)  Install executable from http://scn.sap.com/docs/DOC-7824

2.       Installed it  on the development machine where Visual studio 2012 is available

3.       We have used web pages (.aspx) to load the crystal reports

4.       From VS 2012 it works fine; In localhost.

5.       Downloaded crystal report runtime 64 bit (64bit.msi)  from http://scn.sap.com/docs/DOC-7824    and deployed in web server

6.       Access the report page.  Getting below error

7.      Note : Both our application and IIS is configured for 64 bit

System.TypeInitializationException: The type initializer for 'CrystalDecisions.CrystalReports.Engine.CRPE' threw an exception. ---> CrystalDecisions.Shared.CrystalReportsException: Could not load C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win64_x64\crpe32.dll. at CrystalDecisions.CrystalReports.Engine.CRPE..cctor() --- End of inner exception stack trace --- at CrystalDecisions.CrystalReports.Engine.CRPE.CloseCrpe() at CrystalDecisions.CrystalReports.Engine.ReportDocument.InternalClose(Boolean bSetupForNextReport) at CrystalDecisions.CrystalReports.Engine.ReportDocument.Close() at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod, Int16 parentJob) at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename) at Avery.Magma.Web.WebForms.CrystalReport.Page_Init(Object sender, EventArgs e)

Thank you

[former_member11696 · Accepted solution]

Did you share the \temp folder and does IIS have permission to the CrytalReportViewer folder.

Use ProcessMonitor and/or Fiddler to check what the page is doing also.

Be sure to instlal under a local PC admin account so the installer can register all of the COM dll's.

Check the install log, you have to enable logging on MSIExec to see it.

Don

[Former Member · Accepted solution]

Hi ,

We have the D:\inetpub\wwwroot on the D drive ,and the folders that you have mentioned was not

available there .. we  created \temp and the folder D:\inetpub\wwwroot\aspnet_client did not have IIS_IUSRS permission now

We have given this user with read & execute privileges and tried to run the report .. But still we get the same error ..

Do we need to reinstall the runtime again?

We tried Fiddle but did not get any useful info .

[former_member183750 · Accepted solution]

I think Process Monitor (http://technet.microsoft.com/en-us/sysinternals/bb896645) may be more useful here than Fiddler - look for Access Denied error messages.

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow me on Twitter

[Former Member · Accepted solution]

Hi ,

we have asked server team to install the process monitor on the server ,

To keep you informed we initially installed 32 bit run time on the server .

Then we realised that our application was 64 bit , so we uninstalled 32 bit runtime .

Then we installed 64 bit run time . Do you believe this could cause issue ?

Is a reboot and clean installation required ?

[former_member183750 · Accepted solution]

No. The uninstall of 32 bit and install of 64 bit would not cause any issues (never heard of it anyhow).

And reboot should not be required either.

- Ludek

[Former Member · Accepted solution]

Hello Ludek,

We have uninstalled the 64 bit runtime from the web server. then re installed. then checked the web page. same error. then we rebooted the web server. then again accessed the web page. same error.

We had got the process monitor installed  on the server.  We accessed the web page that has crystal report. Below are the failed events.

1. Path not found  -

Searching for path D:\inetpub\wwwroot\aspnet_client\system_web\4_0_30319\crystalreportviewers13\js\crviewer\images\style.css\web.config

2. BufferOverflow

Path displayed is :  D:\inetpub\wwwroot\aspnet_client\system_web\4_0_30319\crystalreportviewers13\js\crviewer\images\style.css

3. Path not found

D:\inetpub\wwwroot\aspnet_client\system_web\4_0_30319\crystalreportviewers13\js\crviewer\crv.js\web.config

4. BufferOverflow.

D:\inetpub\wwwroot\aspnet_client\system_web\4_0_30319\crystalreportviewers13\js\crviewer\crv.js

The above specified folders,  where path not found error is reported, is not present in the server.  Are  these folders expected?

Thanks

[former_member183750 · Accepted solution]

I am not sure why your project is searching for "stuff" in that particular path. But it is, so I'd provide it with what it is looking for, where it is looking for it(?).

By default, the CR SDK looks for the viewer dir on the C drive. If this is different on your system, you need to configure this.

- Ludek

[Former Member · Accepted solution]

Hello Ludek,

The website physical path is under d:\inetpub\wwwroot .

When crystal report is installed it placed crystalreportviewers13  folder in c:\inetpub\wwwroot\aspnet_client\system_web\4_0_30319

Then we copied entire contents of C:\inetpub\wwwroot\aspnet_client\system_web\4_0_30319\crystalreportviewers13  to d:

But the same error. 

The path ... \style.css\web.config is neither available in c: also.  because style.css is a file.

[former_member183750 · Accepted solution]

The CR install has no idea that the app will be sitting on D drive so default is always C drive. What you did is a good start, but perhaps more configuration is needed. See if the the following helps:

Visual Studio 2012 Crystal Report not working on Windows Server 2012/ 0x800a1391 – JavaScr...

http://scn.sap.com/community/crystal-reports-for-visual-studio/blog/2012/10/16/report-appears-blank-...

- Ludek

[former_member11696 · Accepted solution]

This pathing problem in IIS has been resolved with SP 16.

Download it and then it should all work as before.

Don