Error in clover 2.2.1 but not on clover 2.1

CloverDX Platform
1

Hello,

I have updated clover from version 2.1 to 2.2.1. I copy DBF tables into a MySql database.
In the 2.1 version I have no error but in the 2.2.1 version I get the following error :

DEBUG [WatchDog] -      DBF_DATA_READER ...OK
DEBUG [WatchDog] -      MYSQL_WRITER ...OK
INFO  [WatchDog] - [Clover] phase: 0 initialized successfully.
INFO  [WatchDog] - Starting up all nodes in phase [0]
DEBUG [WatchDog] - DBF_DATA_READER ... started
DEBUG [WatchDog] - MYSQL_WRITER ... started
INFO  [WatchDog] - Sucessfully started all nodes in phase!
Exception in thread "DBF_DATA_READER" java.lang.NoClassDefFoundError: javolution/text/TypeFormat
        at org.jetel.data.NumericDataField.fromString(NumericDataField.java:447)
        at org.jetel.database.dbf.DBFDataParser.populateField(DBFDataParser.java:216)
        at org.jetel.database.dbf.DBFDataParser.parseNext(DBFDataParser.java:187)
        at org.jetel.database.dbf.DBFDataParser.getNext(DBFDataParser.java:152)
        at org.jetel.util.MultiFileReader.getNext(MultiFileReader.java:216)
        at org.jetel.component.DBFDataReader.execute(DBFDataReader.java:162)
        at org.jetel.graph.Node.run(Node.java:366)
        at java.lang.Thread.run(Thread.java:595)

what I understand is that a java class is missing to convert a numeric value to a String, when I give a look to the data I have numeric that I copy into MySql in a Varchar column.

I tried on the 2.3.3 version but I get exactly the same error.

Is there a way to make new version working with DBF_DATA_READER or should I keep my working 2.1 version for DBF loading and the 2.2.1 version for XLS loading ?

Thanks for your reading.

Regards,

2

Hi,
when you run graph, javolution.jar (included in CloverETL package) has to be in classpath while we use it when parsing strings.

3

I have tried to include the javolution.jar package it seams to resolve my problem but I get an other error.


DEBUG [WatchDog] - DBF_DATA_READER ... started
DEBUG [WatchDog] - MYSQL_WRITER ... started
INFO  [WatchDog] - Sucessfully started all nodes in phase!
FATAL [WatchDog] - !!! Fatal Error !!! - graph execution is aborting
ERROR [WatchDog] - Node DBF_DATA_READER finished with status: ERROR caused by: null
DEBUG [WatchDog] - Node DBF_DATA_READER error details:
java.lang.IllegalArgumentException
        at java.nio.Buffer.limit(Buffer.java:249)
        at org.jetel.database.dbf.DBFDataParser.parseNext(DBFDataParser.java:187)
        at org.jetel.database.dbf.DBFDataParser.getNext(DBFDataParser.java:154)
        at org.jetel.util.MultiFileReader.getNext(MultiFileReader.java:229)
        at org.jetel.component.DBFDataReader.execute(DBFDataReader.java:162)
        at org.jetel.graph.Node.run(Node.java:366)
        at java.lang.Thread.run(Thread.java:595)

I don’t realy understand what’s wrong in this case.
Should I understand that there are null values in the DBF tables and I need to treat it with the graph or it is a java object that is null and it crashed my clover data loading ?

Thanks for your help.

Regards

Tchoua

4

Hi,
aren’t your data very large. I suppose that your record is greater then expected size. Pls check http://wiki.clovergui.net/doku.php?id=c … _constants

5

Hello,

I tried to extract and after modification of the parameter file to recompile the jar with a compressing tool as WinRar witch is file roler under gnome desktop but the generated jar file doesn’t work at all.
I think I need to use a special command line to extract and to recompile the jar.

Can you tell how to do it or where to find some help on jar file ?

Thank you

Tchoua

6

Hi,
try to use WinZip or jar command.