java.io.IOException: Error talking to database: Problem opening create tables script

Atlassian JIRA | Dylan Hansen [Atlassian] | 6 years ago
  1. 0

    I'm trying to restore a 2.4.4 backup into 2.5.0 using Oracle and I keep getting the following error: {noformat} 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 {noformat} 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: {noformat}./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{noformat}

    Atlassian JIRA | 6 years ago | Dylan Hansen [Atlassian]
    java.io.IOException: Error talking to database: Problem opening create tables script
  2. 0

    I'm trying to restore a 2.4.4 backup into 2.5.0 using Oracle and I keep getting the following error: {noformat} 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 {noformat} 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: {noformat}./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{noformat}

    Atlassian JIRA | 6 years ago | Dylan Hansen [Atlassian]
    java.io.IOException: Error talking to database: Problem opening create tables script
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    ecyrd.com | 2 years ago
    java.io.FileNotFoundException: \WEB-INF\jspwiki.properties (The system cannot fi nd the path specified)
  5. 0

    2.1 snapshot in Eclair branch

    Google Groups | 7 years ago | Jean-Baptiste Queru
    java.lang.RuntimeException: failed to parse

  1. jshakil 1 times, last 1 month ago
  2. serious2monkeys 4 times, last 2 months ago
  3. davidvanlaatum 1 times, last 3 months ago
  4. Christopher 3 times, last 3 months ago
  5. r1chjames 1 times, last 5 months ago
5 more registered users
19 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. 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()
  2. Java RT
    FileReader.<init>
    1. java.io.FileInputStream.open(Native Method)
    2. java.io.FileInputStream.<init>(FileInputStream.java:106)
    3. java.io.FileReader.<init>(FileReader.java:55)
    3 frames
  3. com.cenqua.crucible
    DefaultDBControl.createTables
    1. com.cenqua.crucible.hibernate.DefaultDBControl.createTables(DefaultDBControl.java:274)
    1 frame
  4. com.atlassian.crucible
    SQLBackup$1.restore
    1. com.atlassian.crucible.migration.item.DBImporter.importData(DBImporter.java:127)
    2. com.atlassian.crucible.migration.item.SQLBackup.restore(SQLBackup.java:191)
    3. com.atlassian.crucible.migration.item.SQLBackup$1.restore(SQLBackup.java:172)
    3 frames
  5. com.cenqua.fisheye
    Restore.main
    1. com.cenqua.fisheye.ctl.Restore.run(Restore.java:159)
    2. com.cenqua.fisheye.ctl.Restore.main(Restore.java:228)
    2 frames
  6. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  7. com.cenqua.fisheye
    FishEyeCtl.main
    1. com.cenqua.fisheye.FishEyeCtl.mainImpl(FishEyeCtl.java:113)
    2. com.cenqua.fisheye.FishEyeCtl.main(FishEyeCtl.java:41)
    2 frames