Hi Folks,
while trying to do some quite simple transformations with the clover engine I experience some problems using the spreadsheet reader.
Reading an XLS file with the XLS data reader works fine, but as the customer (in fact my boss) wants to have XLSX files read I used the spreadsheet reader.
My transformation is really simple: just a spreadsheet reader and an unsiversal data writer. The Eclipse plugin doesn’t show any errors, but when I start running the graph the following error occurs:
INFO [main] - *** CloverETL framework/transformation graph, (c) 2002-2012 Javlin a.s, released under GNU Lesser General Public License ***
INFO [main] - Running with CloverETL library version 3.3.0.M2 build#074 compiled 02/05/2012 14:08:20
INFO [main] - Running on 4 CPU(s), OS Windows 7, architecture x86, Java version 1.7.0_09, max available memory for JVM 253440 KB
INFO [main] - Loading default properties from: defaultProperties
INFO [main] - Graph definition file: XlsxHeader.grf
INFO [main] - Graph revision: 1.1 Modified by: KoPasternack Modified: Mon Nov 19 16:01:09 CET 2012
INFO [main] - Checking graph configuration…
INFO [main] - Graph configuration is valid.
INFO [main] - Graph initialization (XlsxHeader)
INFO [main] - [Clover] Initializing phase: 0
INFO [main] - [Clover] phase: 0 initialized successfully.
INFO [main] - register MBean with name:org.jetel.graph.runtime:type=CLOVERJMX_1353337131878_0
INFO [WatchDog] - Starting up all nodes in phase [0]
INFO [WatchDog] - Successfully started all nodes in phase!
FATAL [SPREADSHEET_READER0_0] - java.lang.NoSuchMethodError: org.jetel.metadata.DataRecordMetadata.getNature()Lorg/jetel/data/DataRecordNature;
ERROR [WatchDog] - Graph execution finished with error
ERROR [WatchDog] - Node SPREADSHEET_READER0 finished with status: ERROR caused by: org.jetel.metadata.DataRecordMetadata.getNature()Lorg/jetel/data/DataRecordNature;
ERROR [WatchDog] - Node SPREADSHEET_READER0 error details:
java.lang.NoSuchMethodError: org.jetel.metadata.DataRecordMetadata.getNature()Lorg/jetel/data/DataRecordNature;
at org.jetel.data.DataRecordFactory.newRecord(DataRecordFactory.java:41)
at com.opensys.cloveretl.component.SpreadsheetReader.execute(Unknown Source)
at org.jetel.graph.Node.run(Node.java:416)
at java.lang.Thread.run(Unknown Source)
INFO [WatchDog] - [Clover] Post-execute phase finalization: 0
INFO [WatchDog] - [Clover] phase: 0 post-execute finalization successfully.
INFO [WatchDog] - Execution of phase [0] finished with error - elapsed time(sec): 0
ERROR [WatchDog] - !!! Phase finished with error - stopping graph run !!!
INFO [WatchDog] - -----------------------** Summary of Phases execution **---------------------
INFO [WatchDog] - Phase# Finished Status RunTime(sec) MemoryAllocation(KB)
INFO [WatchDog] - 0 ERROR 0 11690
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 !
reading from this part
FATAL [SPREADSHEET_READER0_0] - java.lang.NoSuchMethodError: org.jetel.metadata.DataRecordMetadata.getNature()Lorg/jetel/data/DataRecordNature;
there seems to be a wrong method call, but I just can’t work it out.
I’d appreciate your help.
k.pasternack