Uploaded image for project: 'Crucible'
  1. Crucible
  2. CRUC-5607

Cannot Restore 2.4.4 Backup into 2.5.0 Oracle via Command Line

    XMLWordPrintable

Details

    • Bug
    • Resolution: Not a bug
    • High
    • None
    • 2.5.0
    • Server administration
    • None
    • Crucible 2.5.0
      Oracle XE

    Description

      I'm trying to restore a 2.4.4 backup into 2.5.0 using Oracle and I keep getting the following error:

      Creating table definitions...
      java.io.IOException: Error talking to database: Problem opening create tables script
      	at com.atlassian.crucible.migration.item.SQLBackup.restore(SQLBackup.java:205)
      	at com.atlassian.crucible.migration.item.SQLBackup$1.restore(SQLBackup.java:172)
      	at com.cenqua.fisheye.ctl.Restore.run(Restore.java:159)
      	at com.cenqua.fisheye.ctl.Restore.main(Restore.java:228)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      	at java.lang.reflect.Method.invoke(Method.java:597)
      	at com.cenqua.fisheye.FishEyeCtl.mainImpl(FishEyeCtl.java:113)
      	at com.cenqua.fisheye.FishEyeCtl.main(FishEyeCtl.java:41)
      Caused by: com.cenqua.crucible.hibernate.CruDBException: Problem opening create tables script
      	at com.cenqua.crucible.hibernate.DefaultDBControl.createTables(DefaultDBControl.java:279)
      	at com.atlassian.crucible.migration.item.DBImporter.importData(DBImporter.java:127)
      	at com.atlassian.crucible.migration.item.SQLBackup.restore(SQLBackup.java:191)
      	... 9 more
      Caused by: java.io.FileNotFoundException: /usr/local/fecru/fecru-2.5.0/sql/ORACLE/schema/tables_69.sql (No such file or directory)
      	at java.io.FileInputStream.open(Native Method)
      	at java.io.FileInputStream.<init>(FileInputStream.java:106)
      	at java.io.FileReader.<init>(FileReader.java:55)
      	at com.cenqua.crucible.hibernate.DefaultDBControl.createTables(DefaultDBControl.java:274)
      	... 11 more
      

      Steps to reproduce:

      1. Create a backup (without cache) in Crucible 2.4.4.
      2. Shut down Crucible 2.4.4.
      3. Install Crucible 2.5.0.
      4. Try running the restore from the command line:

      ./fisheyectl.sh restore --file /usr/local/fecru/fecru-2.4.4/backup/backup_2011-08-02_0903.zip --dbtype oracle --jdbcurl jdbc:oracle:thin:@localhost:1521/XE --username crucible --password crucible

      Attachments

        Activity

          People

            Unassigned Unassigned
            dhansen@atlassian.com Dylan Hansen [Atlassian]
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: