Oracle Analytics Cloud and Server
Seeing undesired results in OAC usage tracking tables. How to resolve this?
Summary:Seeing undesired results from production usage tracking tables
Content (required):
Recently, we moved to new production environment and have setup a new OAC connecting to an ADW. To enable usage tracking of this OAC, we have used an existing RPD (which was originally used in the dev environment).
Usage tracking is now enabled in the new prod. However, we are not seeing desired results when we query these tables.
How do I resolve this issue? What is the recommended procedure to enable Usage Tracking of OAC connecting to ADW?
Please let us know.
SQL query, "select saw_src_path,query_blob,query_text from utlogical where success_flg=3 and saw_src_path like '%canvas%'", gives me desired results with old ADW - I have issues when connected to new ADW using same RPD.
Please help me get desired results here.
Version (include the version you are using, if applicable):
OAC 6.2
Code Snippet (add any code snippets that support your topic, if applicable):
Answers
-
Your question is a tad confusing. It sounds like you are trying to set up usage tracking from a new OAC instance, but you reference a new ADW instance as well...
In either case, here are a couple things to look into:
- Is your connection pool in the RPD pointing to the correct ADW instance?
- In your OAC console, did you update the Usage Tracking settings to align with your table names?
-
Hello,
Pls. find my responses.
- Is your connection pool in the RPD pointing to the correct ADW instance?
The answer is 'Yes'
- In your OAC console, did you update the Usage Tracking settings to align with your table names?
In OAC console, we updated the Usage Tracking settings to allign with different table names for the new OAC (in the document they say, we could use any table names for usage tracking..).
Do you think choosing a different table name has caused this issue?
-
The table names should be arbitrary. So long as whats in ADW matches the tables you've define in the Console/BI Server.
-
Joshua,
Is there any documentation w.r.t Usage Tracking that talks about the field, success_flg and its value = 3 when there is query error?
I am asking this because, I am seeing success_flg=3, though there are no query errors generated for a particular date.
-
That shouldn't be happening. From the documentation:
-
Hello,
I am able to fetch the number of query errors in OAC by running the query, "select count(*) from utlogical where success_flg=3 and saw_src_path is not null and saw_src_path like '%shared%'"
and this works fine.
As, I run this query for every one hour, I would like to get this count for past one hour duration only. I tried using the fields, start_hour_min and end_hour_min to fetch this information. Apparently, they dont seem to give me the right results. Is there a way to fetch the count for past one hour only?
Thanks,
Chethana
