Support forum
Hello Deewan,
This error message is an indication that the SQL Connector could not remove or update all the records that it read from the MessageOut table. This might have resulted in not sending some of the messages or in duplicate sending of some of the messages so to prevent this the SQL Connector rolls back the database transaction and does not send the messages.
The cause of this problem usually is that another process is changing the database table while Diafaan SMS Server tries to read the messages from the database. This should not be a problem with a multi-user database but it can be a problem with a single-user database without good record locking facilities. Usually the solution is to use a good multi-user database like Microsoft SQL Server (Express) or MySQL or to make sure that you lock the entire database when you access it from another program.
Regards, Henk
12:25 pm
i get this error when try to add sql server connector
EventTime Event Source
9/26/2018 1:15:23 PM The number of removed/updated records from the MessageOut table is not the same as the number of selected records, database transaction rolled back SQL Connector
please any idea to fix it
Most Users Ever Online: 529
Currently Online:
9 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Member Stats:
Guest Posters: 679
Members: 0
Moderators: 0
Admins: 1
Forum Stats:
Groups: 2
Forums: 3
Topics: 1154
Posts: 3941
Newest Members:
, Henk HelmantelAdministrators: Henk Helmantel: 1508