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

[Chris Ward (chrward)]

691 errors are almost always errors as a result of a previous error.
Basically, something failed to insert earlier in the DMA process and
this is something that probably references the insert that previously
failed.

 

Look for an earlier error or an error with a different error number. 

 

-Chris

 

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Jason Aarons
(US)
Sent: Thursday, October 22, 2009 3:25 PM
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] DMA 7.1(3) error [-691 Missing key in referenced
tablefor referential constraint

 

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. 

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