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

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!

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