<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
choking on this value in that row:
DMABack_Admin.fk_enduserdirgroupmap_fkenduser<br>
<br>
so the fkenduser does not appear to exist. fkenduser is <font
face="Arial" size="2">b3104b58-5f47-4a2d-bf98-cadeccebbf2d<br>
<br>
search for that pkid in the rest of the traces, see if it is inserted
anywhere. ideally there should be a user in the EndUser table in
infomix with pkid='</font><font face="Arial" size="2">b3104b58-5f47-4a2d-bf98-cadeccebbf2d'.
Unfortunately it's not very easy to see that other than searching in
this log.<br>
<br>
<br>
In the larger picture this statement is attempting to add a user to a
group. What directory integration are you using? It is possible the
user was deleted but somehow the userid is included as a member of this
group. This is the most likely scenario. to pursue:<br>
1. search on the fkgroup to find out what 'group' it is:</font><font
face="Arial" size="2">47b0de74-db3a-4be9-aa92-47a7921e0f26<br>
find where that is inserted in the dma log and it should tell you the
group name. then take your best guess at what the equivalent group
name would be on your existing windows system. review all of the usres
in that group on your existing system and verify all of the users still
exist in the directory.<br>
<br>
/Wes<br>
</font><br>
<br>
Daniel Argueta wrote:
<blockquote cite="mid:9CD7B04283FC4B798C3A0FD6146FC994@main" type="cite">
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<meta content="MSHTML 6.00.3790.4134" name="GENERATOR">
<div><font face="Arial" size="2">Nope.....darn thing failed
again....this is the only error message in the whole DMAErrors.log:</font></div>
<div> </div>
<div> </div>
<div><font face="Arial" size="2">********************************************************************************</font></div>
<div> </div>
<div><font face="Arial" size="2">The error number is [-691]<br>
This record was not processed because another record it needs, <br>
(see reference name listed below), is missing. This likely may be due
to a previous error <br>
already reported in the log above, or the result of Directory Services
Export issues <br>
reported separately, or due to missing Product, Locale, or other add-on
definition CSV <br>
files that should exist on the source system but do not.<br>
Suspected Field Is [DMABack_Admin.fk_enduserdirgroupmap_fkenduser] <br>
TABLE NAME IS [enduserdirgroupmap ] </font></div>
<div> </div>
<div><font face="Arial" size="2">fkdirgroup
'47b0de74-db3a-4be9-aa92-47a7921e0f26'</font></div>
<div> </div>
<div><font face="Arial" size="2">fkenduser
'b3104b58-5f47-4a2d-bf98-cadeccebbf2d'</font></div>
<div> </div>
<div><font face="Arial" size="2">pkid
'31abc01e-d680-4aa1-bbd4-4401b715ddb3'<br>
********************************************************************************</font></div>
<div> </div>
<div><font face="Arial" size="2">Here is what I find in the
installdbw1.log in reference to the error:</font></div>
<div> </div>
<div> </div>
<div><font face="Arial" size="2">10/30/2007 09:25:02.592 installdb|
DBUtil::CopyTable insert into enduserdirgroupmap
(fkdirgroup,fkenduser,pkid) values
('47b0de74-db3a-4be9-aa92-47a7921e0f26','b3104b58-5f47-4a2d-bf98-cadeccebbf2d','31abc01e-d680-4aa1-bbd4-4401b715ddb3')|<br>
10/30/2007 09:25:02.592 installdb| DBUtil::CopyTable ErrorCode=-691,
SQLState=HY000|<br>
10/30/2007 09:25:02.592 installdb|*ERROR* Error executing "insert into
enduserdirgroupmap (fkdirgroup,fkenduser,pkid) values
('47b0de74-db3a-4be9-aa92-47a7921e0f26','b3104b58-5f47-4a2d-bf98-cadeccebbf2d','31abc01e-d680-4aa1-bbd4-4401b715ddb3'):
[Informix][Informix ODBC Driver][Informix]Unspecified System Error =
-691. sqlerrm(DMABack_Admin.fk_enduserdirgroupmap_fkenduser)|<br>
10/30/2007 09:25:02.592 installdb|<--DBUtil::CopyTable |<br>
10/30/2007 09:25:02.592 installdb| DataConverter_4to5::CopyTables
update statistics medium for table enduserdirgroupmap|<br>
10/30/2007 09:25:02.608 installdb|-->SysUtil::DMACanceled |</font></div>
<div> </div>
<div> </div>
<div><font face="Arial" size="2">I found this page on the informix
error 391: </font></div>
<div> </div>
<div><font face="Arial" size="2"><a moz-do-not-send="true"
href="http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a00807f3307.shtml">http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a00807f3307.shtml</a></font></div>
<div> </div>
<div><font face="Arial" size="2">but unfortunately the solution does
apply to us....Any ideas will be greatly appreciated...</font></div>
<div> </div>
<div><font face="Arial" size="2">-Daniel</font></div>
<div> </div>
<blockquote dir="ltr"
style="border-left: 2px solid rgb(0, 0, 0); padding-right: 0px; padding-left: 5px; margin-left: 5px; margin-right: 0px;">
<div
style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"> </div>
<div
style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;">-----
Original Message ----- </div>
<div
style="background: rgb(228, 228, 228) none repeat scroll 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><b>From:</b>
<a moz-do-not-send="true" title="wsisk@cisco.com"
href="mailto:wsisk@cisco.com">Wes Sisk</a> </div>
<div
style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><b>To:</b>
<a moz-do-not-send="true" title="daniel.argueta@comcast.net"
href="mailto:daniel.argueta@comcast.net">Daniel Argueta</a> </div>
<div
style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><b>Cc:</b>
<a moz-do-not-send="true" title="cisco-voip@puck.nether.net"
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>
</div>
<div
style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><b>Sent:</b>
Tuesday, October 30, 2007 8:12 AM</div>
<div
style="font-family: arial; font-style: normal; font-variant: normal; font-weight: normal; font-size: 10pt; line-height: normal; font-size-adjust: none; font-stretch: normal;"><b>Subject:</b>
Re: [cisco-voip] CM4.1 to 5.x Upgrade (DMA Questions)</div>
<div><br>
</div>
the errors are most likely errors in your database. in the DMA output
it lists log files you need to retrive. collect those, zip them up,
and attach to your TAC case.<br>
<br>
what dma does:<br>
1. if cm ver < 5.0 or < 4.2, then export windows database<br>
2. import win database to ccm_w database in windows install of informix
with fkconstraints. error on any constraint failures<br>
3. migrate ccm_w informix database to ccm database in informix in new
cm6.x schema.<br>
<br>
Errors can occur at both steps 2 and 3. <br>
<br>
/Wes<br>
<br>
Daniel Argueta wrote:
<blockquote cite="mid:BF9C2A278ED44A9AAF459C0D468F9FBE@main"
type="cite">
<meta content="MSHTML 6.00.3790.4134" name="GENERATOR">
<style></style>
<div><font face="Arial" size="2">
<div><font face="Arial" size="2">Does anyone have any detailed
information about what the DMA actually does during the validation
process? It looks like i'm being able to take a backup of all the
information, but the validation is what fails when i'm trying to run
this utility......it errors out with some Database errors......i'm
guessing it's creating a temp database and using the schema it would
use in 5.x and inserting the information into it as a 'test'? Do any of
you have any information on the actual process this takes? I've been
messing with this for about 2 weeks now and can't seem to successfully
complete the DMA process.....except for this time i'm stuck and don't
know how to fix it......</font></div>
<div> </div>
<div><font face="Arial" size="2">Thanks,</font></div>
<div> </div>
<div><font face="Arial" size="2"><br>
Daniel Argueta</font></div>
</font></div>
<pre wrap=""><hr size="4" width="90%">
_______________________________________________
cisco-voip mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext"
href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a></pre>
</blockquote>
</blockquote>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
cisco-voip mailing list
<a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>
<a class="moz-txt-link-freetext" href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a></pre>
</blockquote>
</body>
</html>