This document was generated from CDN thread
Created by: Jason Rohm on 17-10-2011 11:21:38 AM
I am seeing the following behavior with my CUCM 8.5 cluster...
When calling the "getUser" procedure against one particular user, I receive the following error:
[17-Oct-2011 10:03:47] PHP Fatal error: Uncaught SoapFault exception: [soapenv:Client] A subquery has returned not exactly one row. in /var/www/html/axl/test/test.php:16
The actual line of PHP code is:
$response = $client->getUser(array("userid"=>"CLN0525"));
When manually looking up the user in CUCM, with a "userID begins with" filter, I return one and only one response.
Our enduser database is synced with AD using LDAP. I have rerun the sync manually and verified that only one user exists with this ID and no users exist with IDs that are sub or supersets of this ID.
I have tried all permutations of case with the same result.
This is the only user that I have identified that has this issue.
I am trying to determine if this is a bug or a database problem. I suspect a database problem but lack at firm enough understanding of the unlaying SQL environment to design a raw SQL query to verify this.
Can someone assist?
Subject: RE: Problem with getUser procedure
Replied by: Florian Kroessbacher on 17-10-2011 03:22:08 PM
Have u looked into CCM Traces for AXL what the axlRouter logs in the debug Messaages inside the logs
cheers Floh
Subject: Re: New Message from Jason Rohm in Administration XML (AXL) - Administratio
Replied by: Sascha Monteiro on 17-10-2011 03:33:17 PM
there is a known bug if you have primary extension and ipcc extension set for the users, do you have uccx?
Subject: RE: Problem with getUser procedure
Replied by: Jason Rohm on 18-10-2011 09:11:26 AM
Yes, we do have UCCX 8.5 SR1 and this is a UCCX agent. However, it doesn't seem to be doing it for all agents. Just this one and one other that I found since my original post.
Do you have the bug ID or any additional information handy?
Subject: Re: New Message from Jason Rohm in Administration XML (AXL) - Administratio
Replied by: Sascha Monteiro on 18-10-2011 04:00:17 PM
it happens when both primary extn and ipcc extn are set,
this is the bug: CSCts08729
Subject: RE: Problem with getUser procedure
Replied by: Jason Rohm on 18-10-2011 05:02:37 PM
Thanks. I will have to write some sort of work around. If I come up with anything useful, I'll post it back here.