Cancelling Queries in OBIEE Manage Sessions

User_DTFOB

Hi Team,

There are certain cancelleling running queries which always come in Manage Sessions even after we click on Close All Cursors, Clear BI Server Cache with CALLSAPurgeAllCache(); and even after restarting OBIPS1. They only dissapear after we do a restart for OBIS1. These queries are causing the  server performance to go down(after many such queries gets accumulated)

We do not want this to happen in production as we cannot bounce the application to clear the cancelling queries

This is really important for us to fix before we move to production.Kindly guide.

OBIEE Version: 12.2.1.4.0 (Build BIPS-20200619210245 64-bit)

[Deleted User]

What are those queries doing in the background? Have you checked in the DB and with your DBAs? 90% of the time the issue isn't OBIEE itself but the way you modeled things or (much more often) the DB itself.

User_DTFOB

Hi Christian,

Thank you for the reply.

The queries are no longer running in the DB(checked in V$SESSION). We did not make any changes in DB.

They only appear in manage sessions. The main thing we noticed here is after we do a restart of OBIS1, the performance significantly improves for our analysis.

We want to understand, how these queries goes from the Manage sessions after we do a restart of OBIS1.

No other things helps like Close All Cursors, Clear BI Server Cache with CALLSAPurgeAllCache(); and even after restarting OBIPS1.

This is impacting the reports performance, every now and then we have to restart OBIS1 to get back to good performance.

[Deleted User]

Ok but that looks like you have a general issue with your OBIS - either how it's set up / configured or your RPD as this behaviour is definitely not normal at all.

But analyzing this via a forum thread is a tough ask indeed.

User_DTFOB

Hi Christian,

I will check and open an Oracle SR for this issue.

Any pointers where I can start to analyze would help.