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

[Lelio Fulgenzi]

Users in LDAP without last names seems to be a big issue. Connection won't synchronize LDAP users without a last name. 

It took us forever to find that. OK. Not forever, but it was a drag comparing each LDAP field to see what the difference between two users was. 

--- 
Lelio Fulgenzi, B.A. 
Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1 
(519) 824-4120 x56354 (519) 767-1060 FAX (JNHN) 
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 
"Bad grammar makes me [sic]" - Tshirt 


----- Original Message ----- 
From: "Ryan Ratliff" <rratliff at cisco.com> 
To: "Jason Aarons (US)" <jason.aarons at us.didata.com> 
Cc: cisco-voip at puck.nether.net 
Sent: Thursday, October 22, 2009 4:31:00 PM GMT -05:00 US/Canada Eastern 
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 


_______________________________________________ cisco-voip mailing list cisco-voip at puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20091022/24bbbc90/attachment.html>