CloverETL Forum

Hi ,
I am trying to read the Ldif file from universal reader but but getting the following error


INFO [WatchDog] - Successfully started all nodes in phase!
ERROR [WatchDog] - Graph execution finished with error
ERROR [WatchDog] - Node DATA_READER0 finished with status: ERROR caused by: Parsing error: Unexpected record delimiter, probably record has too few fields. in field # 2 of record # 1, value: 'dn: ou=site, o=Luminis Configuration
'
ERROR [WatchDog] - Node DATA_READER0 error details:
org.jetel.exception.BadDataFormatException: Parsing error: Unexpected record delimiter, probably record has too few fields. in field # 2 of record # 1, value: 'dn: ou=site, o=Luminis Configuration
'
at org.jetel.data.parser.DataParser.parsingErrorFound(DataParser.java:524)
at org.jetel.data.parser.DataParser.parseNext(DataParser.java:440)
at org.jetel.data.parser.DataParser.getNext(DataParser.java:169)
at org.jetel.util.MultiFileReader.getNext(MultiFileReader.java:321)
at org.jetel.component.DataReader.execute(DataReader.java:213)
at org.jetel.graph.Node.run(Node.java:390)
at java.lang.Thread.run(Unknown Source)
ERROR [WatchDog] - !!! Phase finished with error - stopping graph run !!!
INFO [WatchDog] - ----------------------** Final tracking Log for phase [0] **---------------------
INFO [WatchDog] - Time: 05/12/09 15:39:09
INFO [WatchDog] - Node Status Port #Records #KB aRec/s aKB/s
INFO [WatchDog] - ---------------------------------------------------------------------------------
INFO [WatchDog] - DATA_READER0 ERROR
INFO [WatchDog] - %cpu:.. Out:0 0 0 0 0
INFO [WatchDog] - LDAP_WRITER0 FINISHED_OK
INFO [WatchDog] - %cpu:.. In:0 0 0 0 0
INFO [WatchDog] - ---------------------------------** End of Log **--------------------------------
INFO [WatchDog] - Execution of phase [0] finished with error - elapsed time(sec): 0
INFO [WatchDog] - -----------------------** Summary of Phases execution **---------------------
INFO [WatchDog] - Phase# Finished Status RunTime(sec) MemoryAllocation(KB)
INFO [WatchDog] - 0 ERROR 0 2654
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 !

Could you please let me know where ia mdoing wrong ....what delimiter i should take i have tried the , ; : delimiters . Any delimiter also it is not working.


<?xml version="1.0" encoding="UTF-8"?>
<Graph author=" " created="Thu Jan 07 09:50:23 IST 2010" guiVersion="2.8.2.RC1" id="1262854948654" licenseCode="evaluation" licenseType="Evaluation" modified="Sat Dec 05 15:27:56 IST 2009" modifiedBy="" name="LdataWriter" revision="1.59">
<Global>
<Metadata id="Metadata0" previewAttachmentCharset="ISO-8859-1">
<Record fieldDelimiter=";" name="Export" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\n" recordSize="-1" type="delimited">
<Field eofAsDelimiter="false" name="dn" nullable="true" shift="0" size="0" type="string"/>
<Field eofAsDelimiter="false" name="objectClass" nullable="true" shift="0" size="0" type="string"/>
<Field eofAsDelimiter="false" name="ou" nullable="true" shift="0" size="0" type="string"/>
<Field eofAsDelimiter="false" name="cn" nullable="true" shift="0" size="0" type="string"/>
<Field eofAsDelimiter="false" name="pdsConfigValue" nullable="true" shift="0" size="0" type="string"/>
<Field eofAsDelimiter="false" name="pdsConfigValue_en" nullable="true" shift="0" size="0" type="string"/>
<Field eofAsDelimiter="false" name="pdsConfigValue_en__Symbolic" nullable="true" shift="0" size="0" type="string"/>
<Field eofAsDelimiter="false" name="pdsConfigType" nullable="true" shift="0" size="0" type="string"/>
<Field eofAsDelimiter="false" name="pdsConfigValue_en_US" nullable="true" shift="0" size="0" type="string"/>
<Field eofAsDelimiter="false" name="pdsConfigLocalizable" nullable="true" shift="0" size="0" type="string"/>
<Field eofAsDelimiter="false" name="pdsConfigClient" nullable="true" shift="0" size="0" type="string"/>
</Record>
</Metadata>
<Property fileURL="workspace.prm" id="GraphParameter0"/>
</Global>
<Phase number="0">
<Node enabled="enabled" fileURL="${DATAIN_DIR}/site.ldif" guiHeight="0" guiName="UniversalDataReader" guiWidth="0" guiX="45" guiY="110" id="DATA_READER0" type="DATA_READER" verbose="true"/>
<Node enabled="disabled" guiHeight="0" guiName="LDAPReader" guiWidth="0" guiX="38" guiY="215" id="LDAP_READER0" password="cp.admin" scope="subtree" type="LDAP_READER" user="cn=Directory Manager">
<attr name="ldapUrl"><![CDATA[${LDAPConn}]]></attr>
<attr name="filter"><![CDATA[(cn=*)]]></attr>
<attr name="base"><![CDATA[ou=People,o=sct.co.in,o=cp]]></attr>
</Node>
<Node action="add_entry" enabled="enabled" guiHeight="0" guiName="LDAPWriter" guiWidth="0" guiX="422" guiY="168" id="LDAP_WRITER0" ldapUrl="${LDAPTargetConn}" password="pipeline" type="LDAP_WRITER" user="cn=Directory Manager"/>
<Edge fromNode="DATA_READER0:0" guiBendpoints="" id="Edge1" inPort="Port 0 (in)" metadata="Metadata0" outPort="Port 0 (output)" toNode="LDAP_WRITER0:0"/>
</Phase>
</Graph>




if you help this that is very big help for me Please help me

Hello,
ldif files can't be read by CloverETL. To read ldap data use LdapReder component or DBInputTable. When you want to use the last one, you need to download jdbc-ldap bridge (Using SQL To Work With LDAP).