CloverETL Forum

CloverETL Engine, Designer & Server related discussion forums
It is currently Fri Oct 24, 2014 7:45 pm



Post new topic Reply to topic  [ 4 posts ] 
Author Message
PostPosted: Mon Jul 16, 2007 9:00 am 
Offline

Joined: Fri Jul 13, 2007 11:15 pm
Posts: 553
Greetings, I created a sample graph..


<?xml version="1.0" encoding="UTF-8"?>
<Graph created="Mon Feb 26 21:35:23 SGT 2007" guiVersion="1.6" licenseType="Unlicensed clover.GUI" modified="Tue Mar 06 11:18:28 SGT 2007" name="1_CAI_MAP" revision="1.32">
<Global>
<Metadata id="Metadata1">
<Record name="NPC_TB_REF_CAI" recordSize="-1" type="delimited">
<Field delimiter=";" name="CAI_CODE" nullable="true" shift="0" type="string"/>
<Field delimiter=";" name="CAI_WEIGHT" nullable="true" shift="0" type="numeric"/>
<Field delimiter=";" name="CAI_DIAMETER" nullable="true" shift="0" type="numeric"/>
<Field delimiter=";" name="CAI_TICKNESS" nullable="true" shift="0" type="numeric"/>
<Field delimiter="\n" name="CAI_NAILS_NB" nullable="true" shift="0" type="numeric"/>
</Record>
</Metadata>
<Metadata id="Metadata0">
<Record name="PUB2_PNEU_TXT" recordSize="-1" type="delimited">
<Field delimiter="," name="Field0" nullable="true" shift="0" type="string"/>
<Field delimiter="," name="Field1" nullable="true" shift="0" type="string"/>
<Field delimiter="," name="Field2" nullable="true" shift="0" type="string"/>
<Field delimiter="," name="Field3" nullable="true" shift="0" type="string"/>
<Field delimiter="," name="Field4" nullable="true" shift="0" type="string"/>
<Field delimiter="," name="Field5" nullable="true" shift="0" type="string"/>
<Field delimiter="," name="Field6" nullable="true" shift="0" type="string"/>
<Field delimiter="," name="Field7" nullable="true" shift="0" type="string"/>
<Field delimiter="," name="Field8" nullable="true" shift="0" type="string"/>
<Field delimiter="," name="Field9" nullable="true" shift="0" type="string"/>
<Field delimiter="," name="Field10" nullable="true" shift="0" type="string"/>
<Field delimiter="," name="Field11" nullable="true" shift="0" type="string"/>
<Field delimiter="," name="Field12" nullable="true" shift="0" type="string"/>
<Field delimiter="," name="Field13" nullable="true" shift="0" type="string"/>
<Field delimiter="," name="Field14" nullable="true" shift="0" type="string"/>
<Field delimiter="," name="Field15" nullable="true" shift="0" type="string"/>
<Field delimiter="," name="Field16" nullable="true" shift="0" type="string"/>
<Field delimiter="," name="Field17" nullable="true" shift="0" type="string"/>
<Field delimiter="," name="Field18" nullable="true" shift="0" type="string"/>
<Field delimiter="," name="Field19" nullable="true" shift="0" type="string"/>
<Field delimiter="," name="Field20" nullable="true" shift="0" type="string"/>
<Field delimiter="," name="Field21" nullable="true" shift="0" type="string"/>
<Field delimiter="," name="Field22" nullable="true" shift="0" type="string"/>
<Field delimiter="," name="Field23" nullable="true" shift="0" type="string"/>
<Field delimiter="," name="Field24" nullable="true" shift="0" type="string"/>
<Field delimiter="," name="Field25" nullable="true" shift="0" type="string"/>
<Field delimiter="\n" name="Field26" nullable="true" shift="0" type="string"/>
</Record>
</Metadata>
<Connection dbConfig="connection/NPC_R2_Connection.cfg" id="DBConnection0" type="JDBC"/>
</Global>
<Phase number="0">
<Node dataPolicy="strict" enabled="enabled" fileURL="D:/NPC/PCO_NPC_Data_Migration/Workspaces/PUB2toNPC/PUB2toNPC/Inputs/pneu.txt" guiHeight="0" guiName="Delimited Data Reader PNEU" guiWidth="0" guiX="45" guiY="62" id="DELIMITED_DATA_READER0" type="DELIMITED_DATA_READER"/>
<Node enabled="enabled" guiHeight="0" guiName="Reformat PNEU" guiWidth="0" guiX="228" guiY="62" id="REFORMAT0" transformClass="Transform_PNEU" type="REFORMAT">
<attr name="transform">${out.0.CAI_CODE} = ${in.0.Field0};
${out.0.CAI_WEIGHT} = ${in.0.Field5};
${out.0.CAI_DIAMETER} = ${in.0.Field18};
${out.0.CAI_TICKNESS} = ${in.0.Field19};
${out.0.CAI_NAILS_NB} = ${in.0.Field6};
</attr>
</Node>
<Edge fromNode="DELIMITED_DATA_READER0:0" guiBendpoints="" id="Edge0" inPort="0 (Reformat PNEU)" metadata="Metadata0" outPort="0 (Delimited Data Reader PNEU)" toNode="REFORMAT0:0"/>
<Edge fromNode="REFORMAT0:0" guiBendpoints="" id="Edge3" inPort="0 (DB Output TB_REF_CAI)" metadata="Metadata1" outPort="0 (Reformat PNEU)" toNode="DB_OUTPUT_TABLE0:0"/>
</Phase>
<Phase number="2">
<Node batchSize="0" cloverFields="CAI_CODE;CAI_WEIGHT;CAI_DIAMETER;CAI_TICKNESS;CAI_NAILS_NB" commit="0" dbConnection="DBConnection0" dbTable="NPC_R2.TB_REF_CAI" enabled="enabled" guiHeight="0" guiName="DB Output TB_REF_CAI" guiWidth="0" guiX="655" guiY="62" id="DB_OUTPUT_TABLE0" maxErrors="200000" type="DB_OUTPUT_TABLE"/>
</Phase>
</Graph>

