[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.
Hi,
This is now fixed in the DbVisualizer 7.1.2 version.
Regards
Roger
a
anonymous
said
over 13 years ago
[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.
Hans Bergsten
said
over 13 years ago
[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
anonymous