« Back to Administration XML Questions

RE: AXL Error Code 0, poor AXL Perfomance

Combination View Flat View Tree View
Threads [ Previous | Next ]
AXL Error Code 0
Answer
2/15/13 3:09 PM
Hello, i had lan axl error (see below), seams to be an internal error. The AXL interface did not work anymore. A reboot did the fix of that problem, my Question is: How can i prevent from that in the future ? Kind regards, Holger Simon   SOAP-ENV:ClientMax]http://schemas.xmlsoap.org/soap/envelope/">SOAP-ENV:ClientMax connections for dbaxlweb at jdbcurl exceed. Connection not allowed0Max]http://www.cisco.com/AXL/API/7.1">0Max connections for dbaxlweb at jdbcurl exceed. Connection not allowedexecuteSQLQuery
Flag

RE: AXL Error Code 0
Answer
2/15/13 4:15 PM as a reply to HOLGER SIMON.
Can you provide some more details?

- UCM version
- AXL request/response
- An idea of system performance at the time: lots of rapid/large AXL requests? 
For in-depth analysis of the issue, strongly suggest you open a support case with CDN Developer Support: http://developer.cisco.com/web/memberservices/support
Flag

RE: AXL Error Code 0
Answer
3/13/13 9:52 AM as a reply to David Staudt.
Hello David,
the CUCM Version is: 9.0.1.11017-1.
Meanwhile we have identified a suboptimal executesql, which takes 1 minute for execution, we send that request automated > 1000 times.
This error from the cucm seemed to be: that there are nor more free jdbc connections for the axl interface, because all of them are in used by the slow sql.
We could make a sql optimization, the execution takes now below 1 second, the result of that is currently pending.
Is that assumption right?
How is the jdbc pool limit for this cucm version ?
Kind regards,
Holger
Flag

RE: AXL Error Code 0, poor AXL Perfomance
Answer
3/20/13 10:29 AM as a reply to HOLGER SIMON.
Hello,
now I have that error again with the attached AXL update user request.
If I send more than 4 Request/second over one minute duration, than I wil get an error for each following AXL request.
From this situation on I cannot use the AXL interface anymore, until I restart either the "A Cisco DB" Service or the CUCM.
This violates the performance values, given in the XML Developers Guide(Table 2-15 AXL Query Limits) , I send only approximately 300 Requests/minute, while the Developers Guide stated about 1500 Requests per minute.   The AXL error we get now is:
 '<axlError>
  <axlcode>0</axlcode>
  <axlmessage>Max connections for dbaxlweb at jdbcurl exceed. Connection not allowed</axlmessage>
  <request>executeSQLQuery</request>
</axlError>'
The CUCM Version is: 9.0.1.11017-1. How can I handle this error? What ist the limit for that update User Request ? Kind regards, Holger
Attachments: UpdateUserPINRequest.xml (0.5k)
Flag