load report failed after version upgraded to visual studio 2017

113 Views Last edit Mar 28, 2019 at 03:26 PM 2 rev

Hello every one

We have upgraded our application from ASP.Net 2.0 Framework (VS 2008) to ASP.Net 4.0 Framework (VS 2017)

We also upgraded Crystal Reports to the newer version 13.0.3500.0.

After Upgrade, Application is working fine.

But we found that after some time "Load Report Fail" error comes and we are not able to generate Report.

Once we reset IIS, it works fine for some period.

Now it has become recurring issue which is fixed after IIS Reset. We need to resolve it on urgent basis.

We have taken below mentioned steps :

1. Give Read / Write rights to Temp Folder

2. IIS Users given Read / Write path to Application Folder.

3. closing and disposing of all objects related to each printjob after they are completed, we are disposing all objects in Page_Unload event as below :

Private Sub Page_Unload(ByVal sender AsObject, ByVal eAsSystem.EventArgs) Handles Me.Unload

Me.crv_report.Dispose()  
Me.crv_report = Nothing  
rpt.Close()  
rpt.Dispose()GC.Collect()End Sub

4.error to show up randomly,It is not a fixed interval. Based on usage it randomly gives error in 3 - 4 Hours.

5. MS recommends cycling IIS because it can't defrag memory on the fly, only way to release and clean up memory in Windows is to close the app and start it up again. We have configured IIS Application Pool with Recycling after Regular Time Interval (Minutes) : 60.

Why did this problem appear And What is the solution ?

Please provide your valuable inputs,.