[asterisk-bugs] [Asterisk 0011905]: Recording unavailable voicemail message returns error on MSSQL when busy and name does not

[noreply at bugs.digium.com]

The following issue requires your FEEDBACK. 
====================================================================== 
http://bugs.digium.com/view.php?id=11905 
====================================================================== 
Reported By:                blitzrage
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   11905
Category:                   Applications/app_voicemail
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     feedback
Asterisk Version:           1.4.17 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Disclaimer on File?:        N/A 
Request Review:              
====================================================================== 
Date Submitted:             02-01-2008 15:03 CST
Last Modified:              02-01-2008 15:11 CST
====================================================================== 
Summary:                    Recording unavailable voicemail message returns
error on MSSQL when busy and name does not
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[14992]: 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[14992]: 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[14992]: app_voicemail.c:1397 store_file: SQL
Execute error!
[INSERT INTO voicemessages
(dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext)
VALUES (?,?,?,?,?,?,?,?,?,?)]

====================================================================== 

---------------------------------------------------------------------- 
 putnopvut - 02-01-08 15:11  
---------------------------------------------------------------------- 
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. 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
02-01-08 15:11  putnopvut      Note Added: 0081592                          
02-01-08 15:11  putnopvut      Status                   new => feedback     
======================================================================