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

AXL error: empty telecastersubscribedservice.urllabel

istibekesi
Level 1
Level 1

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
Level 5
Level 5

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
Level 1
Level 1

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>