Cisco Unified Application Environment Developer Forums

« Back to Developers

UpdatePhone701 fails with "numPlanId was not found" message

Combination View Flat View Tree View
Threads [ Previous | Next ]
Hi,
 
I have a script in which I am attempting to add a line to a phone.  Using the AddLineItem701, I set DirectoryNumberId to the extension that I want to create, say 2000.  Then I pass the lines output to my UpdatePhone701 control, but I get the following error.
 
 
2010:08:03::18:17:29(42): Warning: TestScript-2 Soap Fault.
<axl:Error xmlns:axl="http://www.cisco.com/AXL/API/7.0"><axl:code>5007</axl:code><axl:message>Item not valid: The specified numPlanId was not found</axl:message><request>updatePhone</request></axl:Error>
 
Can somebody explain the correct procedure to me?  Does the line have to exist in CUCM before I can pass it to AddLineItem?
 
CUCM version - 7.1.3, CUAE version - 2.5.1.
 
Thanks very much.
 
Bill

Hi Bill,
 
Looks like you are missing some action parameter or entering a wrong data in the action parameter.
 
You can get the details of which from the AXL logs.
 
You can collect the AXL Logs from RTMT. Download RTMT from the CUCM and install in your system.
 
1. Login to RTMT using the CUCM credentials.
2. Go to Trace and Log Central -> Collect Files.
3. Select the Cisco AXL Web services from the list.
4. Select the time duration relative range and Zip the files. The file will get downloaded to the specified location.
 
Before doing all this set the Trace configuration settings for AXL web services to Debug.
 
Do let us know what error you get in the logs of AXL.
 
Thanks,
Abhishek
 
Hi,
 
I have a script in which I am attempting to add a line to a phone.  Using the AddLineItem701, I set DirectoryNumberId to the extension that I want to create, say 2000.  Then I pass the lines output to my UpdatePhone701 control, but I get the following error.
 
 
2010:08:03::18:17:29(42): Warning: TestScript-2 Soap Fault.
<axl:Error xmlns:axl="http://www.cisco.com/AXL/API/7.0"><axl:code>5007</axl:code><axl:message>Item not valid: The specified numPlanId was not found</axl:message><request>updatePhone</request></axl:Error>
 
Can somebody explain the correct procedure to me?  Does the line have to exist in CUCM before I can pass it to AddLineItem?
 
CUCM version - 7.1.3, CUAE version - 2.5.1.
 
Thanks very much.
 
Bill

Hi Bill,
 
Yes, you first must create the line in CUCM before you attempt to add it to a device.
 
Craig


Hi,
 
I have a script in which I am attempting to add a line to a phone.  Using the AddLineItem701, I set DirectoryNumberId to the extension that I want to create, say 2000.  Then I pass the lines output to my UpdatePhone701 control, but I get the following error.
 
 
2010:08:03::18:17:29(42): Warning: TestScript-2 Soap Fault.
<axl:Error xmlns:axl="http://www.cisco.com/AXL/API/7.0"><axl:code>5007</axl:code><axl:message>Item not valid: The specified numPlanId was not found</axl:message><request>updatePhone</request></axl:Error>
 
Can somebody explain the correct procedure to me?  Does the line have to exist in CUCM before I can pass it to AddLineItem?
 
CUCM version - 7.1.3, CUAE version - 2.5.1.
 
Thanks very much.
 
Bill

Thanks, Abhishek & Craig for your replies.
 
I created a directory number of 2000 in CUCM and ran my CUAE script again, but still got an error.  Log snippets from CUAE/CUCM are included.
 
From CUAE:
 
2010:08:05::14:18:19(26): Warning: TestScript-2 Soap Fault.
<axl:Error xmlns:axl="[url=http://www.cisco.com/AXL/API/7.0"><axl:code>-391</axl:code><axl:message>Cannot]http://www.cisco.com/AXL/API/7.0"><axl:code>-391</axl:code><axl:message>Cannot insert a null into column (devicenumplanmap.fknumplan).</axl:message><request>updatePhone</request></axl:Error>
From CUCM:
 
