Hello @Aman Jain-Oracle I am hitting below issue. Executing dataflow in OAC results in below error (in italics). This dataflow does a single transformation, that converts the field record_date in the dataset, from varchar to DATE. Transformation used is, “CAST(EVALUATE(‘TO_DATE(%1,%2)’ AS DATE, RECORD_DATE”, ‘YYYY-MM-DD’)…

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…

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.

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…

Okay. I've actually tried parsing this info from Query Text/Blob. It does'nt seem to give the right info. I am unable to find Canvas name in these fields. Also, what is the recommended procedure to generate the RPD ? Does it need to be re-generated when we connect to a new ADW? (in our case we have used an existing RPD…

Yes, we are leveraging RPD based approach and seeing this. Any recommendations to correct this? Screenshot 2021-09-30 at 10.48.22 PM.png

Datasource is Oracle ADW Dataset is an external table in ADW Purpose of simulating query error is to ensure the "usage tracking" table (utlogical) provides me details of 'query error' . I want to ensure that, its field success_flg returns a value=3 and its field saw_src_path returns the project/canvas name. I need this…

The field SAW_SRC_PATH in utlogical table returns null, when SUCCESS_FLG = '3' Is there a way to find the Project/Canvas name where the error has occurred? Thanks in advance, Chethana

Thank you

You are right. By broken I mean a Query Error. Would the Usage Tracking feature enable me to detect the text 'Query Error' when occurs? Would this text be part of the query_blob field? Thanks, Chethana

Closing on this, as it would be taken offline with the Oracle IT team

Hi Alan, I did configure the host name resolution. After this also, when I am in VPN, i am not able to access OAC PE from Chrome or Safari browsers. When I am in VPN, I am able to access OAC with PE only through Firefox (after bypassing OAC hostname from the proxy settings). Is there a Jira to track this issue please?…

Aman, I tried this. It still errors. Regards, Chethana

Thanks Aman. Regards, Chethana

Thanks a lot for your response Aman. * Is it not possible to download a particular projects' dva only (I do not want any other details) * Also, is it not possible to schedule the backup to happen automatically in OAC Thanks and Regards, Chethana

Thanks Steve. What exactly, you mean by query governor? Also, do you mean the enhancements would be part of OAC-Autonomous 5.6? Regards, Chethana

Thanks a tonne Fernando, for your response. To answer your questions 1) Is the dashboard going to a level of detail that you can't aggregate the data and reduce the dataset? Yes 2) What is the use case (don't need to go in details)? Users will drown on that amount of information, wouldn't? Can you consider saving the…

Thanks Phillipp! I think, i figured out the problem in my case. I am joining 2 datasets in my project here, where one is from a csv file and other is from a DB table. My source canvas is from the DB table and the target canvas created using csv file (I've joined the 2 datasets using common fields in them, in the "Prepare"…

Hello, Thanks a tonne. This has really helped me! Regards, Chethana

Hey Philipp, Yes, I found a solution for this. Let me tell you, how I addressed my challenges 1. The physical table, I have created in the database (used with "save data to" option in the dataflow) is not persistent. First time I run the dataflow, all records in the source table are copied to the physical table (in "save…