Subject: Re: New Message from Martin Sloan in Administration XML (AXL) - Administrat Replied by: David Staudt on 27-09-2012 03:29:47 PM 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... This document was generated from CDN thread
Created by: Martin Sloan on 27-09-2012 10:39:08 AM 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
Subject: RE: SQL Update message returns '4052' Replied by: Martin Sloan on 27-09-2012 05:59:42 PM 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!
Subject: RE: SQL Update message returns '4052' Replied by: Martin Sloan on 09-10-2012 07:06:25 AM 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
Subject: Automatic reply: New Message from Martin Sloan in Administration XML (AXL) Replied by: Matt Bolton on 09-10-2012 07:12:12 AM 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
Subject: Respuesta de Estoy ausente: New Message from Martin Sloan in Administration Replied by: Victor Manuel Garcia Ternero on 09-10-2012 07:13:15 AM 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,
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:
