[asterisk-bugs] [JIRA] (ASTERISK-29162) dateformat ignored for CEL ODBC connection

[Joshua C. Colp (JIRA)]

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

Joshua C. Colp updated ASTERISK-29162:
--------------------------------------

    Severity: Minor  (was: Major)

> dateformat ignored for CEL ODBC connection
> ------------------------------------------
>
>                 Key: ASTERISK-29162
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-29162
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: CEL/cel_odbc
>    Affects Versions: 18.0.1
>         Environment: CentOS 7
>            Reporter: Sergey Korobeynikov
>            Severity: Minor
>
> Trying to store CEL data in Microsoft SQL Server 2019. ODBC working with msodbcsql17 driver.
> cel.conf
> [general]
> enable=yes
> apps =all
> events=ALL
> dateformat = %F %T
> Save/Restart, Call:
> [Nov 13 18:09:45] WARNING[6426]: res_odbc.c:538 ast_odbc_print_errors: SQL Execute returned an error: 22007: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]H81:0 ?@5>1 at 07>20=8O 40BK 8;8 2 at 5<5=8 87 A8<2>;L=>9 AB@>:8.
> [Nov 13 18:09:45] WARNING[6426]: res_odbc.c:538 ast_odbc_print_errors: SQL Execute returned an error: 42000: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]5 C40;>AL 2K?>;=8BL ?>43>B>2:C 8=AB at C:F89.
> [Nov 13 18:09:45] WARNING[6426]: res_odbc.c:433 ast_odbc_prepare_and_execute: SQL Execute error -1!
> [Nov 13 18:09:45] WARNING[6426]: cel_odbc.c:788 odbc_log: Insert failed on 'sqlserver:cel'.  CEL failed: INSERT INTO cel (eventtype, eventtime, cid_name, cid_num, cid_ani, cid_rdnis, cid_dnid, exten, context, channame, appname, appdata, accountcode, peeraccount, uniqueid, linkedid, amaflags, peer, extra) VALUES ('LINKEDID_END', {ts '2020-11-13 18:09:45.011233'}, '9912091333', '9912091333', '9912091333', '', '9913123001', 'h', 'microfund-ivr-worktime', 'PJSIP/line9913123001-00000001', '', '', '', '', '1605265785.7', '1605265785.7', '3', '', '')
> Microsoft SQL Server does not recognize data {ts '2020-11-13 18:09:45.011233'} for eventtime field.
> This cannot be influenced by setting the dateformat = %F %T.



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