Support forum

If the messages are sent using the Email Connector in Diafaan SMS Server, the 'UserInfo' field could also be the cause of the problem. The Email Connector stores a part of the email message in the 'UserInfo' field and the amount of text in this field can be relatively large.

Unfortunately, the Microsoft SQL Server database does not specify in the error message which database field causes the problem. If the 'MessageText', 'MessagePDU' and 'UserInfo' fields are all defined as nvarchar(max) then one of the other fields in the database triggers the error. You can have a look at the record in the send log of Diafaan SMS Server (right-click on the log item and select 'Export to file') to see if one of the fields exceeds the number of characters in the corresponding database fields of the Microsoft SQL Server database.

A radical solution could be to chance all nvarchar(#) fields in the 'MessageLog' database table to nvarchar(max). That makes the database a little less efficient but it should solve the problem.

Regards, Henk

Hello Sarfaraz,

This error is generated by the SQL database and it means that one of the database fields is too short to hold the data that Diafaan SMS Server wants to store in it.

Since this error is returned only when the message is longer than 160 characters, the database field that causes the problem is probably one of the fields of the 'MessageLog' database table that includes the message text. This can be either the 'MessageText' field or the 'MessagePDU' field, these two fields should be able to hold a variable amount of text data (data type TEXT for MySQL or nvarchar(max) for Microsoft SQL Server).

Regards, Henk