Skip to Content
avatar image
Former Member

Crystal Reports Page Server - Oracle Session Not Closing - reg

I am encountering issue with Crystal Reports Page Server when it tries to retrieve the data from Oracle Database while refreshing the existing report. I can see multiple Oracle sessions hanging when multiple people open the report (particularly 1 report) that may have many records (more than 20000 that is currently set limit in the page server configuration). So, Unless I kill those sessions using kill command under Oracle Database server, not going at all.

Its currently causing the Database Server load increase and slows other processes.

Is it worth to make the # of records to be retrieved as "Unlimited" instead of 20K to avoid this issue ?

The Oracle Database connection also doesn't get closed

even after the User log out successfully.

Thank You

Ramesh Vasudevan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jul 23, 2009 at 05:30 PM

    Hi,

    Did you get this problem resolved?

    I am having the same issue with Crystal PageServer not releasing memory.

    Thanks

    Srinivas

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      if the sessions are kept atcively open due to the BO side restarting the CR processing server should drop them. Just try this in order to identify where the problem exactly is.

      Regards,

      Stratos