ASP.NET 2.0, CRYSTAL REPORTS & ABORTED THREAD

[jkb17]

Hello,

I have created a web application that is used for report processing. The way it works is as follows:

The user goes to a page, select the 5 reports they want to run (5 checkboxes) and specifies the cut off date. The reports are made in Crystal Reports RC 2 with ASP.NET using VB.NET 2.0. The page itself is Ajax enabled and shows a progress bar graphic upon click of the button.

I retrieve a dataset and bind it to the crystal report (aka the push method) and then export to PDF format. The dataset is recycled because I filter the report's dataset once per user (approx 15 users). This saves multiple calls to the database.

On my development machine, it works like a charm. BEAUTIFUL!!! On the server, I am getting the "Thread was aborted. Load repot failed." error message. It is being fired in the asyncPostBackError event. The error message is inconsistent as to timing. It occurs seemingly randomly.

I've confirmed that all assembiles, includes and reports are pointing to correct location.

anyone have this issue or know a workaround?

 

[jmeckley]

when a report is opened a copy of the rpt is made
[tt]c:\windows\temp\MyReport{GUID}.rpt[/tt]

users needs read/write permissions to [tt]c:\windows\temp[/tt].

for some reason BO thought what better place for temp internet files than the temp windows directory on the OS itself.

As a workaround/hack/fix give the local everyone or local users goup read and write access to [tt]c:\windows\temp[/tt]. it's not pretty at all, but it works. They don't need full control.

you may also be able to mess with the OS envirnment variable and point the temp files somwhere else, but this a global change to the server, not just your app.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[jkb17]

Thanks, Jason. I tried that one already. The reports bomb in mid run. Let's assume that 200 pdfs are being created. It may bomb at # 25 or # 65 and there is not apparently rhyme or reason to it.

Thanks for the try on the help.

Jim

 

[jmeckley]

i'm not exactly sure what CR RC2 is (.net or BO product). I have heard that CR for .net limits the number of concurrent users. I haven't confirmed this.

Maybe there is a concurrent user limit with RC2 as well. GC (garbage collection) may not have cleaned up orphan objects.

If ReportDocument implmements IDisposable. call rptDoc.Dispose(); right after the pdf is generated. this will release the resources for GC.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[jkb17]

CR RC2 is essentially version 11.5. Version 11 did not have Visual Studio 2005 support. Version 10 is the version built in with VS 2005. If you buy CR XI and want to use it within Visual Studio then you have to download this other installer that is technically called CR XI RC2. Its the same as crystal 11 but with VS 2005 support.