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

Jason Aarons (US) jason.aarons at us.didata.com
Thu Oct 22 15:25:07 EDT 2009


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/567a3702/attachment.html>


More information about the cisco-voip mailing list