cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
974
Views
0
Helpful
1
Replies

CUCM AXL error adding IP Phone and DN - Cannot insert a null into column (devicenumplanmap.fknumplan)

Antonio Brandao
Level 1
Level 1

Hi

 

I´m trying to use AXL to add an IP Phone device  and line on CUCM server

So, I´m sending this soap/xml  message to the API :

 

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/8.5">
    <soapenv:Header/>
    <soapenv:Body>
        <ns:addPhone>
            <phone>
                <name>SEP00451D6BBDB9</name>
                <description>axl test</description>
                <product>Cisco 7942</product>
                <class>Phone</class>
                <protocol>SCCP</protocol>
                <devicePoolName>Default</devicePoolName>
                <lines>
                	<line>
                	        <index>1</index>
                		<label>Teste</label>
		                <dirn>
		                    <pattern>111111</pattern>
		                    <routePartitionName>DID_PT</routePartitionName>
		                </dirn>
                	</line>	
		</lines>                	
            </phone>
        </ns:addPhone>
    </soapenv:Body>
</soapenv:Envelope>

And getting the error message  as return Cannot insert a null into column (devicenumplanmap.fknumplan)

 

 
<?xml version='1.0' encoding='UTF-8'?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
    <soapenv:Body>
        <soapenv:Fault>
            <faultcode>soapenv:Client</faultcode>
            <faultstring>Cannot insert a null into column (devicenumplanmap.fknumplan).</faultstring>
            <detail>
                <axlError>
                    <axlcode>-391</axlcode>
                    <axlmessage>Cannot insert a null into column (devicenumplanmap.fknumplan).</axlmessage>
                    <request>addPhone</request>
                </axlError>
            </detail>
        </soapenv:Fault>
    </soapenv:Body>
</soapenv:Envelope>
 

 

Any ideas ??? 

1 Reply 1

thedd
Level 1
Level 1
I think the DN you try to use does not exist. Please verify.
If it is like this first add the line.