[asterisk-bugs] [JIRA] (ASTERISK-26392) Asterisk reports error in CDR data insertion, but data is available in DB

[Marcelo Terres (JIRA)]

Marcelo Terres created ASTERISK-26392:
-----------------------------------------

             Summary: Asterisk reports error in CDR data insertion, but data is available in DB
                 Key: ASTERISK-26392
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-26392
             Project: Asterisk
          Issue Type: Bug
      Security Level: None
          Components: CDR/cdr_odbc
    Affects Versions: 14.0.0-rc1
         Environment: Ubuntu 14.04.5 LTS  - Linux rtc 4.5.5-x86_64-linode69 #3 SMP Fri May 20 15:25:13 EDT 2016 x86_64 x86_64 x86_64 GNU/Linux

            Reporter: Marcelo Terres


After I started to use Asterisk 14 rc1, I noticed something. I'm not sure if it starts in this version, but let me show you.

I'm using cdr_odbc and cdr_adaptive_odbc.

When a call is finished, I'm receiving the following messages:

[Sep 20 09:47:47] WARNING[24412]: cdr_odbc.c:160 execute_cb: cdr_odbc: Error in ExecDirect: -1, query is: INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield) VALUES ({ts '2016-09-20 09:47:44'},?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
[Sep 20 09:47:47] ERROR[24412]: cdr_odbc.c:189 odbc_log: CDR direct execute failed

But, data is being saved in my db:

             | 1000 | 1111          | ramais         | "Marcelo Terres" <1000>     | SIP/1000-00000010            |                              | Playback    | thanks_for_call                                                                 | 2016-09-20 09:47:44 | 2016-09-20 09:47:44 | 2016-09-20 09:47:47 |        3 |       3 | ANSWERED    | DOCUMENTATION |           | 1474375664.31  | 1474375664.31  |             |       19





--
This message was sent by Atlassian JIRA
(v6.2#6252)