[cisco-voip] DMA 7.1(3) error [-691 Missing key in referenced table for referential constraint

[Ryan Ratliff]

Ldap information is not kept in SQL anywhere.  The DMA errors log file  
should be all you need.  Start at the top and work your way down.

-Ryan

On Oct 22, 2009, at 4:58 PM, Jason Aarons (US) wrote:

Which table would I look at in SQL Enterprise Manager for those pkids?

From: Ryan Ratliff [mailto:rratliff at cisco.com]
Sent: Thursday, October 22, 2009 4:31 PM
To: Jason Aarons (US)
Cc: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] DMA 7.1(3) error [-691 Missing key in  
referenced table for referential constraint

Either the user or group is missing.  I'd recommend searching for both  
of those pkids and seeing which one fails first.

There should be either an 'insert into enduser' or 'insert into  
dirgroup' failure that references one of the fkenduser or fkdirgroup  
entries in that error.

Users in ldap without last names are notorious for not being migrated.

-Ryan

On Oct 22, 2009, at 3:25 PM, Jason Aarons (US) wrote:


Should I use SQL Enterprise Manager to track this down…I have about 90  
of these all similar -691 messages in DMA Errors.

***> DATA PROCESSING TESTS REVEALED AN ISSUE WHICH GENERATED THE  
FOLLOWING EVENT:
                 The error number is:  [-691]
                 The error message is:  [-691        Missing key in  
referenced table for referential constraint
]
                 The following additional event information is  
available:
                                 This record was not processed because  
another record it needs,
                                 (see reference name listed below), is  
missing.  This likely may be due to a previous error
                                 already reported in the log above, or  
the result of Directory Services Export issues
                                 reported separately, or due to  
missing Product, Locale, or other add-on definition CSV
                                 files that should exist on the source  
system but do not.
                                 SUGGESTED ACTION:  Resolve all prior  
reported issues.  If none, look at the Suspected Field,
                                 if listed, for an indication of what  
data reference could not be resolved.  Some hints:
                                  - if ...DirGroup related, check for  
a Directory Export failure
                                  - if ...Locale related, check for a  
missing Locale Plug-In
                                 Re-execute DMA when all other issues  
are addressed.
                 Suspected Field/Item Is  
[DMABack_Admin.fk_enduserdirgroupmap_fkenduser]
                 TABLE NAME IS [enduserdirgroupmap ]
                 fkdirgroup                'ccf0a1be-17d7-4337-9704- 
b54b96471a3a'
                 fkenduser                  
'1747ce27-3540-4739-8439-30717ebe41ee'
                 pkid                      '35202028-6b44-4004- 
b865-4bbab0bfc627'



Disclaimer: This e-mail communication and any attachments may contain  
confidential and privileged information and is for use by the  
designated addressee(s) named above only. If you are not the intended  
addressee, you are hereby notified that you have received this  
communication in error and that any use or reproduction of this email  
or its contents is strictly prohibited and may be unlawful. If you  
have received this communication in error, please notify us  
immediately by replying to this message and deleting it from your  
computer. Thank you.

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip



Disclaimer: This e-mail communication and any attachments may contain  
confidential and privileged information and is for use by the  
designated addressee(s) named above only. If you are not the intended  
addressee, you are hereby notified that you have received this  
communication in error and that any use or reproduction of this email  
or its contents is strictly prohibited and may be unlawful. If you  
have received this communication in error, please notify us  
immediately by replying to this message and deleting it from your  
computer. Thank you.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20091022/c0e807a2/attachment.html>