Cognos Queries showing in suspended state

[Cognos91]

Hi All,

I am seeing an issue with the simple list cognos analytics queries being displayed in suspended state in the database. When I create a simple list query with only attributes, then it renders the data in Cognos. However, when we monitor the database, then it looks like the query is going in a suspended state.
When we drag and drop a measure onto the list report, then it does take a while to render, this may be attributed to the amount of data being pulled in.
However, we are trying to ascertain whether the queries going in suspended state is an issue with Cognos Analytics or is it an issue with the database?

We are using CJAP SSO authentication for Cognos Analytics v11.11.

Has anyone encountered this issue with suspended queries?