Error in clover 2.2.1 but not on clover 2.1

tchoua_12

• December 13, 2007 00:00

• Answered

Follow

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,

• 

  avackova

  • December 13, 2007 11:21

  0

  Comment actions Permalink

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

  tchoua_12

  • December 13, 2007 15:47

  0

  Comment actions Permalink

  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
• 

  avackova

  • December 14, 2007 10:08

  0

  Comment actions Permalink

  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
• 

  tchoua_12

  • December 16, 2007 09:51

  0

  Comment actions Permalink

  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
• 

  avackova

  • December 17, 2007 08:38

  0

  Comment actions Permalink

  Hi,
  try to use WinZip or jar command.

Please sign in to leave a comment.