2010-08-05 08:58:16,858 DEBUG [http-8443-5] axl.Handler - insert into DeviceNumPlanMap ( fkDevice,pkid ) values ( '78db1103-545c-4aca-a334-8c6a20b6d46c','e110be1c-07f2-18f9-5802-4bac0e8a7cd7' )
2010-08-05 08:58:16,951 ERROR [http-8443-5] axl.Handler - com.cisco.ccm.axl.PhoneHandler@1117dbf
java.sql.SQLException: Cannot insert a null into column (devicenumplanmap.fknumplan).
 at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3171)
 at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3484)
 
Complete logs are also attached.
 
Thanks,
 
Bill
 

Hi Bill,
 
Yes, you first must create the line in CUCM before you attempt to add it to a device.
 
Craig


Hi,
 
I have a script in which I am attempting to add a line to a phone.  Using the AddLineItem701, I set DirectoryNumberId to the extension that I want to create, say 2000.  Then I pass the lines output to my UpdatePhone701 control, but I get the following error.
 
 
2010:08:03::18:17:29(42): Warning: TestScript-2 Soap Fault.
<axl:Error xmlns:axl="http://www.cisco.com/AXL/API/7.0"><axl:code>5007</axl:code><axl:message>Item not valid: The specified numPlanId was not found</axl:message><request>updatePhone</request></axl:Error>
 
Can somebody explain the correct procedure to me?  Does the line have to exist in CUCM before I can pass it to AddLineItem?
 
CUCM version - 7.1.3, CUAE version - 2.5.1.
 
Thanks very much.
 
Bill
Attachments:

Huh. Bill, which version of CUCM are you running exactly? I wonder if the AXL changed. CUCM is trying to run "insert into DeviceNumPlanMap ( fkDevice,pkid ) values (
'78db1103-545c-4aca-a334-8c6a20b6d46c','e110be1c-07f2-18f9-5802-4bac0e8a7cd7'
)" but it looks like there is a clause on devicenumplanmap that prevents fknumplan from being null.
 
I would suggest taking a look at the AXL documentation and database schema as well.
 
Craig
 
Thanks, Abhishek & Craig for your replies.
 
I created a directory number of 2000 in CUCM and ran my CUAE script again, but still got an error.  Log snippets from CUAE/CUCM are included.
 
From CUAE:
 
2010:08:05::14:18:19(26): Warning: TestScript-2 Soap Fault.
<axl:Error xmlns:axl="[url=http://www.cisco.com/AXL/API/7.0"><axl:code>-391</axl:code><axl:message>Cannot]http://www.cisco.com/AXL/API/7.0"><axl:code>-391</axl:code><axl:message>Cannot insert a null into column (devicenumplanmap.fknumplan).</axl:message><request>updatePhone</request></axl:Error>
From CUCM:
 
2010-08-05 08:58:16,858 DEBUG [http-8443-5] axl.Handler - insert into DeviceNumPlanMap ( fkDevice,pkid ) values ( '78db1103-545c-4aca-a334-8c6a20b6d46c','e110be1c-07f2-18f9-5802-4bac0e8a7cd7' )
2010-08-05 08:58:16,951 ERROR [http-8443-5] axl.Handler - com.cisco.ccm.axl.PhoneHandler@1117dbf
java.sql.SQLException: Cannot insert a null into column (devicenumplanmap.fknumplan).
 at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3171)
 at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3484)
 
Complete logs are also attached.
 
Thanks,
 
Bill
 

Hi Bill,
 
Yes, you first must create the line in CUCM before you attempt to add it to a device.
 
Craig


Hi,
 
I have a script in which I am attempting to add a line to a phone.  Using the AddLineItem701, I set DirectoryNumberId to the extension that I want to create, say 2000.  Then I pass the lines output to my UpdatePhone701 control, but I get the following error.
 
 
2010:08:03::18:17:29(42): Warning: TestScript-2 Soap Fault.
<axl:Error xmlns:axl="http://www.cisco.com/AXL/API/7.0"><axl:code>5007</axl:code><axl:message>Item not valid: The specified numPlanId was not found</axl:message><request>updatePhone</request></axl:Error>
 
Can somebody explain the correct procedure to me?  Does the line have to exist in CUCM before I can pass it to AddLineItem?
 
CUCM version - 7.1.3, CUAE version - 2.5.1.
 
Thanks very much.
 
Bill