OBIEE 12c Usage tracking

Question

Hi,

OBIEE 12C version - 12.2.1.4.0

There is a column TOTAL_TEMP_KB in usage tracking table(S_NQ_ACCT) showing in negative ! not sure what does that mean? the number is quite high!

Can someone help me to understand this?

TOTAL_TEMP_KB

-739411654

-740259871

Regards

Hesh

Hesh · Answer

Thanks Joel,

That is one report is part of a Dashboard.. that is an overview page users will leave it open on the desktops without knowing that it is actually running code to try and create the chart.

The starting hour and ending Hour in usage tracking shows it runs for 30 min .. and Error Message shows following .. time out.

I strongly believe this is causing slowdown of other reports performance.

"[nQSError: 60009] The user request exceeded the maximum query governing execution time.

[nQSError: 17001] Oracle Error code: 1013, message: ORA-01013: user requested cancel of current operation

at OCI call OCIStmtFetch."

Regards

Hesh

Joel Acha · Answer

Can you allocate more resources to the server and see if you still get these negative numbers? Have you tried to get to the root cause of what is triggering this? Do you have some very large analyses/exports that are running on your system?

Hesh · Answer

This is what I can interpret for minus( -) , the processing still requires that amount of memory and that is not available!