Skip to Content

load report failed after version upgrade in periodic manner

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 24, 2018 at 03:56 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 27, 2018 at 07:10 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded