Start a new topic

Export is failing for me

[This topic is migrated from our old forums. The original author name has been removed]

I tried several times to export. The error seems to indicate that it can't open the file. I tried various paths and filenames but always got the error below. My export directives are @export on; @export set Filename="/Users/jdough/output.csv"; @export set Format='CSV'; @export set ShowNullAs=''; the debug window says... 15:22:55 [ERROR Thread-23 C.?] Internal error while executing: select m.member_email as ... java.io.FileNotFoundException: (No such file or directory) at java.io.FileOutputStream.open(Native Method) at java.io.FileOutputStream.(FileOutputStream.java:179) at java.io.FileOutputStream.(FileOutputStream.java:102) at com.onseven.dbvis.k.A.C.?(Z:795) at com.onseven.dbvis.k.A.C.?(Z:3302) at com.onseven.dbvis.sql.B.processResultSet(Z:1880) at com.onseven.dbvis.G.B.I.execute(Z:1180) at com.onseven.dbvis.G.B.M.execute(Z:174) at com.onseven.dbvis.G.B.X.?(Z:591) at com.onseven.dbvis.G.B.X.run(Z:1655) at com.onseven.dbvis.G.B.C.?(Z:1374) at com.onseven.dbvis.G.B.C.?(Z:636) at com.onseven.dbvis.G.B.C.execute(Z:3186) at com.onseven.dbvis.G.B.X.?(Z:591) at com.onseven.dbvis.G.B.J.?(Z:1013) at se.pureit.swing.A.O$2.run(Z:1192) at java.lang.Thread.run(Thread.java:637) 15:27:13 [ERROR Thread-26 C.?] Internal error while executing: select m.member_email as ... java.io.FileNotFoundException: (No such file or directory) at java.io.FileOutputStream.open(Native Method) at java.io.FileOutputStream.(FileOutputStream.java:179) at java.io.FileOutputStream.(FileOutputStream.java:102) at com.onseven.dbvis.k.A.C.?(Z:795) at com.onseven.dbvis.k.A.C.?(Z:3302) at com.onseven.dbvis.sql.B.processResultSet(Z:1880) at com.onseven.dbvis.G.B.I.execute(Z:1180) at com.onseven.dbvis.G.B.M.execute(Z:174) at com.onseven.dbvis.G.B.X.?(Z:591) at com.onseven.dbvis.G.B.X.run(Z:1655) at com.onseven.dbvis.G.B.C.?(Z:1374) at com.onseven.dbvis.G.B.C.?(Z:636) at com.onseven.dbvis.G.B.C.execute(Z:3186) at com.onseven.dbvis.G.B.X.?(Z:591) at com.onseven.dbvis.G.B.J.?(Z:1013) at se.pureit.swing.A.O$2.run(Z:1192) at java.lang.Thread.run(Thread.java:637) 15:31:14 [ERROR Thread-29 C.?] Internal error while executing: select m.member_email as ... java.io.FileNotFoundException: (No such file or directory) at java.io.FileOutputStream.open(Native Method) at java.io.FileOutputStream.(FileOutputStream.java:179) at java.io.FileOutputStream.(FileOutputStream.java:102) at com.onseven.dbvis.k.A.C.?(Z:795) at com.onseven.dbvis.k.A.C.?(Z:3302) at com.onseven.dbvis.sql.B.processResultSet(Z:1880) at com.onseven.dbvis.G.B.I.execute(Z:1180) at com.onseven.dbvis.G.B.M.execute(Z:174) at com.onseven.dbvis.G.B.X.?(Z:591) at com.onseven.dbvis.G.B.X.run(Z:1655) at com.onseven.dbvis.G.B.C.?(Z:1374) at com.onseven.dbvis.G.B.C.?(Z:636) at com.onseven.dbvis.G.B.C.execute(Z:3186) at com.onseven.dbvis.G.B.X.?(Z:591) at com.onseven.dbvis.G.B.J.?(Z:1013) at se.pureit.swing.A.O$2.run(Z:1192) at java.lang.Thread.run(Thread.java:637) 15:38:40 [ERROR Thread-32 C.?] Internal error while executing: select m.member_email as ... java.io.FileNotFoundException: (No such file or directory) at java.io.FileOutputStream.open(Native Method) at java.io.FileOutputStream.(FileOutputStream.java:179) at java.io.FileOutputStream.(FileOutputStream.java:102) at com.onseven.dbvis.k.A.C.?(Z:795) at com.onseven.dbvis.k.A.C.?(Z:3302) at com.onseven.dbvis.sql.B.processResultSet(Z:1880) at com.onseven.dbvis.G.B.I.execute(Z:1180) at com.onseven.dbvis.G.B.M.execute(Z:174) at com.onseven.dbvis.G.B.X.?(Z:591) at com.onseven.dbvis.G.B.X.run(Z:1655) at com.onseven.dbvis.G.B.C.?(Z:1374) at com.onseven.dbvis.G.B.C.?(Z:636) at com.onseven.dbvis.G.B.C.execute(Z:3186) at com.onseven.dbvis.G.B.X.?(Z:591) at com.onseven.dbvis.G.B.J.?(Z:1013) at se.pureit.swing.A.O$2.run(Z:1192) at java.lang.Thread.run(Thread.java:637) Any help would be greatly appreciated. I'm trying to locate an alternative to Aquadata for OSX to perform lots of large data exports. thank you.

[This reply is migrated from our old forums.]

Re: Export is failing for me
Hi, It's admittedly a very poor error message, but the problem is that you must use a single "@export set" command, as each command overrides the previous settings. In you case, the filename is therefore set to null by the second "@export set" command. Try this instead: @export on; @export set Filename="/Users/jdough/output.csv" Format='CSV' ShowNullAs=''; ? @export off; Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: Export is failing for me
Thank you for the rapid response! Works beautifully now.
[This reply is migrated from our old forums.]

Re: Export is failing for me
Hi, This is now fixed in the DbVisualizer 7.1.2 version. Regards Roger