cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
465
Views
5
Helpful
1
Replies
Highlighted
Enthusiast

CUCM 11.5 "run sql" CLI command results in "No suitable driver found"

I am a big fan of troubleshooting calls using the CDR database, such as:

run sql car select callingpartynumber Calling, originalCalledPartyNumber origCalled, finalcalledpartynumber finalCalled, datetimestamporigination origination, datetimestampconnect connect, dateTimestampDisconnect disconnect, duration, origCause_value origCause, destCause_value destCause from tbl_billing_data

 

This works on a CUCM 11.5.1.12900-21 , but two systems running later code (11.5.1.13902-2, 11.5.1.14900-11)  just pop an error:

No suitable driver found for NO_JDBCURL_PROVIDEDuser=[..]

 

Is anyone else seeing this?

Thanks

/David

 

1 REPLY 1
Beginner

Re: CUCM 11.5 "run sql" CLI command results in "No suitable driver found"

Hello d.haeni,

You might need to use run sql car select + column + from car:tbl_billing_data where + column + (like,in,between,etc).

 

Example:

run sql car select call_type,callingpartynumber, originalcalledpartynumber, datetimestamporigination from car:tbl_billing_data where callingpartynumber in ("7140","5750")

 

This will provide the  calls where the calling party number was 7140 and 5750 for example.

 

Result:

call_type callingpartynumber originalcalledpartynumber datetimestamporigination
========= ================== ========================= ========================
S         5750               1208743XXXX               2018-02-05 15:23:10      
S         5750               1209401XXXX              2018-02-05 11:47:56 

 

You can also use a Date Range by adding the "and" and "Between" statement as the example below:

 

run sql car select call_type,callingpartynumber, originalcalledpartynumber, datetimestamporigination from car:tbl_billing_data where callingpartynumber in ("7140","5750") and  datetimestamporigination between "2018-03-01 00:00:00" and "2018-03-29 23:00:00"

 

I hope this helps!!

 

Thanks,

Gerson Fabian Morales Marin

 

 

CreatePlease to create content
Content for Community-Ad
July's Community Spotlight Awards