ReportViewer hangs on 2008R2 server after SP1

[Former Member]

We've got a couple of ASP.net application on a 2008R2 machine. After upgrading this box to 2008R2 SP1 one certain report stopped working. There is a message: 3005 in the event log: Report could not be loaded. The weird thing is that if I replace the report by another one everything is fine. All other reports are running. When I put this report in the CR2011 Application it runs fine...

Any hints?

Thanks, Oliver

[saurabh_pathak · Accepted solution]

Hi Oliver,

Could you please provide the

1) Version of Crystal Reports runtime version and it's patch level?

2) .NET Framework Version?

3) Is OS x86 or x64?

Thanks,

Saurabh

[Former Member · Accepted solution]

Hello,

1) Version of Crystal Reports runtime version and it's patch level?

SAP CR runtime engine for .NET framework 4 v13.0.1.220 (x64)

SAP CR runtime engine for .NET framework 4 v13.0.0.99 (x86)

2) .NET Framework Version?

The app pool is .NET 2.0 in VS the project settings are 3.5. This seems weird to me but it is perfect with

over twenty other apps that are made in the same style. I already tried to switch everything to 4 (VS settings and

app pool) but the error remains.

3) Is OS x86 or x64?

OS is x64

[saurabh_pathak · Accepted solution]

Things that you can try:

1)Run the Process Monitor, when you run the application, set appropriate filters

Search for access denied for the report.

2) If your app pool is using Integrated Managed Pipeline change it to use Classic.

Make sure that you have set the "Enable the 32-bit" app to true.

3) Is there any specific reason for installing both of them?

SAP CR runtime engine for .NET framework 4 v13.0.1.220 (x64)

SAP CR runtime engine for .NET framework 4 v13.0.0.99 (x86)

Thanks,

Saurabh

[former_member188030 · Accepted solution]

Hi,

In addition to Saurabh's questions -

- Does the application target 32 bit or 64 bit platform? if it is 32 bit platform then set the 'Enable 32 bit applications to true' as Saurabh suggested else install only 64 bit runtimes and set the above option to false.

Set the .NET framework as it is in the development platform.

Also compare the file size of the reports with the ones in the development machine.

Check if the application pool identity has been recently changed, which can cause permission issues.

If none of these work, try compiling the application targetting .NET 4.0 and set the App pool to the same.

Hope it helps,

Thanks,

Bhushan.

[Former Member · Accepted solution]

Thanks to you both, I'll try and report here.

What seems strage to me is that there are about twenty apps in the pool and all of them are running fine - just one started hanging since we applied SP1 to the server...

Best regards, Oliver

[Former Member · Accepted solution]

OK, here I am back and I am at the very end of my knowledge. That's what I did

- compare .net RT versions > identical

- tried to move app to a pool using .net 4 > same behaviour

- compared report files > binary identical

Finally I set up a whole new blank report project with VS2010. Moved it onto the server

and specified a report that ran fine > everything was OK

Changed just one thing: Report definition was changed to the report causing problems > App hangs

Copied the report file to my dev machine and opened it in CR2011 > report works without complaints.

This makes me think that there is "something" in the report that is causing the problem, but how can I track

this down?

Thanks for any advise...

Oliver

[former_member183750 · Accepted solution]

Oliver, can you expand \ explain:

Changed just one thing: Report definition

What does that mean?

- Ludek

[Former Member · Accepted solution]

Hello,

it means that I changed Default.aspx from

<CR:CrystalReportSource ID="CrystalReportSource1" runat="server">

<Report FileName="Good_Report.rpt">

to

<CR:CrystalReportSource ID="CrystalReportSource1" runat="server">

<Report FileName="Bad_Report.rpt">

Everything runs fine with Good_Report.rpt but using Bad_Report.rpt causes the problem. Bad_Report.rpt

runs fine the CR2011 app on my machine. Both reports use the same datasource.

Thanks, Oliver

[former_member183750 · Accepted solution]

Run the "bad" report in the CR designer. Enable "Saved Data" and refresh the report. Page through to last page. Save. Run this saved data report in an application. Do not connect to a DB at runtime, do not refresh the report at runtime. Does the report come up now? (This is just a test...)

Ludek

Follow us on Twitter http://twitter.com/SAPCRNetSup

Got Enhancement ideas? Try the [SAP Idea Place|https://ideas.sap.com/community/products_and_solutions/crystalreports]

[Former Member · Accepted solution]

I did it. Opened in VS, refreshed, enabled "save data", saved report, copied to server.

result: still hangs.

[former_member183750 · Accepted solution]

If I contact you over email, would you be able to share the saved data report with me so I can have a look?

- Ludek

[Former Member · Accepted solution]

sure I can send you the report. Where do you want me to send it to?

Thanks, Oliver

[former_member183750 · Accepted solution]

I'll send you an email Oliver. Just zip up the report and atttach it to the email.

- Ludek

[former_member183750 · Accepted solution]

Oliver, I inserted the report into a web app and it came up just fine. I did the same for a win, just because I had one running and there the report also came up just fine. I took a quick look at the construction of the report and it looks fine. Table linking, DB connection, options, etc. A few things we can try:

1) It may be interesting to see what [Process Monitor|http://technet.microsoft.com/en-ca/sysinternals/bb896645.aspx] logs tell you (Make sure you filter for the process, else the logs get too long). Look for any unusual activity towards the end of the log.

2) Create a new test web app - one line of code:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

CrystalReportViewer1.ReportSource = "<path to report>\3021_Rechnungsabschluss_CE.rpt";

End Sub

3) A test win app as above may also be worth while

4) I am dubious that the following will help, but it will not hurt: Enable the option "No Printer" and "Dissociate Formatting Page Size and Printer Paper Size"

- Ludek

[Former Member · Accepted solution]

Hello Ludek,

I did the following:

- created a win app like you proposed and ran it on the server. I was prompted with a printer

install request for a printer from one of our other servers.

- agreed to install the printer

- app came up

- tried to fire up the asp.net app... and it came up!

It must have been something related to that printer that was not installed on the server before but was included

in the report file, I guess.

Anyway - it's running now - one problem off the list and THANK YOU VERY MUCH!

Oliver

[former_member183750 · Accepted solution]

How weird. I wish I could explain it... for now, I'll story this in the back of my brain for future reference. Maybe one day it will make sense.

Have a great weekend,

- Ludek