cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
238
Views
0
Helpful
0
Comments
cdnadmin
Community Member
This document was generated from CDN thread

Created by: Haresh Khemani on 06-10-2009 01:39:00 AM
update devicenumplanmap
set display='WHS Dialysis Isolation Room 2'
from numplan where numplan.dnorpattern='33722'
and devicenumplanmap.fknumplan=numplan.pkid
 
CUCM ver is 6.1.2 and AXL code as follows
 
<?xml version="1.0" encoding="UTF-8"?>
<!--DTD generated by XMLSPY v5 rel. 4 U (http://www.xmlspy.com)-->
<!DOCTYPE data [
    <!ELEMENT data (sql+)>
    <!ELEMENT sql EMPTY>
    <!ATTLIST sql
    query CDATA #IMPLIED
    update CDATA #IMPLIED
>
]>
<data>
<sql update="update devicenumplanmap set display='WHS Dialysis Isolation Room 2' from numplan where numplan.dnorpattern='33722' and devicenumplanmap.fknumplan=numplan.pkid"/>
</data>
 
Getting the following error:
 
<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"><SOAP-ENV:Header/><SOAP-ENV:Body><SOAP-ENV:Fault><faultcode>SOAP-ENV:Client</faultcode><faultstring>A syntax error has occurred.</faultstring><detail><axl:Error xmlns:axl="http://www.cisco.com/AXL/API/1.0"><axl:code>-201</axl:code><axl:message>A syntax error has occurred.</axl:message><request>executeSQLUpdate</request></axl:Error></detail></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-ENV:Envelope>

Subject: RE: Update Line Display getting syntax error
Replied by: David Staudt on 06-10-2009 04:01:23 AM
Not sure how you are generating the XML (XML Spy?), but it doesn't look correct.  <executeSQLUpdate> should look something like:
 

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/6.1">
   <soapenv:Header/>
   <soapenv:Body>
      <ns:executeSQLUpdate sequence="1">
         <sql>update devicenumplanmap set display='WHS Dialysis Isolation Room 2' from numplan where numplan.dnorpattern='33722' and devicenumplanmap.fknumplan=numplan.pkid</sql>
      </ns:executeSQLUpdate>
   </soapenv:Body>
</soapenv:Envelope>

 
I commonly use a tool called soapUI for generating/testing AXL: http://www.soapui.org/
Getting Started

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:

Quick Links