[cisco-voip] CM4.1 to 5.x Upgrade (DMA Questions)

[Daniel Argueta]

Nope.....darn thing failed again....this is the only error message in the whole DMAErrors.log:


********************************************************************************

The error number is [-691]
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.
Suspected Field Is [DMABack_Admin.fk_enduserdirgroupmap_fkenduser] 
TABLE NAME IS [enduserdirgroupmap ] 

fkdirgroup                '47b0de74-db3a-4be9-aa92-47a7921e0f26'

fkenduser                 'b3104b58-5f47-4a2d-bf98-cadeccebbf2d'

pkid                      '31abc01e-d680-4aa1-bbd4-4401b715ddb3'
********************************************************************************

Here is what I find in the installdbw1.log in reference to the error:


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')|
10/30/2007 09:25:02.592 installdb|   DBUtil::CopyTable ErrorCode=-691, SQLState=HY000|
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)|
10/30/2007 09:25:02.592 installdb|<--DBUtil::CopyTable |
10/30/2007 09:25:02.592 installdb|   DataConverter_4to5::CopyTables update statistics medium for table enduserdirgroupmap|
10/30/2007 09:25:02.608 installdb|-->SysUtil::DMACanceled |


I found this page on the informix error 391: 

http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a00807f3307.shtml

but unfortunately the solution does apply to us....Any ideas will be greatly appreciated...

-Daniel


  ----- Original Message ----- 
  From: Wes Sisk 
  To: Daniel Argueta 
  Cc: cisco-voip at puck.nether.net 
  Sent: Tuesday, October 30, 2007 8:12 AM
  Subject: Re: [cisco-voip] CM4.1 to 5.x Upgrade (DMA Questions)


  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.

  what dma does:
  1. if cm ver < 5.0 or < 4.2, then export windows database
  2. import win database to ccm_w database in windows install of informix with fkconstraints.  error on any constraint failures
  3. migrate ccm_w informix database to ccm database in informix in new cm6.x schema.

  Errors can occur at both steps 2 and 3.  

  /Wes

  Daniel Argueta wrote: 
    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......

    Thanks,


    Daniel Argueta
----------------------------------------------------------------------------
_______________________________________________
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/20071030/97992786/attachment-0001.html