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
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).
Please sign in to leave a comment.
Comments 1