Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

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

Receive Flash SMS to SQL Server Table
sp_NewPost Add Reply sp_NewTopic Add Topic
January 22, 2015
10:46 am


Found the faulting code.
It was a SQL Function inside the Trigger.
Working fine now, but I will consider recode and move the Trigger function to a Scripting Connector instead.

Thank you

Regards Filip

January 22, 2015
8:57 am

Hi Henk
As always - you are right :o)

22-01-2015 08:35:10 String or binary data would be truncated. SQL Connector

I have a Trigger on the MessageIn table. I think I have a datatype size error inside the trigger which stops the Insert. When I disable the trigger everything is fine.

I know it: Triggers can be both a friend or foe :o)

Regards, Filip

January 21, 2015
9:00 pm
Henk Helmantel
Forum Posts: 1502
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Filip,

There is no reason why flash messages should not be stored in the 'MessageIn' table of the SQL database. Flash messages are normal SMS messages in Diafaan SMS Server, they just have a different message type. On some GSM modems, flash messages are handled differently from other messages and sometimes cannot be read out properly form the SIM card but that does not seem to be the case here.

Do you see any error messages in the event log of the SQL Connector or of the GSM Modem Gateway that receives the flash message that could be related to the problem?

Regards, Henk

January 21, 2015
3:32 pm


I have an issue with receiving Flash SMS to the MessageIn table for the SQL Connector. Ordinary Text SMS is recieved to the table without problems, but not Flash SMS. They only appear in the Receive Log. Is there a way to save all received SMS types to MessageIn or do I have an error i my setup?

Regards Filip Højbak, Denmark

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
3 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 677

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1149

Posts: 3928

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1502