windows CR application crash

[former_member857270]

Hi SAP Team,

We have one windows .net application in which Crystal report is integrated.
the current version of Crystal report runtime in the server is :13.0.32.4286(64bit)
Server Windows server 2012R2
The current .net Framework is 4.7.02558.
We used 13.0.4001 CR report engine in VS and downloaded fron Nuget package for application build.

So we have billions and more records for reporting. for this we have one Batchjob i.e Windows application trigered from Web application. currently, we take count of all reacords from Oracle database and then create list for fetch 1000 records from database.
We used threading in which we run 3 parallel theads and fetch and export records into PDF. so at a time 3 PDF start exporting with 1000 records.

problem we got suppose we have 5000 pdf files to be generate and after generating 1000 to 2000 files we get the Kernalbase.dll application crash issue. no other event and exception found in events.

we have used GC.Collect(); GC.WaitForPendingFinalizers(); and reportdocument.Close();reportdocument.Dispose(); methods on every thread end.

Please guide me

[ido_millet · Accepted solution]

Can you export to one PDF per batch (e.g. 1,000 groups)?

If so, one of the 3rd-party Crystal automation tools listed here allows you to split that PDF to dynamically-named individual files at a rate of about 40 files per second.

[DonWilliams]

Use Ido's suggestion, it's the best way to handle thousand of records.

And a reminder Crystal reports is a Reporting tool, it's not a database archiving tool, the DB server is much better at archiving data.

If you think about it who would actually view a report with millions of records....

[DonWilliams]

Hi Raj,

Why do you keep posting the same question multiple times?

https://answers.sap.com/questions/13894143/kernelbasedll-crash.html

Use SP 33, SP 32 had a lot of Viewer issues.

Don

[former_member857270]

Hi Don,
I have updated the question as Our application is not hosted on IIS. This is a Windows application and we call this service from web app. There is no direct communication between the Web app and the Windows app.

[DellSC]

The problem is that you got the SDK packages through Nuget and the version that you got is older than the version of runtime that you're using. You need to download the Crystal for VS integration for SP 32 and run that to get the correct assemblies to match your runtime - what's in Nuget is NOT kept up to date!

You can get the integration through the software downloads link on the wiki. Be sure that you get the .exe for SP 32. Right-click on the downloaded .exe and click on "Run as Administrator" to make sure that everything registers correctly. Then rebuild your application.

-Dell