VERIFIED SOLUTION i
X

Resolve Spectrum Process flow email notifications not being sent

Issue

A process flow  fails on the Execute SQL step, shows under history it has failed yet it did not send a failure email.

The email is sent only if the execution is cancelled from history.

Cause

The notification doesn't occur until the flow is finished.

It may be that the process is hung on the Execute SQL step and Spectrum is waiting for it to return. Then it will send the notification.

The fact that cancelling the flow does send the notification indicates that the error that is happening is not actually stopping the flow.

Resolution

UPDATED: October 24, 2017


Look at the activity in question to make sure the exception/error is handled correctly so the flow can finish.

There is also a configuration in the Execute SQL activity where you decide if an exception terminates the process flow. this should be checked.

Environment Details

Product Feature: Enterprise Designer, spectrum v10.1 , v11.1

Operating System: Windows Server 2012

Database: SQL server 2012

 

Downloads

  • No Downloads