iNTERFACEWARE™ Inc.

Silently Rejecting a Message without Generating an Error

In Iguana versions 3.2.153 and above, changes were made to automatically log errors if key fields were NULL for inbound database channels. This means that the message will not be processed, since all key fields must have non-NULL values for data to be inserted or updated. The only exception to this rule is if all fields for a given row are NULL. Consequently, setting all fields for a row to NULL causes three things to occur:

• Message will be processed successfully; but
• No error will be generated since there is no data to insert or update; and
• A row is not added/updated.

	Leaving a key field blank when at least one other field contains a value will cause an error to be generated.