Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#4490 Migrate Error: 2.6.0a to 2.6.1

R2.6.0
closed
Felipe Reyes
5
2007-06-27
2007-06-19
eltek
No

Hi All,

I've got a lot of errors running migration tool. See the last errors in LOG file:

<<ERROR: ORA-02260: table can have only one primary key
- ALTER TABLE AD_PROCESS_TRL ADD CONSTRAINT AD_PROCESS_TRL_KEY PRIMARY KEY (AD_PROCESS_ID,AD_LANGUAGE)>>
<<ERROR: ORA-02429: cannot drop index used for enforcement of unique/primary key
- DROP INDEX PK567>>
Too many errors - exiting

Is this a bug in RUN_Migrate tool?

Log file is attached.

Thank's a lot.
Ricardo

Discussion

  • eltek
    eltek
    2007-06-19

    Log file

     
  • Kathy Pink
    Kathy Pink
    2007-06-19

    • assigned_to: nobody --> lfreyes
     
  • Felipe Reyes
    Felipe Reyes
    2007-06-19

    Logged In: YES
    user_id=1793135
    Originator: NO

    Hi Ricardo,
    I'm testing in my internal instance the upgrade from 2.6.0a to 2.6.1.
    I'll provide a new update as soon as the migration is done to see if could reproduce your issue...

    Felipe

     
  • Felipe Reyes
    Felipe Reyes
    2007-06-19

    Logged In: YES
    user_id=1793135
    Originator: NO

    Ricardo,
    I could not reproduce your problem.

    I noticed in your log file a few objects that should not be part of REFERENCE.

    Could you confirm if you followed these steps when running the migration?
    1) Backup your 2.6.0.a instance
    2) Unzip Compiere_261.zip to overwrite the files on your COMPIERE_HOME (e.g. c:\compiere2)
    3) Execute C:\compiere2\RUN_setup
    4) Execute c:\compiere2\utils\RUN_ImportReference
    5) Execute c:\compiere2\utils\RUN_Migrate

    Please validate especially step #4 to ensure that there were no errors during the import

     
  • Felipe Reyes
    Felipe Reyes
    2007-06-19

    • status: open --> pending
     
    • status: pending --> closed
     
  • Logged In: YES
    user_id=1312539
    Originator: NO

    This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 7 days (the time period specified by
    the administrator of this Tracker).