Hi,
I’m unable to get an XLS file wrapped in a ZIP format. However it works fine if I try with an XML_WRITER. Is there an issue with XLS_WRITER alone? Or I’m not sure if I have missed something.
Thanks.
The stack trace i get is:
DEBUG [WatchDog] - Opening input file D:\DOWNLOADS\cloverETL\cloveretl.engine\build\examples\data-in\other\ORDERS.xls
DEBUG [WatchDog] - Reading input file D:\DOWNLOADS\cloverETL\cloveretl.engine\build\examples\data-in\other\ORDERS.xls
INFO [WatchDog] - Reading data from sheet 0 (Sheet1).
DEBUG [WatchDog] - XLS_READER1 ...OK
ERROR [WatchDog] - Phase initialization failed with reason: XLS_WRITER0 ...FATAL ERROR !
Reason: java.io.FileNotFoundException: zip:D:\DOWNLOADS\cloverETL\cloveretl.engine\build\examples\data-out\ordersByCountry.zip (The
filename, directory name, or volume label syntax is incorrect)
XLS_WRITER0 ...FATAL ERROR !
Reason: java.io.FileNotFoundException: zip:D:\DOWNLOADS\cloverETL\cloveretl.engine\build\examples\data-out\ordersByCountry.zip (The
filename, directory name, or volume label syntax is incorrect)
at org.jetel.graph.Phase.init(Phase.java:163)
at org.jetel.graph.runtime.WatchDog.executePhase(WatchDog.java:423)
at org.jetel.graph.runtime.WatchDog.call(WatchDog.java:177)
at org.jetel.graph.runtime.WatchDog.call(WatchDog.java:62)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.RuntimeException: java.io.FileNotFoundException: zip:D:\DOWNLOADS\cloverETL\cloveretl.engine\build\examples\dat
a-out\ordersByCountry.zip (The filename, directory name, or volume label syntax is incorrect)
at org.jetel.data.formatter.JExcelXLSDataFormatter.setDataTarget(JExcelXLSDataFormatter.java:288)
at org.jetel.util.TargetFile.setDataTarget(TargetFile.java:449)
at org.jetel.util.TargetFile.setOutput(TargetFile.java:412)
at org.jetel.util.TargetFile.setNextOutput(TargetFile.java:298)
at org.jetel.util.TargetFile.initOutput(TargetFile.java:374)
at org.jetel.util.TargetFile.init(TargetFile.java:162)
at org.jetel.util.MultiFileWriter.prepareTargets(MultiFileWriter.java:187)
at org.jetel.util.MultiFileWriter.init(MultiFileWriter.java:143)
at org.jetel.component.XLSWriter.init(XLSWriter.java:486)
at org.jetel.graph.Phase.init(Phase.java:154)
... 6 more
Caused by: java.io.FileNotFoundException: zip:D:\DOWNLOADS\cloverETL\cloveretl.engine\build\examples\data-out\ordersByCountry.zip (T
he filename, directory name, or volume label syntax is incorrect)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(Unknown Source)
at java.io.FileOutputStream.<init>(Unknown Source)
at jxl.Workbook.createWorkbook(Workbook.java:301)
at org.jetel.data.formatter.JExcelXLSDataFormatter.setDataTarget(JExcelXLSDataFormatter.java:264)
... 15 more
ERROR [WatchDog] - !!! Phase finished with error - stopping graph run !!!
INFO [WatchDog] - ----------------------** Final tracking Log for phase [0] **---------------------
INFO [WatchDog] - Time: 23/10/09 15:43:01
INFO [WatchDog] - Node Status Port #Records #KB Rec/s KB/s
INFO [WatchDog] - ---------------------------------------------------------------------------------
INFO [WatchDog] - XLS_READER1 READY
INFO [WatchDog] - %cpu:.. Out:0 0 0 0 0
INFO [WatchDog] - XLS_WRITER0 ERROR
INFO [WatchDog] - %cpu:.. In:0 0 0 0 0
INFO [WatchDog] - ---------------------------------** End of Log **--------------------------------
INFO [WatchDog] - Execution of phase [0] successfully finished - elapsed time(sec): 0
INFO [WatchDog] - -----------------------** Summary of Phases execution **---------------------
INFO [WatchDog] - Phase# Finished Status RunTime(sec) MemoryAllocation(KB)
INFO [WatchDog] - 0 ERROR 0 7772
INFO [WatchDog] - ------------------------------** End of Summary **---------------------------
INFO [WatchDog] - WatchDog thread finished - total execution time: 0 (sec)
INFO [main] - Freeing graph resources.
ERROR [main] - Execution of graph failed !