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

[Joshua Colp (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-26392?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Joshua Colp updated ASTERISK-26392:
-----------------------------------

    Assignee: Marcelo Terres
      Status: Waiting for Feedback  (was: Triage)

What is the schema of the table that cdr_odbc is interesting into? Is cdr_adaptive_odbc working and cdr_odbc not working, thus why you see an entry?

> 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
>            Assignee: Marcelo Terres
>         Attachments: cdr_adaptive_odbc.conf, cdr.conf, cdr_odbc.conf, odbc.ini, odbcinst.ini
>
>
> 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)