____________________

How ever, when I try to run the graph in EclipseGui, i encountered this error.

*** CloverETL framework/transformation graph runner ver 2.1, (c) 2002-06 D.Pavlis, released under GNU Lesser General Public License ***
Running with framework version: 2.1 build#384 compiled 14/02/2007 17:59:26

DEBUG [main] - Plugin cz.opensys.oracle loaded.
id - cz.opensys.oracle
version - 2.1.0
provider-name -
point-id - component - {className=cz.opensys.oracle.component.OracleDataReader, type=ORACLE_DATA_READER}
point-id - component - {className=cz.opensys.oracle.component.OracleDataWriter, type=ORACLE_DATA_WRITER}

DEBUG [main] - Plugin org.jetel.component loaded.
id - org.jetel.component
version - 2.1.0
provider-name - null
point-id - component - {type=DATA_READER, className=org.jetel.component.DataReader}
point-id - component - {type=DATA_WRITER, className=org.jetel.component.DataWriter}
point-id - component - {type=DELIMITED_DATA_READER, className=org.jetel.component.DelimitedDataReader}
point-id - component - {type=DELIMITED_DATA_WRITER, className=org.jetel.component.DelimitedDataWriter}
point-id - component - {type=SIMPLE_COPY, className=org.jetel.component.SimpleCopy}
point-id - component - {type=CONCATENATE, className=org.jetel.component.Concatenate}
point-id - component - {type=SIMPLE_GATHER, className=org.jetel.component.SimpleGather}
point-id - component - {type=REFORMAT, className=org.jetel.component.Reformat}
point-id - component - {type=DB_INPUT_TABLE, className=org.jetel.component.DBInputTable}
point-id - component - {type=SORT, className=org.jetel.component.Sort}
point-id - component - {type=DB_OUTPUT_TABLE, className=org.jetel.component.DBOutputTable}
point-id - component - {type=FIXLEN_DATA_WRITER, className=org.jetel.component.FixLenDataWriter}
point-id - component - {type=DEDUP, className=org.jetel.component.Dedup}
point-id - component - {type=FIXLEN_DATA_READER, className=org.jetel.component.FixLenDataReader}
point-id - component - {type=MERGE, className=org.jetel.component.Merge}
point-id - component - {type=MERGE_JOIN, className=org.jetel.component.MergeJoin}
point-id - component - {type=EXT_MERGE_JOIN, className=org.jetel.component.MergeJoin}
point-id - component - {type=SORTED_JOIN, className=org.jetel.component.MergeJoin}
point-id - component - {type=TRASH, className=org.jetel.component.Trash}
point-id - component - {type=DB_EXECUTE, className=org.jetel.component.DBExecute}
point-id - component - {type=HASH_JOIN, className=org.jetel.component.HashJoin}
point-id - component - {type=EXT_HASH_JOIN, className=org.jetel.component.HashJoin}
point-id - component - {type=CHECK_FOREIGN_KEY, className=org.jetel.component.CheckForeignKey}
point-id - component - {type=DBF_DATA_READER, className=org.jetel.component.DBFDataReader}
point-id - component - {type=EXT_FILTER, className=org.jetel.component.ExtFilter}
point-id - component - {type=EXT_SORT, className=org.jetel.component.ExtSort}
point-id - component - {type=PARTITION, className=org.jetel.component.Partition}
point-id - component - {type=DATA_INTERSECTION, className=org.jetel.component.DataIntersection}
point-id - component - {type=AGGREGATE, className=org.jetel.component.Aggregate}
point-id - component - {type=SYS_EXECUTE, className=org.jetel.component.SystemExecute}
point-id - component - {type=KEY_GEN, className=org.jetel.component.KeyGenerator}
point-id - component - {type=APROX_MERGE_JOIN, className=org.jetel.component.AproxMergeJoin}
point-id - component - {type=DBJOIN, className=org.jetel.component.DBJoin}
point-id - component - {type=XLS_READER, className=org.jetel.component.XLSReader}
point-id - component - {type=XLS_WRITER, className=org.jetel.component.XLSWriter}
point-id - component - {type=CLOVER_WRITER, className=org.jetel.component.CloverDataWriter}
point-id - component - {type=CLOVER_READER, className=org.jetel.component.CloverDataReader}
point-id - component - {className=org.jetel.component.MysqlDataReader, type=MYSQL_DATA_READER}
point-id - component - {className=org.jetel.component.MysqlDataWriter, type=MYSQL_DATA_WRITER}
point-id - component - {className=org.jetel.component.StructureWriter, type=STRUCTURE_WRITER}
point-id - component - {className=org.jetel.component.Normalizer, type=NORMALIZER}
point-id - component - {className=org.jetel.component.Denormalizer, type=DENORMALIZER}
point-id - component - {className=org.jetel.component.JmsReader, type=JMS_READER}
point-id - component - {className=org.jetel.component.JmsWriter, type=JMS_WRITER}
point-id - component - {className=org.jetel.component.LookupJoin, type=LOOKUP_JOIN}
point-id - component - {className=org.jetel.component.LookupTableReaderWriter, type=LOOKUP_TABLE_READER_WRITER}
point-id - component - {className=org.jetel.component.DataGenerator, type=DATA_GENERATOR}
point-id - component - {className=org.jetel.component.MultiLevelReader, type=MULTI_LEVEL_READER}
point-id - component - {className=org.jetel.component.SequenceChecker, type=SEQUENCE_CHECKER}

