Usage Tracking inconsistently updated

Machiel_Treffers

Hi all,

I'm running an OBIEE 12.2.1.2.0 environment with Usage Tracking enabled. UT works fine in 99% of the times we sometimes we see that it is inconsistently updated.

For example: we are running an agent which runs a 5 page dashboard. Some times some of the pages do not finish in time (we've a query limit of 1200s) and this query (or page) is marked in UT as unsuccessful with the accompanying error. There are also times that this page is completely missing from UT... and this is obviously inconvenient when it comes to errors (please note the screenshot).

Our NQsConfig.ini looks like this:

I've already checked all columns and data types for the UT tables in the RPD and these seem consistent with DB (we're using an Oracle 12.1.0.2.0 DB).

I did try to find logging for UT (I thought it was there somewhere..) but didn't find it.

Can someone elaborate on this issue or might point me in the direction of the UT logging?

Thank you!

Kind regards,

Machiel