load report failed after version upgrade in periodic manner

[former_member606640]

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.

Why did this problem appear And What is the solution ?

Please provide your valuable inputs,.

[former_member606640]

Thanks for the quick response Don.

1. Are you closing and disposing of all objects related to each printjob after they are completed?

Ans: Yes, we are disposing all objects in Page_Unload event as below :

Private Sub Page_Unload(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Unload

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

End Sub

2. How long does it take for the error to show up?

Ans: It is not a fixed interval. Based on usage it randomly gives error in 3 - 4 Hours.

3. 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.

Ans: We have configured IIS Application Pool with Recycling after Regular Time Interval (Minutes) : 60.

[former_member11696]

Are you closing and disposing of all objects related to each printjob after they are completed?

How long does it take for the error to show up?

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.

Don