Support forum

Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_TopicIcon
SQL connector error
sp_NewPost Add Reply sp_NewTopic Add Topic
January 13, 2022
9:52 pm
Henk Helmantel
Admin
Forum Posts: 1323
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

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

January 13, 2022
2:44 pm
MyNguyen
Guest
Guests

Hello support,
How to fix this error
The number of removed/updated records from the MessageOut table is not the same as the number of selected records, database transaction rolled back

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 494

Currently Online:
7 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 621

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1031

Posts: 3536

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1323