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

[Sergey Korobeynikov (JIRA)]

Sergey Korobeynikov created ASTERISK-29162:
----------------------------------------------

             Summary: 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


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)