|Summary:||ASTERISK-11359: Recording unavailable voicemail message returns error on MSSQL when busy and name does not|
|Reporter:||Leif Madsen (lmadsen)||Labels:|
|Date Opened:||2008-02-01 15:03:35.000-0600||Date Closed:||2008-02-01 15:17:08.000-0600|
|Description:||I seem to be getting this error when I try to record and save the unavailable message for a mailbox when using ODBC voicemail storage on MSSQL. I don't get the error with the BUSY or NAME messages, which appear to work fine (and I see them inserted into the DB).|
The error is below:
[Feb 1 16:00:56] WARNING: res_odbc.c:149 ast_odbc_smart_execute: SQL Execute returned an error -1: 22001: [FreeTDS][SQL Server]String or binary data would be truncated. (62)
[Feb 1 16:00:56] WARNING: res_odbc.c:149 ast_odbc_smart_execute: SQL Execute returned an error -1: 01000: [FreeTDS][SQL Server]The statement has been terminated. (55)
[Feb 1 16:00:56] WARNING: app_voicemail.c:1397 store_file: SQL Execute error!
[INSERT INTO voicemessages (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext) VALUES (?,?,?,?,?,?,?,?,?,?)]
|Comments:||By: Mark Michelson (mmichelson) 2008-02-01 15:11:09.000-0600|
I could be wrong, but I think the problem might just be that your column for the name of the greeting is too small for the path for the unavailable greeting but is large enough to store the path for the name and busy greetings. See if increasing the size by maybe ten or so characters fixes the problem.
By: Leif Madsen (lmadsen) 2008-02-01 15:17:08.000-0600
That's exactly what it was Mark. Thanks!