[asterisk-bugs] [Asterisk 0017883]: ast_odbc_direct_execute: SQL Exec Direct failed while storing CDR rto Oracle 11g

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=17883 
====================================================================== 
Reported By:                spanov
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   17883
Category:                   Resources/res_odbc
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     new
Asterisk Version:           1.6.2.11 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-08-18 12:42 CDT
Last Modified:              2010-08-18 15:34 CDT
====================================================================== 
Summary:                    ast_odbc_direct_execute: SQL Exec Direct failed
while storing CDR rto Oracle 11g
Description: 
It always show the following error when trying to store CDR ro Oracle

[Aug 18 21:37:44] WARNING[4604]: res_odbc.c:584 ast_odbc_direct_execute:
SQL Exec Direct failed.  At
tempting a reconnect...
[Aug 18 21:37:44] NOTICE[4604]: res_odbc.c:1428 odbc_obj_connect:
Connecting asterisk
[Aug 18 21:37:44] NOTICE[4604]: res_odbc.c:1456 odbc_obj_connect:
res_odbc: Connected to asterisk [a
sterisk-orca]
       > cdr_odbc: Error in ExecDirect: -1
[Aug 18 21:37:44] WARNING[4604]: res_odbc.c:584 ast_odbc_direct_execute:
SQL Exec Direct failed.  At
tempting a reconnect...
[Aug 18 21:37:44] NOTICE[4604]: res_odbc.c:1428 odbc_obj_connect:
Connecting asterisk
[Aug 18 21:37:44] NOTICE[4604]: res_odbc.c:1456 odbc_obj_connect:
res_odbc: Connected to asterisk [a
sterisk-orca]
[Aug 18 21:37:44] ERROR[4604]: cdr_odbc.c:147 odbc_log: CDR direct execute
failed

====================================================================== 

---------------------------------------------------------------------- 
 (0126120) tilghman (administrator) - 2010-08-18 15:34
 https://issues.asterisk.org/view.php?id=17883#c126120 
---------------------------------------------------------------------- 
Thank you for taking the time to report this bug and helping to make
Asterisk better. 

Unfortunately, we cannot work on this bug because your description did not
include enough information. 

You may find it helpful to read the Asterisk Issue Guidelines
http://www.asterisk.org/developers/bug-guidelines. 

We would be grateful if you would then provide a more complete description
of the problem.

At a minimum, we need:
1. the specific steps or actions you took that caused you to encounter the
problem,
2. the behavior you expected, and
3. the behavior you actually encountered (in as much detail as possible).

This likely includes output from the console with debug level logging and
configuration information such as the contents of all odbc-related files
(e.g. /etc/odbcinst.ini, /etc/odbc.ini, and /etc/asterisk/res_odbc.conf).

Thanks! 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-08-18 15:34 tilghman       Note Added: 0126120                          
======================================================================