Uploaded image for project: 'Service Packs and Hot Fixes'
  1. Service Packs and Hot Fixes
  2. MNT-17334

Upgrade from 4.2.4 to 5.1 fails with ORA-00955: name is already used by an existing object

    Details

    • Type: Service Pack Request
    • Status: Closed
    • Resolution: Won't Fix
    • Affects Version/s: 5.1
    • Fix Version/s: None
    • Component/s: Activiti, Upgrades
    • Labels:
      None
    • Environment:
      Ubuntu 12.04 LTS X64 | Oracle 11g | Tomcat 7.0.59
    • Bug Priority:
      Category 3
    • ACT Numbers:

      00756752, 00781220

      Description

      Steps to reproduce

      1. Setup 4.2.4 against Oracle
      2. Export the 4.2.4 DB SQL Developer [ Tools => Database export ]
      3. Setup 5.1.1 instance
      4. Drop/recreate the existing alfresco tablespace
      5. Execute the .sql file generated by the export
      6. Start 5.1 instace

      Actual result

      2017-01-10 16:03:34,860 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema auto-update failed
      java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
      
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

      Expected result
      No error

      Notes

      • Customer reproduced this using Oracle's expdp/impdp
      • Reproducible inhouse using SQL Developer tool
      • This is not reproducible using the classic oracle's exp/imp utilities.
      • The workaround for this is to drop the index as per article 000008859 but logging it as jira so the upgrade script deletes the existing index before trying to create it.
        alter table ACT_RE_PROCDEF drop constraint ACT_UNIQ_PROCDEF;
        drop index ACT_UNIQ_PROCDEF;
        alter table ACT_RE_PROCDEF add constraint ACT_UNIQ_PROCDEF unique (KEY_,VERSION_);
        

        Attachments

          Structure

            Activity

              People

              • Assignee:
                closedissues Closed Issues
                Reporter:
                rvellozo Ricardo Vellozo
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 hours
                  2h

                    Structure Helper Panel