DEBUG [main] - Plugin org.jetel.connection loaded.
id - org.jetel.connection
version - 2.1.0
provider-name - null
point-id - connection - {className=org.jetel.connection.DBConnection, type=JDBC}
point-id - connection - {className=org.jetel.connection.JmsConnection, type=JMS}

DEBUG [main] - Plugin org.jetel.lookup loaded.
id - org.jetel.lookup
version - 2.1.0
provider-name - null
point-id - lookup - {className=org.jetel.lookup.SimpleLookupTable, type=simpleLookup}
point-id - lookup - {className=org.jetel.lookup.DBLookupTable, type=dbLookup}

DEBUG [main] - Plugin org.jetel.sequence loaded.
id - org.jetel.sequence
version - 2.1.0
provider-name - null
point-id - sequence - {className=org.jetel.sequence.SimpleSequence, type=SIMPLE_SEQUENCE}
point-id - sequence - {className=org.jetel.sequence.PrimitiveSequence, type=PRIMITIVE_SEQUENCE}

DEBUG [main] - Plugin org.jetel.thirdparty loaded.
id - org.jetel.thirdparty
version - 2.1.0
provider-name - null
point-id - component - {type=XML_EXTRACT, className=org.jetel.component.XMLExtract}
point-id - component - {type=FILTER, className=org.jetel.component.Filter}
point-id - component - {type=LDAP_READER, className=com.linagora.component.LdapReader}
point-id - component - {type=LDAP_WRITER, className=com.linagora.component.LdapWriter}

Graph definition file: 01_CAI_MAP.grf
ERROR [main] - Can't create object of type DELIMITED_DATA_READER with reason: not implemented in org.jetel.graph.Node
ERROR [main] - Error during graph initialization !
java.lang.RuntimeException: Can't create object of type DELIMITED_DATA_READER with reason: not implemented in org.jetel.graph.Node
at org.jetel.component.ComponentFactory.createComponent(ComponentFactory.java:137)
at org.jetel.graph.TransformationGraphXMLReaderWriter.instantiateNodes(TransformationGraphXMLReaderWriter.java:403)
at org.jetel.graph.TransformationGraphXMLReaderWriter.instantiatePhases(TransformationGraphXMLReaderWriter.java:366)
at org.jetel.graph.TransformationGraphXMLReaderWriter.read(TransformationGraphXMLReaderWriter.java:278)
at org.jetel.main.runGraph.loadGraph(runGraph.java:147)
at org.jetel.main.runGraph.main(runGraph.java:279)


--------------

What do you think is the problem? hope you can help me guyz, thnkyou very much.. PEACE...


Top
 Profile  
 
PostPosted: Mon Jul 16, 2007 9:23 am 
Offline

Joined: Fri Jul 13, 2007 11:15 pm
Posts: 553
Upss, better way martin.zatopek@javlinconsulting.cz

;)

Thanks, Martin


Top
 Profile  
 
PostPosted: Mon Jul 16, 2007 9:23 am 
Offline

Joined: Fri Jul 13, 2007 11:15 pm
Posts: 553
Hello,
that sounds like really mysterious bug. We have never met it before. Can I ask you to try run your graph direct from command line, whether issue persist?

Please also check if you don't have in eclipse project classpath some old clover engine jars included.

For next communication, please, use direct my email - zatopek.martin@javlinconsulting.cz.

Martin


Top
 Profile  
 
PostPosted: Tue Apr 07, 2009 2:12 pm 
Offline

Joined: Tue Apr 07, 2009 2:09 pm
Posts: 4
I experienced this as well. The problem is proberly that you didn't override the fromXm method in your customized Component. Thus the exception you see is a UnsupportedOperationException from the super class


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 


Who is online

Users browsing this forum: No registered users and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group