[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 has been RESOLVED. 
====================================================================== 
http://bugs.digium.com/view.php?id=11905 
====================================================================== 
Reported By:                blitzrage
Assigned To:                blitzrage
====================================================================== 
Project:                    Asterisk
Issue ID:                   11905
Category:                   Applications/app_voicemail
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     resolved
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:              
Resolution:                 fixed
Fixed in Version:           
====================================================================== 
Date Submitted:             02-01-2008 15:03 CST
Last Modified:              02-01-2008 15:17 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 (?,?,?,?,?,?,?,?,?,?)]

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

---------------------------------------------------------------------- 
 blitzrage - 02-01-08 15:17  
---------------------------------------------------------------------- 
That's exactly what it was Mark. Thanks! 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
02-01-08 15:17  blitzrage      Status                   feedback => resolved
02-01-08 15:17  blitzrage      Resolution               open => fixed       
02-01-08 15:17  blitzrage      Assigned To               => blitzrage       
02-01-08 15:17  blitzrage      Note Added: 0081593                          
======================================================================