Administration XML Developer Forums

« Back to Administration XML Questions

SQL Update message returns '4052'

Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
SQL Update message returns '4052'
Answer
9/27/12 3:39 PM
Hello,
I'm using a sql update statement to change the partition of some directory numbers in our CUCM 8.6.2 system and receive a return message of 4052 when running the statement and the partition is not updated.  Does anyone know what this message means?  Here's the satement:
 
run sql update numplan set fkroutepartition = (select pkid from routepartition where name = "NEW_PT") where fkroutepartition = (select pkid from routepartition where name = "OLD_PT")
 
I double checked to make sure the PT names are correct.
 
Thanks
Flag

Re: New Message from Martin Sloan in Administration XML (AXL) - Administrat
Answer
9/27/12 8:29 PM as a reply to Martin Sloan.
Can you provide the full AXL response and the AXL service logs?

The routepartition field in numplan has a number of constraints on its
value (see the data dictionary), which I suppose could apply.

The query itself is very generic, and does not test for null results
from its sub queries. My suspicion would be that some particular
constraint is cropping up that the code is not anticipating...
Flag

RE: SQL Update message returns '4052'
Answer
9/27/12 10:59 PM as a reply to David Staudt.
Thanks for the reply David.  I'll post the AXL response and logs when I get back into the office, hopefully tomorrow.  I do know there are DN's in the numplan table that the sub queries would apply to and checked them seperately to confirm.  I created this quick 'PT flip' program to help move DN's assigned to VG224 ports since you can't get to them through BAT (not that I've been able to find anyway).  It will only be run when we're ready to move a couple hundred DN's at a time.  The crazy thing is that I tested this thouroughly in the lab and it still works there with the same software version!
Flag

RE: SQL Update message returns '4052'
Answer
10/9/12 12:06 PM as a reply to David Staudt.
Hi David,
So it was actually an easy fix after I pulled the AXL traces to post here....  The update was creating a duplicate DN/PT combination and so it was failing.  I'm checking each number now instead of a bulk update to avoid this.  For testing, I had been executing the update from the CLI when I got focused on finding out what the 4052 message meant, I should have just gone back to the AXL traces since it provides a more detailed description along with the error code.
 
Thanks for the help.
 
Marty
Flag

Automatic reply: New Message from Martin Sloan in Administration XML (AXL)
Answer
10/9/12 12:12 PM as a reply to Martin Sloan.
I will be on holidays and have very limited access to email / phone from Oct 1 - Oct 8. I will respond to you upon my return but if you need immediate assistance, contact Udaya Padmanabhuni: Udaya.Padmanabhuni@Quest.com<mailto:Udaya.Padmanabhuni@Quest.com>

Regards,
Matt

Matt Bolton
Dell | Network Management, Quest Software
office +1 415 293 6514, mobile +1 45 519 4011

Quest Software is now a part of Dell
Flag

Respuesta de Estoy ausente: New Message from Martin Sloan in Administration
Answer
10/9/12 12:13 PM as a reply to Martin Sloan.
Gracias por tu correo.
Estaré fuera de la oficina hasta el día 22 de Octubre con acceso limitado al correo electrónico.
Para cualquier asunto urgente póngase en contacto con Ignacio Luengo (iluengo@wtelecom.es<mailto:mjdominguez@wtelecom.es>), o llame al teléfono de la oficina (+34 954 151 706).
Un saludo,
Flag