[cisco-voip] DMA warnings

[Ahmed Elnagar]

>From a past experience for a CUCM that I have just upgraded don’t delete from sql or try to troubleshoot or all this staff...just go with Wes advice write down the device configuration settings and delete it and make sure that your DMA is with 0 errors 0 warnings...otherwise you may face strange problems in the upgrade.

 Best Regards;
  Ahmed Elnagar
  Senior Network PS Engineer
  Mob: +2019-0016211
  CCIE#24697 (Voice)
 


-----Original Message-----
From: cisco-voip-bounces at puck.nether.net [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Wes Sisk
Sent: Wednesday, July 14, 2010 5:51 PM
To: Ed Leatherman
Cc: Cisco VOIP
Subject: Re: [cisco-voip] DMA warnings

-746 is a 'user generated message' in this case, it should come from 
Cisco. Most of the time it is accompanied with descriptive text such as:
Row: 5510 SQL error: -746(424)
Warning message (Business Rule Violation): Softkey Template is not valid 
for this type of device.

Most ignore these warnings. 

If you want to dig into it I'd recommend using the fkdevice and 
fknumplan to identify the device/line in question. Are they important?  
Can they be deleted and recreated? That would fix any data constraint 
violation.

Most likely the 2 rows violate some constraint.  Constraints are 
documented in the data dictionary.  In your case (7.1):
http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/7_1_3/datadictionary_713.pdf

On casual glance I don't see the exception but it could come from the 
one of the data contstraints imposed on the combination of 
(devicenumplanmap+device) or ((devicenumplanmap+numplan).

Delete and recreate is most likely shortest path to resolution.

/Wes

On Wednesday, July 14, 2010 10:25:07 AM, Ed Leatherman 
<ealeatherman at gmail.com> wrote:
> Hello DMA gurus..
>
> Working on cleaning up a DMA export for an upgrade here in a few
> weeks.. going from 4.2 to 7.1.5. I've got everything cleaned up except
> for 2 warnings. I will likely proceed with the upgrade anyway, the dma
> file works as-is in the lab.. but wouldn't mind fixing them if its
> reasonable to do so. nothing is jumping out at me as an error though..
> any thoughts? The error msg isn't helpful.
>
> both look like this just the other one is a different device/numplan:
>
>    Row: 622 SQL error: -746(35317)
>    Error executing "update DeviceNumPlanMap set
> fkDevice='be79732c-0990-4bad-91a0-d5cee504fa80' where
> pkid='4fbfa66a-0daa-4e15-86b8-72629aa32ae2'": [Informix][Informix ODBC
> Driver][Informix]Unspecified System Error =  -746. sqlerrm(35317)
>       pkid                     	 4fbfa66a-0daa-4e15-86b8-72629aa32ae2	
> NOT MODIFIABLE
>       fkDevice                 	 be79732c-0990-4bad-91a0-d5cee504fa80
>       NumPlanIndex             	 1
>       Label                    	
>       fkNumPlan                	 21dd4ac6-78b6-46e5-a742-6cc7811acca7
>       Display                  	 Hall Conference Room Phone Science
>       tkRingSetting            	 0
>       CtiID                    	 622	 NOT MODIFIABLE
>       E164Mask                 	 3047886801
>       DialPlanWizardGenID      	
>       tkMWLPolicy              	 0
>       tkRingSetting_Consecutive	 0
>       MaxNumCalls              	 4
>       BusyTrigger              	 2
>       CallInfoDisplayMask      	 9
>       LabelASCII               	
>       DisplayASCII             	 Hall Conference Room Phone Sci
>       tkRingSetting_ActivePickupAlert	 0
>       tkRingSetting_IdlePickupAlert	 0
>       tkPartitionUsage         	 99	 NOT MODIFIABLE
>       SpeedDial                	
>       fkRecordingProfile       	
>       fkCallingSearchSpace_Monitoring	
>       tkStatus_AudibleMWI      	 2
>       LogMissedCalls           	 true
>
>
>   

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
Disclaimer: NOTICE The information contained in this message is confidential and is intended for the addressee(s) only. If you have received this message in error or there are any problems please notify the originator immediately. The unauthorized use, disclosure, copying or alteration of this message is strictly forbidden. Raya will not be liable for direct, special, indirect or consequential damages arising from alteration of the contents of this message by a third party or as a result of any malicious code or virus being passed on. Views expressed in this communication are not necessarily those of Raya.If you have received this message in error, please notify the sender immediately by email, facsimile or telephone and return and/or destroy the original message.