Oracle Analytics Cloud and Server

Products Banner

Seeing undesired results in OAC usage tracking tables. How to resolve this?

Received Response

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):