CUCM 8: Error code 64 ODBC Error

Version 1
    This document was generated from CDN thread

    Created by: douglas conklin on 10-09-2010 11:53:20 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?
     
     

    Subject: RE: CUCM 8: Error code 64 ODBC Error
    Replied by: douglas conklin on 10-09-2010 11:54:59 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?
     
     


    outgoing soap message with complete query:
     
    <soapenv:Body xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
     <axl:executeSQLQuery xmlns:axl="http://www.cisco.com/AXL/API/1.0">
      <sql xsi:type="xsd:string" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="[url=http://www.w3.org/2001/XMLSchema">select]http://www.w3.org/2001/XMLSchema">select first 1000 d.name as devicename,   d.description, np.dnorpattern as directorynumber,  rp.name as partition, dnpm.numplanindex as lineposition, eu.userid, dp.name as devicepool, css.name as css, d.userholdmohaudiosourceid as userholdaudiosource, d.networkholdmohaudiosourceid as networkholdaudiosource,  t.name as privacy, rrcss.name as reroutingcss, cptranscss.name as callingpartytransformcss, d.usedevicepoolcgpntransformcss as useddevicepoolcallingpartytransformcss, userloc.name as userlocale, d.ignorepi as ignorepresentationindicators, dnd.dndstatus, tdnd.name as dndoption  from device d left join enduser eu on d.fkenduser_mobility = eu.pkid left join location loc on d.fklocation = loc.pkid  left join callingsearchspace rrcss on d.fkcallingsearchspace_reroute = rrcss.pkid left join callingsearchspace cptranscss on d.fkcallingsearchspace_cgpntransform  = cptranscss.pkid left join callingsearchspace css on d.fkcallingsearchspace = css.pkid left join typeuserlocale userloc on d.tkuserlocale = userloc.enum left join devicenumplanmap dnpm on d.pkid = dnpm.fkdevice left join numplan np on dnpm.fknumplan = np.pkid left join routepartition rp on np.fkroutepartition = rp.pkid left join devicepool dp on d.fkdevicepool = dp.pkid left join deviceprivacydynamic dpd on d.pkid = dpd.fkdevice left join typestatus t on dpd.tkstatus_callinfoprivate = t.enum left join typedndoption tdnd on d.tkdndoption = tdnd.enum left join dnddynamic dnd on d.pkid = dnd.fkdevice where d.tkmodel = 134</sql>
     </axl:executeSQLQuery>
    </soapenv:Body>
     
    response fault with truncated query:
     
    <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 d.name as devicename,   d.description, np.dnorpattern as directorynumber,  rp.name as partition, dnpm.numplanindex as lineposition, eu.userid, dp.name as devicepool, css.name as css, d.userholdmohaudiosourceid as userholdaudiosource, d.networkholdmohaudiosourceid as networkholdaudiosource,  t.name as privacy, rrcss.name as reroutingcss, cptranscss.name as callingpartytransformcss, d.usedevicepoolcgpntransformcss as useddevicepoolcallingpartytransformcss, userloc.name as u]]></faultstring>
    <detail xsi:schemaLocation="http://www.cisco.com/AXL/API/1.0 http://HQ-CCM-01/CCMApi/AXL/V1/axlsoap.xsd" xmlns:axl="http://www.cisco.com/AXL/API/1.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <axl:error sequence="0">
    <code>64</code>
    <message>
    <![CDATA[ODBC Error: Error executing "select first 1000 d.name as devicename,   d.description, np.dnorpattern as directorynumber,  rp.name as partition, dnpm.numplanindex as lineposition, eu.userid, dp.name as devicepool, css.name as css, d.userholdmohaudiosourceid as userholdaudiosource, d.networkholdmohaudiosourceid as networkholdaudiosource,  t.name as privacy, rrcss.name as reroutingcss, cptranscss.name as callingpartytransformcss, d.usedevicepoolcgpntransformcss as useddevicepoolcallingpartytransformcss, userloc.name as u]]></message>
    <request>executeSQLQuery</request>
    </axl:error>
    </detail>
    </soapenv:Fault>
    </soapenv:Body>
     

    Subject: RE: CUCM 8: Error code 64 ODBC Error
    Replied by: David Staudt on 11-09-2010 03:51:21 AM
    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.

    Subject: RE: CUCM 8: Error code 64 ODBC Error
    Replied by: douglas conklin on 13-09-2010 05:07:54 PM
    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.
     
     
     
     
     

    Subject: RE: CUCM 8: Error code 64 ODBC Error
    Replied by: douglas conklin on 13-09-2010 10:54:38 PM


    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. 

     


    I hate these. This resolved itself. There were no server or service restarts of which I'm aware. In the course of experimenting, the query was re-pasted into the infrastucture from the original text source at least once. I never saw any odd characters in any of the various editors I used to look at the query. That doesn't mean they weren't there.
     
    No root cause, but there isn't any more investigation I can do since the issue has disappeared.