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
Issue in SMPP connector Message Logging
sp_NewPost Add Reply sp_NewTopic Add Topic
July 22, 2016
10:35 am
Sarfaraz
Guest
Guests

Hi Henk,

Thank for your quick reply, we will look into that and try to figure out the issue.

Regards,
Sarfaraz

July 22, 2016
10:19 am
Henk Helmantel
Admin
Forum Posts: 552
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

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

July 21, 2016
5:09 pm
Sarfaraz
Guest
Guests

Hi,

Both the fields are nvarchar(max).

Thanks

July 21, 2016
4:36 pm
Henk Helmantel
Admin
Forum Posts: 552
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

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

July 21, 2016
2:43 pm
Sarfaraz
Guest
Guests

Hello Henk,

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.

Thanks
Regards,
Sarfaraz.

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 494

Currently Online:
8 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 364

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 532

Posts: 1845

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 552