Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member
Former Member replied

Can give that a go, but wouldn't really be a viable solution on my production system. Plus what would happen to existing sessions that were open that weren't orphaned? We notice that these rouge sessions basically end up throttling the oracle db.

Could in reality be an oracle issue as there are scripts in theory to clean these items up. Problem is the scripts work for other processes, just not ones originally owned by BOE.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question