Details
-
Bug
-
Resolution: Not a bug
-
High
-
None
-
2.5.0
-
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