Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

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

SQL server error
sp_NewPost Add Reply sp_NewTopic Add Topic
September 26, 2018
2:45 pm
Henk Helmantel
Forum Posts: 1502
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

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

September 26, 2018
12:25 pm
deewan alrasaile

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

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
4 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 678

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1149

Posts: 3929

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1502