I have a requirement to send notification if the record counts in target table is different from the source table, after the load is completed. I am accomplishing this using a server routine. I am returning 0 if counts match and -1 if counts do not match. In the routine activity in sequence job, I am using trigger as return value = -1 to call the notification activity. I noticed that whenever the returned value is -1, sequencer gets aborted.
When I disabled "Automatically handle activities that fail", I do not see this behavior. Is this the right approach to solve the issue or is this approach could possibly cause issues with other actvity execution in the sequencer? Appreciate your help!
Routine activity failure
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 153
- Joined: Thu May 11, 2006 1:52 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The other way to disable a failure - and any non-zero return from a Routine activity counts as a failure - from invoking the Exception Handler is to have an explicit Failure trigger from the Routine activity.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 27
- Joined: Mon Jul 09, 2012 6:51 am
- Location: Chennai
Re: Routine activity failure
Instead of returning the value as -1, try getting as a different value. Like If Count matches, it should return EQUAL. Else NOTEQUAL. Try this
Regards,
Aravind V A
Aravind V A