Refresh dataset notification

Hello dear community,

my use case is:

we refresh more that 200 dataset ( from SAP source) in the same refresh workflow.

For reasons that we don't know some of these dataset are not being refresh sometime.

How can I track the list of dataset the should be refresh but are not ?

The issue is that the refresh workflow is not in failed state

Thank you in advance

Best regards


Best Answer

  • Henry SimmsHenry Simms Administrator
    edited September 7 Answer ✓

    To solve this you should be able to use the Stop execution when refresh failed option on the Source steps in your workflow (available from Aperture 2.8.4 onwards). This has the effect of causing the workflow to fail if auto-refresh on the source from the External System fails for any reason.

    With the setting enabled, my job execution will fail when the External System cannot be reached:

    Without the setting enabled (the default), the job will complete with a warning in the execution details:

    You can also add an Automation to notify / alert (or carry out some other action) when any of these failures or warnings occur, for example:

    Which will give the send the following notification:

    Note that the "Send notification" action and notifications inbox in my screenshot above is new in version 2.12, but in prior versions you can still send emails or trigger workflows / schedules


  • we have had similar cases - workflow is in completed state, but no refresh and/or the dataset is empty. If I remember right the error message (when you go to "Show Job") tells you that there has been JDBC error, so something has happened in connection. There should be "failed" state on these cases - not "completed"



Sign In or Register to comment.