[cisco-voip] DMA warnings

[Wes Sisk]

-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
>
>
>