Oracle Communities

Oracle Analytics and AI

Child Item

Message Alert Data Flow/Sequence status

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

Oracle

Description (Required):

Set an alert via email in which we are notified if a data flow/sequence failed to run according to a schedule. More than that, it would be useful if we could set more email addresses - in case the DF owner is out of office, the cover person would receive the error DF alert, and notify the users of the outputs/dashboards.

Use Case and Business Need (Required):

I`m proposing this feature which I think it is essential - there are a lot of cases when data flows/sequences fail the scheduled run. The users might take wrong decisions based on the non-refreshed data.

Enhancement Request / Service Request:

Find more posts tagged with

Under Review

Data Modelling and Datasets

Analysis and Data Visualization

Data Preparation and Flows

Status: Under Review

Comments

Narayanan Ramachandran

We have the exact business Use case in that we would like to be notified by email if any of our Production dataflow fails for whatever reason. Thanks!

Benjamin Arnulf-Oracle

I voted for it. Really needed.

GabriellePrichard-Oracle

We are currently looking into this and it's on the longer term roadmap. I agree that it is an essential feature. I'm interested in what your current process is for detecting failed jobs?

Narayanan Ramachandran

We currently created a BIP data model and report based off BI_SERVER_ASYNC_JOB_STATUS table in the BIPLATFORM schema in OAS. Someone needs to look at the failed dataflows in the BIP report to take any corrective action. I am not even sure if this is a workable solution for OAC since these tables may not even be exposed in OAC.

Emilia Maxim-Oracle

https://community.oracle.com/products/oracleanalytics/discussion/comment/51132#Comment_51132

In each DF I have one column that keeps the current date. That date is posted in DV visualization, and represents latest update. But this is like a trick, when you have multiple datasets it`s hard to keep track on each of them.

Senthilkumar Subramaniam

This is really required feature to know the failure of dataflows as sometimes these are user specific and owned by them where users of DF are not aware of the failures when they are off causing some delays in daily reporting needs. Good to have this as early as possible.

Sharing something I read related to this topic. Please check the same and hope this helps.

https://blogs.oracle.com/analytics/post/oracle-analytics-data-flow-notification-system

Amin Georges

You can Push that to ADW Scheduler and from there build a mini Job to pick up the schedules updated table (Fail , Success) and send email. Its a straight forward workaround. I don't know why oracle giving us hard time to have this simple feature.

Bhaskar Konar

Much needed feature. It'll help the Admin Team immensely. Upvoted.

Jay Griffeth

I received an email back in September 2024 about setting up email notifications for data flow failures. The link I'm providing will take you to that article and a 4 minute YouTube video on how to configure this. I completed the steps in OCI and now receive alerts if/when an OAC Data Flow fails. Of course, you will need to have some responsibilities in your OCI tenancy to configure.

Here is the link:

https://community.oracle.com/products/oracleanalytics/discussion/22864/setting-up-email-notifications-for-data-flow-failures-in-oracle-analytics-cloud-oac

Hope that might help.

Muhammad Shoaib

Much needed. Is there any update on it from oracle?