Errors when viewing data with Crystal Report Viewer.

[Former Member]

we receive the following errors when we try to merge a crystal report with data, we are using a crystal report viewer to display the report.

Can someone help us with where we might be going wrong?

Thanks

Rajesh

General Information

*********************************************

Additional Info:

ExceptionManager.MachineName: CCS104

ExceptionManager.TimeStamp: 02/10/2008 12:40:31

ExceptionManager.FullName: Congestion.Framework.ExceptionManagement, Version=33.36.0.0, Culture=neutral, PublicKeyToken=null

ExceptionManager.AppDomainName: /LM/W3SVC/1/ROOT/BackOfficeTR4-1-128674174088125000

ExceptionManager.WindowsIdentity: NT AUTHORITY\SYSTEM

Renewal charges Statement Id : 37171

Unknown Database Connector Error

Error in File C:\WINNT\TEMP\{AE9A7C1D-F11A-41CC-B2F7-BC1062DC3A5B}.rpt:

Unknown Database Connector Error

Stack Trace : at CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e)

at CrystalDecisions.CrystalReports.Engine.ReportDocument. (Object

)

at CrystalDecisions.CrystalReports.Engine.ReportDocument.SetDataSource(DataSet dataSet)

at Congestion.Core.PresentationTier.BackOffice.WF_NewReport_P.DownloadPDFStatement(Int64 lngCanId, Int64 lngFasId, String strChargeType)

at Congestion.Core.PresentationTier.BackOffice.WF_NewReport_P.Page_Load(Object sender, EventArgs e)

Source : CrystalDecisions.ReportAppServer.DataSetConversion

[Former Member · Accepted solution]

Hi Rajesh,

Are you getting the error message on Development machine or Production machine.

Please let us know the code snippet that causes the error.

Also let us know the evnvironment details as well as CR , .Net Versions.

Thanks,

Prasad Kanchan

[Former Member]

Hi,

Need more info-

CR version?

VS version?

Web or desktop application?

development or deployment issue?

just to give it a try-

Try to give read permission to the C:\Windows\temp folder for the current user and if this is a web app then for the ASPNET in case of IIS 5 and IIS_WPG in case of IIS 6.

Hope that helps!!

Regards,

Amit

[Former Member]

Hello Amit / Prasad,

The Crystal Reports version is XI - 11.0.33.0

.NET version 1.1. with SP1, web application - asp.net

This problem arises on the Deployment / Production servers.

We have observed that we can pull up close to 4 reports without the system throwing any errors on a 5 th try it fails.

An error message is logged in the System log - asp.net_wp.exe has stopped unexpectedely and this causes the website to crash affecting all users.

Thanks

Rajesh

[Former Member]

Hi,

Its a best practice to use the code given below in the unload event of the page or the code can also be written in a button press event so that the disposing is ensured manually(If sessions are in use).

boReportDocument.Close(); 
boReportDocument.Dispose(); 
GC.Collect(); 

Note: boReportDocument is the object of ReportDocument.

This code disposes the report object after using it.

Check the issue with [filemon|http://technet.microsoft.com/en-us/sysinternals/bb896642.aspx] utility.

Amit

[Former Member]

We have our coding standards in place, and they follow the mentioned ones.

I have done some preliminary investigation and realised it could be a problem with Crystal Reports XI Service Pack 4.

We have these problems after installing SP4.

Thanks

Rajesh