Source > Transaction > OnFailure setting

Use the OnFailure setting with adapter sources to select the rollback or commit behavior if the map does not successfully complete. The default value is Rollback.

Value
Description
Rollback
If the map does not complete successfully, sources retrieved through the messaging adapter are not deleted.
Commit
The adapter behaves as if the map was successful and the action specified by the OnSuccess setting is taken.

For example, if the Source > Transaction > OnSuccess setting is Delete and the Source > Transaction > OnFailure setting is Rollback and the map succeeds, the messages processed on the input queue are deleted. If the map fails, the messages are rolled back and left on the input queue.

However, if the Source > Transaction > OnSuccess setting is Delete and Source > Transaction > OnFailure setting is Commit, there is no IBM® MQ transaction syncpoint control activation. The message remains deleted, regardless of whether the map is completed. The point is that if the Source > Transaction > OnFailure setting is not Rollback, a message can be deleted even if a map fails.