« Back to Serviceability XML Questions

Error accessing CDR Tables

Combination View Flat View Tree View
Threads [ Previous | Next ]
Error accessing CDR Tables
Answer
9/17/09 6:18 PM
 
Hi all,

I am getting error when i tried to access the CDR table through executesqlquery soap api.
 
1
2$querymyva=$client->executeSQLQuery(array('sql'=>"select * from car:tbl_billing_data where duration > 100"));


I am getting the following error "No connect permission" and the error code is -387

But when i execute the query from CLI i am getting the proper Data.
Please help me on this.

thanks/Chandar
 
 
Flag

RE: Error accessing CDR Tables
Answer
9/17/09 9:06 PM as a reply to Chandar vr.
Interesting that this can be done via the CLI, but it is not intended for AXL to provide access to the CAR database tables; I imagine DB permissions do not permit the AXL process from making those requests.
 
In addition, it would be very easy, I would assume, to impact UCM performance and/or hit the AXL response-size throttle, as CDR data is by nature very bulky.
 
The supported/recommended mechanism to obtain CDR data is via the FTP-push mechanism configurable in the UCM.
Flag