FDI Pipeline Failure and/or Delay notifications

Paresh M

Hi

It will be good to get a pipeline failure or a pipeline delay notification.

Currently system sends a completion notification but in the unlikely event of a pipeline failure there doesn't seem to be a notification.

Also the refresh estimate notification is sent at the same time of the completion and is counter productive, it will be very helpful to get a delay notification in the unlikely event of a delay in the factory pipelines so support process can be formulated accordingly.

Thanks

JimF-UK

Seems essential for a key live service like FDI to send information about any failures to allow support teams to identify the source of the problem quickly and deal with any impacts to the live service.

Johanna McGrath

This would be extremely helpful.

Mallikarjuna Kuppauru-Oracle

Good Idea,Voted for the same.

ym-Oracle

I believe you can create notification using agent/analysis - direct DB SQL using Oracle_Data_Warehouse_Connection_Pool connection pool.

select distinct WAREHOUSE_REFRESH_DATETIME from DW_WH_REFRESH_SUMMARY where PROCESS_NAME = 'WAREHOUSE_REFRESH_SCHEDULED' and WAREHOUSE_REFRESH_DATETIME > (SYSDATE-1)

AND condition Percentage of Successful Jobs = 100

Agent with condition report record count > 0

Create Agent to run the schedule agent to run report after expected FDI load completed time from Pipeline.

This will send email FDI load completed successfully.

You can create another one with Percentage of Failed Jobs > 0 This will send email when FDI load failed