[AsteriskBrasil] Erro ao executar query em PostgreSQL odbc voicemessage

[Moisés Paes Sena]

O LOG de execução é este:

VoiceMail("SIP/250-00000002", "250 em default") in new stack
    -- <SIP/250-00000002> Playing 'vm-intro' (language 'pt_BR')
    -- <SIP/250-00000002> Playing 'beep' (language 'pt_BR')
    -- Recording the message
    -- x=0, open writing:
/var/spool/asterisk/voicemail/default/250/tmp/xzTbqe format: wav49,
0x1a446c18
    -- User hung up
[Jun 21 08:57:35] WARNING[2760]: app_voicemail.c:2344 generic_prepare: SQL
Prepare failed![DELETE FROM voicemessages WHERE dir=? AND msgnum=?]
[Jun 21 08:57:35] WARNING[2760]: res_odbc.c:130
ast_odbc_prepare_and_execute: SQL Prepare failed.  Attempting a reconnect...
[Jun 21 08:57:35] NOTICE[2760]: res_odbc.c:537 odbc_obj_connect: Connecting
asterisk
[Jun 21 08:57:35] NOTICE[2760]: res_odbc.c:565 odbc_obj_connect: res_odbc:
Connected to asterisk [asterisk-connector]
[Jun 21 08:57:35] WARNING[2760]: app_voicemail.c:2344 generic_prepare: SQL
Prepare failed![DELETE FROM voicemessages WHERE dir=? AND msgnum=?]
[Jun 21 08:57:35] WARNING[2760]: res_odbc.c:130
ast_odbc_prepare_and_execute: SQL Prepare failed.  Attempting a reconnect...
[Jun 21 08:57:35] NOTICE[2760]: res_odbc.c:537 odbc_obj_connect: Connecting
asterisk
[Jun 21 08:57:35] NOTICE[2760]: res_odbc.c:565 odbc_obj_connect: res_odbc:
Connected to asterisk [asterisk-connector]
[Jun 21 08:57:35] WARNING[2760]: app_voicemail.c:2623 delete_file: SQL
Execute error!
[DELETE FROM voicemessages WHERE dir=? AND msgnum=?]

  == Parsing '/var/spool/asterisk/voicemail/default/250/INBOX/msg0000.txt':
Found
[Jun 21 08:57:35] WARNING[2760]: app_voicemail.c:2690 insert_cb: SQL Prepare
failed![INSERT INTO voicemessages
(dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext)
VALUES (?,?, ? , ?,?,?,?,?,?,?)]
[Jun 21 08:57:35] WARNING[2760]: res_odbc.c:130
ast_odbc_prepare_and_execute: SQL Prepare failed.  Attempting a reconnect...
[Jun 21 08:57:35] NOTICE[2760]: res_odbc.c:537 odbc_obj_connect: Connecting
asterisk
[Jun 21 08:57:35] NOTICE[2760]: res_odbc.c:565 odbc_obj_connect: res_odbc:
Connected to asterisk [asterisk-connector]
[Jun 21 08:57:35] WARNING[2760]: app_voicemail.c:2690 insert_cb: SQL Prepare
failed![INSERT INTO voicemessages
(dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext)
VALUES (?,?, ? , ?,?,?,?,?,?,?)]
[Jun 21 08:57:35] WARNING[2760]: res_odbc.c:130
ast_odbc_prepare_and_execute: SQL Prepare failed.  Attempting a reconnect...
[Jun 21 08:57:35] NOTICE[2760]: res_odbc.c:537 odbc_obj_connect: Connecting
asterisk
[Jun 21 08:57:35] NOTICE[2760]: res_odbc.c:565 odbc_obj_connect: res_odbc:
Connected to asterisk [asterisk-connector]
  == Parsing '/var/spool/asterisk/voicemail/default/250/INBOX/msg0000.txt':
Found
  == Parsing '/var/spool/asterisk/voicemail/default/250/INBOX/msg0000.txt':
Found
  == Spawn extension (interno, 1, 1) exited non-zero on 'SIP/250-00000002'

-- 
Moisés P. Sena <moises em oriontec.com.br>
(Desenvolvedor WEB)
Oriontec Automação Comercial
http://www.oriontec.com.br
-------------- Próxima Parte ----------
Um anexo em HTML foi limpo...
URL: http://listas.asteriskbrasil.org/pipermail/asteriskbrasil/attachments/20100621/504d21c7/attachment.htm