on 01-24-2014 01:27 PM
Sending a SQL query I get a fault back from Axl.
<soapenv:Body xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Fault>
<faultcode>SOAP-ENV:Client</faultcode>
<faultstring>
<![CDATA[ODBC Error: Error executing "select first 1000
FYI: There is more to the query.
So in my soap logging, I see the query is complete going out, but truncated in the response.
I'll reply to this with both for completeness, but they are rather large.
Anyone seen this error before or know the root cause?
The query seems to work fine on my UCM 7.0 lab setup, both from the CLI 'run sql ...' and via executeSQLQuery.
- Perhaps an unexpected white space of hidden unicode character somehow got into the string?
- Perhaps 1000 rows of this large join is overwhelming some component of AXL/DB? Possibly try with fewer rows?
If you still can't spot anything please provide the UCM version in use, set the AXL service trace logging to detailed/debug and post the logs here. You may need to open a CDN Developer Services case for professional troubleshooting.
The query seems to work fine on my UCM 7.0 lab setup, both from the CLI 'run sql ...' and via executeSQLQuery.
- Perhaps an unexpected white space of hidden unicode character somehow got into the string?
- Perhaps 1000 rows of this large join is overwhelming some component of AXL/DB? Possibly try with fewer rows?
If you still can't spot anything please provide the UCM version in use, set the AXL service trace logging to detailed/debug and post the logs here. You may need to open a CDN Developer Services case for professional troubleshooting.
While the title specifies 8, it is specifically CMBE 8.0.2.40000-1.
I was hoping some one here might have already seen it and I'd be able to get a canned diagnosis.
Thanks for the suggestions. Guess I'm off to run some experiments and read some logs.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: