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
Email Connector Issue
sp_NewPost Add Reply sp_NewTopic Add Topic
March 5, 2016
3:00 pm
Sarfaraz
Guest
Guests

Hello Henk,

After increase the UserInfo field to (max) it worked fine.

Thanks.

March 1, 2016
2:51 pm
Henk Helmantel
Admin
Forum Posts: 553
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

The Email Connector stores an XML formatted text in the 'UserInfo' field with the name and email address of the sender and receiver of the email and the subject of the email message. If the 'UserInfo' field in the 'MessageLog' table of your database is an 'nvarchar(50)' field then this field is too short to store all the information.

The best definition for the 'UserInfo' field is 'nvarchar(max)', the same as for the 'MessageText' field.

Regards, Henk

March 1, 2016
2:29 pm
Sarfaraz
Guest
Guests

Hello Henk,

We have check the message content and userinfo field and both are having messagetext nvarchar(max) and userinfo is nvarchar(50). It is the email connector which is reading the email subject line and then sending it through the SMPP Gateway. Looks like the issue is something other than what you have suggested as this issue is only coming when the email connector is sending the messages.

The message content sent out by the email connector is FW: IR:126564 P2 Infosys - Toyota Queued : 95% disk used for DATA_BACKUP volume on Hana DB (>=80%), on [vst1shana]

which is not even 160 characters. Is that > character creating the issue while getting in to the table. Please check on it. Please let us know if you need any further details to replicate the error on your end.

Thanks

March 1, 2016
2:15 pm
Henk Helmantel
Admin
Forum Posts: 553
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Sarfaraz,

I can confirm the problem with the 'EnableHTTPCallbacks' option in the Email Connector settings. This bug will be fixed in the next version of Diafaan SMS Server. If you need a temporary fix for the problem, please let me know and I can send you a plugin for the Email Connector.

The easiest way to solve the second problem is to find out which database field in the 'MessageLog' database table is causing the error and increase the field size accordingly. The most likely candidates are the 'MessageText' database field or the 'UserInfo' database field.

The SQL Connector has two properties in the advanced settings that control how it handles database errors: 'MessageInRetryOnError' and 'MessageLogRetryOnError'. When these properties are set to 'False', the SQL Connector removes the offending record (batch) and skips to the next record (batch). If set to 'True', the SQL Connector will keep trying to store the records in the database.

Regards, Henk

March 1, 2016
1:01 pm
Sarfaraz
Guest
Guests

Hello Henk,

Today we have configure an email connector, if you need we will send you the configuration for the same. We have notice that Call back if made to false still remains as true and hits the call back URL.

Secondly we are getting the below error when we have kept the subject line to be sent as text message.

3/1/2016 5:09:13 PM (error) SQL Connector:
String or binary data would be truncated.
The statement has been terminated.

Subject line of the email was IR:126564 P2 Infosys - Toyota Queued : 95% disk used for DATA_BACKUP volume on Hana DB (>=80%), on [vst1shana]

Now the worst part is when such a case happen then Diafaan SMS Server stops logging the messages to message log table then we have to stop and start the service again and then it starts loging details in the message log table.

Please check on this and let us know.

Thanks.

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: 1847

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 553