vb.net - Tips for debugging likely Crystal Reports hang in ASP.NET -
Trying to keep this small: Our shipping personnel sent on using a windows mobile-enabled barcode scanner Order the customer to scan the serial number of the item. This data is presented through the asmx web service and a report is automatically showing customer information to a client printer and shows details of the item to be sent. It all happens in an intranet environment.
Recently, I was using the Microsoft Report Engine which was created in the Viewer Studio (.rlcc file) and code generated to generate the report and printed without user intervention.
Recently, I took part in some reports in MS reports against formatting limitations and instead applied reports in Crystal Reports (10.5.3700). This code works fine, but after running for a day or more for a few hours, the ASP.NET Worker process is hanging (not sure that it is a proper term). Without throwing an exception, the generating / printing process always keeps running. Recycling the apple, for a while, everything works again.
The report is using the "push" mode, where the report is given a dataset typed instead of reaching the database itself. To extract the CR ReportDocument.PrintToPrinter () method from the equation, I have considered exporting PDFs or similar reports, and then the result is printing the file independently. But I have yet to do this Great way is not found.
To search for the problem, I have read all the complaints about the buggy bug, but I hope there is a bug in my code which is for cleaning after the report is printed. Import CrystalDecisions.CrystalReports.Engine Import CrystalDecisions.ReportAppServer Import CrystalDecisions.Shared Public Class CrystalReport Personal _report ReportDocument Public Sub-New (ByVal Path as String) _report = New ReportDocument (as) _report.Load (path) end subsystem sub-set data source (data dataset as data dataset) _report.SetDataSource (dataset) termination sub-public sub addParameter (string as object, byVal name as ByVal value) dim crParameterFieldDefinitions ParameterFieldDefinitions = _report.DataDefinition.ParameterFields dim crParameter1 Dimam ParameterFieldDefi Nition = crParameterFieldDefinitions.Item (name) Dim parameterValue CrystalDecisions.Shared.ParameterDiscreteValue = New CrystalDecisions.Shared.ParameterDiscreteValue () P ArameterValue.Value = Value crParameter1.CurrentValues.Add (parameterValue) crParameter1.ApplyCurrentValues (crParameter1.CurrentValues ) And sub-public all print end (by-by-printer path) _report.PrintOptions.PrinterName = PrinterPath _report.PrintToPrinter (1, true, 0, 0) closed () End sub personal sub-lock () _report.Close () _report.Dispose () _report = Nothing else from the other end class sub
Any ideas for debugging this further? I've never had to resort to real Windows debugging (WinDbg, Process Explorer, etc.), so any recommendation which would be great to try first on debugging equipment.
Thank you.
You are trying to get your report object on off ()
ing and settlement ()
Page_Unload
trying the status of your ASP Can the .NET page talk about a problem on Microsoft ASP.NET platforms where the report reaches the maximum number of processing jobs, but I think that may be related to this issue.
Comments
Post a Comment