Bug #9023
Cannot run reports from a path with spaces
Status:
New
Priority:
Normal
Assignee:
-
Target version:
-
Start date:
Due date:
% Done:
0%
billable:
No
vendor_id:
GCD
case_num:
version_reported:
trunk/15357
version_resolved:
reviewer:
production:
No
env_name:
topics:
History
#1 Updated by Roger Borrello almost 2 years ago
I have tried to run reports on a project, and I am getting an error:
rfb@rfb:~/projects/test$ ant rpt-no-front
Buildfile: /media/rfb/Seagate 1TB/projects/test/build.xml
[echo] Working with the following database(s): main
init:
download-ant-contrib:
init-ant-contrib:
rpt-no-front:
[java] Elapsed job time: 06:07:48.855
[java]
[java] org.h2.jdbc.JdbcSQLNonTransientException: IO Exception: "java.io.IOException: Stream Closed"; "/media/rfb/Seagate 1TB/projects/test/rptdb/rptdb.h2.db"; SQL statement:
[java] ROLLBACK [90031-200]
[java] at org.h2.message.DbException.getJdbcSQLException(DbException.java:505)
[java] at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)
[java] at org.h2.message.DbException.get(DbException.java:194)
[java] at org.h2.message.DbException.convertIOException(DbException.java:394)
[java] at org.h2.store.FileStore.seek(FileStore.java:305)
[java] at org.h2.pagestore.PageStore.readPage(PageStore.java:1319)
[java] at org.h2.pagestore.PageStore.getPage(PageStore.java:744)
[java] at org.h2.pagestore.db.PageDataIndex.getPage(PageDataIndex.java:198)
[java] at org.h2.pagestore.db.PageDataIndex.writeRowCount(PageDataIndex.java:466)
[java] at org.h2.pagestore.PageStore.writeIndexRowCounts(PageStore.java:406)
[java] at org.h2.pagestore.PageStore.checkpoint(PageStore.java:429)
[java] at org.h2.pagestore.PageStore.commit(PageStore.java:1475)
[java] at org.h2.engine.Database.commit(Database.java:2207)
[java] at org.h2.engine.Session.rollback(Session.java:859)
[java] at org.h2.command.dml.TransactionCommand.update(TransactionCommand.java:49)
[java] at org.h2.command.CommandContainer.update(CommandContainer.java:198)
[java] at org.h2.command.Command.executeUpdate(Command.java:251)
[java] at org.h2.jdbc.JdbcConnection.rollbackInternal(JdbcConnection.java:1555)
[java] at org.h2.jdbc.JdbcConnection.rollback(JdbcConnection.java:580)
[java] at com.goldencode.p2j.report.ReportWorker.createDatabaseTables(ReportWorker.java:807)
[java] at com.goldencode.p2j.report.ReportWorker.access$000(ReportWorker.java:259)
[java] at com.goldencode.p2j.report.ReportWorker$Library.initializeDatabase(ReportWorker.java:1130)
[java] at com.goldencode.expr.CE9.execute(Unknown Source)
[java] at com.goldencode.expr.Expression.execute(Expression.java:398)
[java] at com.goldencode.p2j.pattern.Rule.apply(Rule.java:500)
[java] at com.goldencode.p2j.pattern.Rule.executeActions(Rule.java:751)
[java] at com.goldencode.p2j.pattern.Rule.coreProcessing(Rule.java:717)
[java] at com.goldencode.p2j.pattern.Rule.apply(Rule.java:537)
[java] at com.goldencode.p2j.pattern.PatternEngine.applyGlobal(PatternEngine.java:1750)
[java] at com.goldencode.p2j.pattern.PatternEngine.run(PatternEngine.java:1039)
[java] at com.goldencode.p2j.report.ReportDriver.patternEngine(ReportDriver.java:178)
[java] at com.goldencode.p2j.report.ReportDriver.doPass(ReportDriver.java:655)
[java] at com.goldencode.p2j.report.ReportDriver.newSyntax(ReportDriver.java:612)
[java] at com.goldencode.p2j.report.ReportDriver.main(ReportDriver.java:313)
[java] Caused by: java.io.IOException: Stream Closed
[java] at java.io.RandomAccessFile.seek0(Native Method)
[java] at java.io.RandomAccessFile.seek(RandomAccessFile.java:557)
[java] at org.h2.store.fs.FileDisk.position(FilePathDisk.java:485)
[java] at org.h2.store.FileStore.seek(FileStore.java:301)
[java] ... 29 more
[java]
[java] EXPRESSION EXECUTION ERROR:
[java] ---------------------------
[java] rw.initializeDatabase(appAdminPass)
[java] ^ { Error preparing database }
[java] ---------------------------
[java]
[java] java.lang.RuntimeException: ERROR! Active Rule:
[java] -----------------------
[java] RULE REPORT
[java] -----------------------
[java] Rule Type : INIT
[java] Source AST: null
[java] Copy AST : null
[java] Condition : rw.initializeDatabase(appAdminPass)
[java] Loop : false
[java] --- END RULE REPORT ---
[java]
[java]
[java]
[java] at com.goldencode.p2j.pattern.PatternEngine.run(PatternEngine.java:1109)
[java] at com.goldencode.p2j.report.ReportDriver.patternEngine(ReportDriver.java:178)
[java] at com.goldencode.p2j.report.ReportDriver.doPass(ReportDriver.java:655)
[java] at com.goldencode.p2j.report.ReportDriver.newSyntax(ReportDriver.java:612)
[java] at com.goldencode.p2j.report.ReportDriver.main(ReportDriver.java:313)
[java] Caused by: com.goldencode.expr.ExpressionException: Expression execution error @1:4
[java] at com.goldencode.expr.Expression.execute(Expression.java:495)
[java] at com.goldencode.p2j.pattern.Rule.apply(Rule.java:500)
[java] at com.goldencode.p2j.pattern.Rule.executeActions(Rule.java:751)
[java] at com.goldencode.p2j.pattern.Rule.coreProcessing(Rule.java:717)
[java] at com.goldencode.p2j.pattern.Rule.apply(Rule.java:537)
[java] at com.goldencode.p2j.pattern.PatternEngine.applyGlobal(PatternEngine.java:1750)
[java] at com.goldencode.p2j.pattern.PatternEngine.run(PatternEngine.java:1039)
[java] ... 4 more
[java] Caused by: java.lang.RuntimeException: Error preparing database
[java] at com.goldencode.p2j.report.ReportWorker.createDatabaseTables(ReportWorker.java:814)
[java] at com.goldencode.p2j.report.ReportWorker.access$000(ReportWorker.java:259)
[java] at com.goldencode.p2j.report.ReportWorker$Library.initializeDatabase(ReportWorker.java:1130)
[java] at com.goldencode.expr.CE9.execute(Unknown Source)
[java] at com.goldencode.expr.Expression.execute(Expression.java:398)
[java] ... 10 more
[java] Caused by: org.h2.jdbc.JdbcSQLNonTransientException: IO Exception: "java.io.IOException: Invalid argument"; "/media/rfb/Seagate 1TB/projects/test/rptdb/rptdb.h2.db"; SQL statement:
[java] drop table if exists user, file, ast_map, source_line, tag, report, report_tag, filter_profile, file_filter, report_column, report_cell, report_stats, match, category, search_history, user_search cascade [90031-200]
[java] at org.h2.message.DbException.getJdbcSQLException(DbException.java:505)
[java] at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)
[java] at org.h2.message.DbException.get(DbException.java:194)
[java] at org.h2.message.DbException.convertIOException(DbException.java:394)
[java] at org.h2.store.FileStore.setLength(FileStore.java:368)
[java] at org.h2.pagestore.PageStore.increaseFileSize(PageStore.java:1221)
[java] at org.h2.pagestore.PageStore.increaseFileSize(PageStore.java:1212)
[java] at org.h2.pagestore.PageStore.allocatePage(PageStore.java:1194)
[java] at org.h2.pagestore.PageStore.allocatePages(PageStore.java:1161)
[java] at org.h2.pagestore.PageOutputStream.reserve(PageOutputStream.java:76)
[java] at org.h2.pagestore.PageOutputStream.write(PageOutputStream.java:126)
[java] at org.h2.pagestore.PageLog.write(PageLog.java:552)
[java] at org.h2.pagestore.PageLog.addUndo(PageLog.java:533)
[java] at org.h2.pagestore.PageStore.logUndo(PageStore.java:1064)
[java] at org.h2.pagestore.db.PageDataLeaf.freeRecursive(PageDataLeaf.java:435)
[java] at org.h2.pagestore.db.PageDataNode.freeRecursive(PageDataNode.java:272)
[java] at org.h2.pagestore.db.PageDataNode.freeRecursive(PageDataNode.java:272)
[java] at org.h2.pagestore.db.PageDataNode.freeRecursive(PageDataNode.java:272)
[java] at org.h2.pagestore.db.PageDataIndex.removeAllRows(PageDataIndex.java:350)
[java] at org.h2.pagestore.db.PageDataIndex.remove(PageDataIndex.java:327)
[java] at org.h2.pagestore.db.PageStoreTable.removeChildrenAndResources(PageStoreTable.java:598)
[java] at org.h2.engine.Database.removeSchemaObject(Database.java:2045)
[java] at org.h2.command.ddl.DropTable.executeDrop(DropTable.java:117)
[java] at org.h2.command.ddl.DropTable.update(DropTable.java:133)
[java] at org.h2.command.CommandContainer.update(CommandContainer.java:198)
[java] at org.h2.command.Command.executeUpdate(Command.java:251)
[java] at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:228)
[java] at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:201)
[java] at com.goldencode.p2j.report.ReportWorker.createDatabaseTables(ReportWorker.java:673)
[java] ... 14 more
[java] Caused by: java.io.IOException: Invalid argument
[java] at java.io.RandomAccessFile.writeBytes(Native Method)
[java] at java.io.RandomAccessFile.write(RandomAccessFile.java:525)
[java] at org.h2.store.fs.FileDisk.write(FilePathDisk.java:492)
[java] at org.h2.store.fs.FileUtils.writeFully(FileUtils.java:375)
[java] at org.h2.store.FileStore.setLength(FileStore.java:360)
[java] ... 38 more
[java]
[java] Elapsed job time: 00:01:18.851
[java] EXPRESSION EXECUTION ERROR:
[java] ---------------------------
[java] rw.prepareDatabaseStatements(incremental)
[java] ^ { Error preparing database statements }
[java] ---------------------------
[java]
[java] java.lang.RuntimeException: ERROR! Active Rule:
[java] -----------------------
[java] RULE REPORT
[java] -----------------------
[java] Rule Type : INIT
[java] Source AST: null
[java] Copy AST : null
[java] Condition : rw.prepareDatabaseStatements(incremental)
[java] Loop : false
[java] --- END RULE REPORT ---
[java]
[java]
[java]
[java] at com.goldencode.p2j.pattern.PatternEngine.run(PatternEngine.java:1109)
[java] at com.goldencode.p2j.report.ReportDriver.patternEngine(ReportDriver.java:178)
[java] at com.goldencode.p2j.report.ReportDriver.doPass(ReportDriver.java:655)
[java] at com.goldencode.p2j.report.ReportDriver.newSyntax(ReportDriver.java:621)
[java] at com.goldencode.p2j.report.ReportDriver.main(ReportDriver.java:313)
[java] Caused by: com.goldencode.expr.ExpressionException: Expression execution error @1:4
[java] at com.goldencode.expr.Expression.execute(Expression.java:495)
[java] at com.goldencode.p2j.pattern.Rule.apply(Rule.java:500)
[java] at com.goldencode.p2j.pattern.PatternEngine.applyGlobal(PatternEngine.java:1750)
[java] at com.goldencode.p2j.pattern.PatternEngine.run(PatternEngine.java:1039)
[java] ... 4 more
[java] Caused by: java.lang.RuntimeException: Error preparing database statements
[java] at com.goldencode.p2j.report.ReportWorker.prepareStatements(ReportWorker.java:974)
[java] at com.goldencode.p2j.report.ReportWorker.access$300(ReportWorker.java:259)
[java] at com.goldencode.p2j.report.ReportWorker$Library.prepareDatabaseStatements(ReportWorker.java:1244)
[java] at com.goldencode.expr.CE19.execute(Unknown Source)
[java] at com.goldencode.expr.Expression.execute(Expression.java:398)
[java] ... 7 more
[java] Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "FILE" not found; SQL statement:
[java] insert into file (name) values (?) [42102-200]
[java] at org.h2.message.DbException.getJdbcSQLException(DbException.java:453)
[java] at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)
[java] at org.h2.message.DbException.get(DbException.java:205)
[java] at org.h2.message.DbException.get(DbException.java:181)
[java] at org.h2.command.Parser.readTableOrView(Parser.java:7689)
[java] at org.h2.command.Parser.readTableOrView(Parser.java:7660)
[java] at org.h2.command.Parser.parseInsert(Parser.java:1769)
[java] at org.h2.command.Parser.parsePrepared(Parser.java:969)
[java] at org.h2.command.Parser.parse(Parser.java:858)
[java] at org.h2.command.Parser.parse(Parser.java:830)
[java] at org.h2.command.Parser.prepareCommand(Parser.java:753)
[java] at org.h2.engine.Session.prepareLocal(Session.java:670)
[java] at org.h2.engine.Session.prepareCommand(Session.java:608)
[java] at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1260)
[java] at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:86)
[java] at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:1177)
[java] at com.goldencode.p2j.report.ReportWorker.prepareStatements(ReportWorker.java:860)
[java] ... 11 more
[java]
BUILD SUCCESSFUL
Total time: 369 minutes 10 seconds
There is a space in the path to the H2 DB:
Caused by: org.h2.jdbc.JdbcSQLNonTransientException: IO Exception: "java.io.IOException: Invalid argument"; "/media/rfb/Seagate 1TB/projects/test/rptdb/rptdb.h2.db";
#3 Updated by Roger Borrello almost 2 years ago
Strangely, I performed reports on both hotel and hotel_gui from the /media/rfb/Seagate 1TB/projects directory, and both finished fine without issue.