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

[Jason Aarons (US)]

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/827719ed/attachment.html>