Start-up problems

oldforum

• July 16, 2007 00:00

• Answered

Follow

Hello,

I am new to CloverETL. I have installed it as per the instructions and have the GUI-editor in Eclipse up and running too. The examples have been extracted and works fine.

I have now created a simple graph through the Eclipse plug-in that contains a DB_INPUT_TABLE and a DB_OUTPUT_TABLE. This is connected by a "Simple Copy" transformation.

The following are the relevant properties:

DB_INPUT_TABLE:
Component Type: DB_INPUT_TABLE
Data Policy: (blank)
DBConnection: MondrianFoodMartConnection.cfg
Fetch size: (blank)
ID: DB_INPUT_TABLE0
Phase: 0
SQL Code: (blank)
SQL Query: select * from account
URL: (blank)

Ports:
Input ports: None
Output ports:
Port 0 - defaultRecordName(id: Metadata0) => this is the metadata name for the table structure built from the database for the "account" table.


Now, when I run the command

java -cp ".\cloverETL.zip;C:\Program Files\Apache Softwa
re Foundation\commons-logging-1.0.4\commons-logging.jar" org.jetel.main.runGraph
ETLGraph1.grf

it fails with the following output:
*** CloverETL framework/transformation graph runner ver1.7, (c) 2002-05 D.Pavli
s, released under GNU Lesser General Public License ***

Graph definition file: ETLGraph1.grf
Can't find <SQLCode> node !
!!! Fatal error during graph initialization !!!
null


Now, if modify the above properties to leave "SQL Query" blank and put the sql query in the "SQL Code" field, I get the following error:

*** CloverETL framework/transformation graph runner ver1.7, (c) 2002-05 D.Pavli
s, released under GNU Lesser General Public License ***

Graph definition file: ETLGraph1.grf
Can't find <SQLCode> node !
java.lang.RuntimeException: Can't find <SQLCode> node !
at org.jetel.component.DBInputTable.fromXML(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jetel.component.ComponentFactory.createComponent(Unknown Source)
at org.jetel.graph.TransformationGraphXMLReaderWriter.instantiateNodes(U
nknown Source)
at org.jetel.graph.TransformationGraphXMLReaderWriter.instantiatePhases(
Unknown Source)
at org.jetel.graph.TransformationGraphXMLReaderWriter.read(Unknown Sourc
e)
at org.jetel.main.runGraph.main(Unknown Source)
!!! Fatal error during graph initialization !!!
null

Can someone please help?

Thanks in advance.

• 

  oldforum

  • July 16, 2007 08:23

  0

  Comment actions Permalink

  Sorry; posted this in the wrong forum and also managed to fix my problem. There were other settings that were not properly done in terms of metadata definition and assigning it to the input/output ports.
• 

  oldforum

  • July 16, 2007 08:23

  0

  Comment actions Permalink

  Hi Suhasmallya,
  you are new to Clover but you are find real bug in our Clover GUI. Thanks for report it. Just we finishing new version of CloverETL GUI, next week you can look forward to it ;)
  
  Now your only chance is edit source of graph, try something like that:
  
  <Node id="INPUT" type="DB_INPUT_TABLE" dbConnection="MondrianFoodMartConnection.cfg" sqlQuery="select * from account"/>
  
  
  Good luck, OtaSanek

Please sign in to leave a comment.