Thank for your quick reply, we will look into that and try to figure out the issue.
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.
Both the fields are nvarchar(max).
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).
We are facing one issue, we have a SMPP Connector and we have activated the option to log all the messages to the SQLConnector. Now when the message sent from the SMPP Connector is less then 160 characters it does log it to the SQLConnector, but when the message content is more than 160 characters it is throwing an error as below.
Diafaan SMS Server generated the following event log alerts:
7/21/2016 6:00:12 PM (error) SQL Connector:
String or binary data would be truncated.
The statement has been terminated.
Can you please look into it and advice us a solution for the same.
Most Users Ever Online: 494
Currently Browsing this Page:
Guest Posters: 374
Newest Members:, Henk Helmantel
Administrators: Henk Helmantel: 579