Seeing undesired results in OAC usage tracking tables. How to resolve this?
Summary:Seeing undesired results from production usage tracking tables
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%'"