Support forum

Hello MyNguyen,

This error is a warning that the SQL Connector could not remove/update all the imported messages from the MessageOut table of your database. The most likely reason for this error is that one or more of the messages are locked for removal/update or that another another process already has removed the imported record(s).

When this happens, The SQL Connector will instruct the SQL database to roll-back the transaction and will ignore the messages that are already imported.

This issue can happen when multiple processes use the same database table. This can be for instance two different SQL Connectors or another program that you use. It depends on the locking mechanism of the database if using multiple simultaneous SQL queries will cause problems or not.

The best way to prevent this error is to make sure that only one SQL Connector uses the same database table and that the program that adds the messages to the database does not perform any updates on the MessageOut database table but only inserts, preferably in a single transaction.

Regards, Henk