<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Verdana; font-size: 10pt; color: #000000'>Users in LDAP without last names seems to be a big issue. Connection won't synchronize LDAP users without a last name.<br><br>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.<br><br>---<br>Lelio Fulgenzi, B.A.<br>Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1<br>(519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)<br>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^<br>"Bad grammar makes me [sic]" - Tshirt<br><br><br>----- Original Message -----<br>From: "Ryan Ratliff" <rratliff@cisco.com><br>To: "Jason Aarons (US)" <jason.aarons@us.didata.com><br>Cc: cisco-voip@puck.nether.net<br>Sent: Thursday, October 22, 2009 4:31:00 PM GMT -05:00 US/Canada Eastern<br>Subject: Re: [cisco-voip] DMA 7.1(3) error [-691 Missing key in referenced table for referential constraint<br><br>Either the user or group is missing. I'd recommend searching for both of those pkids and seeing which one fails first.<div><br></div><div>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.</div><div><br></div><div>Users in ldap without last names are notorious for not being migrated.</div><div><br><div>
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><div>-Ryan</div></span>
</div>
<br><div><div>On Oct 22, 2009, at 3:25 PM, Jason Aarons (US) wrote:</div><br class="Apple-interchange-newline"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><div lang="EN-US"><div class="Section1"><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;">Should I use SQL Enterprise Manager to track this down…I have about 90 of these all similar -691 messages in DMA Errors.</div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"> </div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;">***> DATA PROCESSING TESTS REVEALED AN ISSUE WHICH GENERATED THE FOLLOWING EVENT: </div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"> The error number is: [-691]</div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"> The error message is: [-691 Missing key in referenced table for referential constraint</div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;">]</div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"> The following additional event information is available: </div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"> This record was not processed because another record it needs,</div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"> (see reference name listed below), is missing. This likely may be due to a previous error</div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"> already reported in the log above, or the result of Directory Services Export issues</div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"> reported separately, or due to missing Product, Locale, or other add-on definition CSV</div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"> files that should exist on the source system but do not.</div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"> SUGGESTED ACTION: Resolve all prior reported issues. If none, look at the Suspected Field,</div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"> if listed, for an indication of what data reference could not be resolved. Some hints: </div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"> - if ...DirGroup related, check for a Directory Export failure</div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"> - if ...Locale related, check for a missing Locale Plug-In</div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"> Re-execute DMA when all other issues are addressed.</div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"> Suspected Field/Item Is [DMABack_Admin.fk_enduserdirgroupmap_fkenduser]</div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"> TABLE NAME IS [enduserdirgroupmap ]</div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"> fkdirgroup 'ccf0a1be-17d7-4337-9704-b54b96471a3a'</div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"> fkenduser '1747ce27-3540-4739-8439-30717ebe41ee'</div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"> pkid '35202028-6b44-4004-b865-4bbab0bfc627'</div><div style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"> </div></div><div><br class="webkit-block-placeholder"></div><hr size="1"><div><br class="webkit-block-placeholder"></div><p><strong>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.</strong></p>_______________________________________________<br>cisco-voip mailing list<br><a href="mailto:cisco-voip@puck.nether.net" style="color: blue; text-decoration: underline;" target="_blank">cisco-voip@puck.nether.net</a><br><a href="https://puck.nether.net/mailman/listinfo/cisco-voip" style="color: blue; text-decoration: underline;" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br></div></span></div><br></div><br>_______________________________________________
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
</div></body></html>