Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

AXLSQL Update line display getting error

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>

233
Views
0
Helpful
0
Replies
CreatePlease login to create content