cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
687
Views
0
Helpful
2
Replies

AXL error: empty telecastersubscribedservice.urllabel

istibekesi
Beginner
Beginner

Hi,

I'm sending the following <updatePhone> AXL request as usual, updating phone services:

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

   <SOAP-ENV:Body>

      <axl:updatePhone sequence="12" xmlns:axl="http://www.cisco.com/AXL/API/9.1">

         <name>SEP88755651BC56</name>

         <services>

            <service>

               <telecasterServiceName uuid="{80B3C4D0-DE22-6A7F-8A53-C09D82904E4F}"/>

               <name>EM</name>

               <url>http://192.168.5.18:8080/emapp/EMAppServlet?device=#DEVICENAME#&EMCC=#EMCC#</url>

               <urlButtonIndex>0</urlButtonIndex>

               <urlLabel/>

               <urlLabelAscii/>

               <serviceNameAscii>EM</serviceNameAscii>

               <phoneService>Standard IP Phone Service</phoneService>

               <phoneServiceCategory>XML Service</phoneServiceCategory>

               <priority>50</priority>

            </service>

         </services>

      </axl:updatePhone>

   </SOAP-ENV:Body>

</SOAP-ENV:Envelope>

But I get the following AXL error in response:

<axlmessage>Cannot insert a null into column (telecastersubscribedservice.urllabel).</axlmessage>

In the request, the service part is exactly the same as i get it from getPhone, the <urlLabel> is empty in the getPhoneResponse too.

I understood: if I remove the <urlLabel/> item, the update is successful.

However I'm a bit confused, since I'm pretty sure this was working for years now.

I did not find any changes related to this item in the AXL schema documentation.

Furthermore, also very strange: in the database neither telecastersubscribedservice.urllabel, nor telecastercubscribedservice.urllabelascii are nillable. Why is it problem for empty <urlLabel/>, but does not for <urlLabelAscii/> then?

Reproduced on version 9.1 and 10.5.

2 REPLIES 2

lior look
Contributor
Contributor

Hi Istvan,

First of all, try to send the body SOAP with imported values only.

See at the AXL scheme what do you can to remove at this moment.

http://developer.cisco.com/site/axl/documents/previous-versions/index.gsp

In addition, the urlLabel is a string value so try to replace there something like NULL or "".

thedd
Beginner
Beginner

Try it like this:

         <services>

            <service>

               <telecasterServiceName uuid="{80B3C4D0-DE22-6A7F-8A53-C09D82904E4F}"/>NAME</telecasterServiceName>

               <name>EM</name>

               <url>http://192.168.5.18:8080/emapp/EMAppServlet?device=#DEVICENAME#&EMCC=#EMCC#</url>

               <urlButtonIndex>0</urlButtonIndex>

               <urlLabel>EM</urlLabel> or <urlLabel>""</urlLabel>

               <urlLabelAscii/>

               <serviceNameAscii>EM</serviceNameAscii>

               <phoneService>Standard IP Phone Service</phoneService>

               <phoneServiceCategory>XML Service</phoneServiceCategory>

               <priority>50</priority>

            </service>

         </services>

      </axl:updatePhone>

   </SOAP-ENV:Body>

</SOAP-ENV:Envelope>

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: