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.
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)
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?
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
Most Users Ever Online: 494
Currently Browsing this Page:
Guest Posters: 533
Newest Members:, Henk Helmantel
Administrators: Henk Helmantel: 1050