This discussion is archived
1 Reply Latest reply: Jul 5, 2012 2:17 PM by kkonada RSS

Metadata Merge for Joins --Unexpected end of file in field # 1 of record#9

kkonada Newbie
Currently Being Moderated
I am working on EBS Endeca integration.
I am creating a meatdata file using "dynamic data denormalization design pattern" and then trying to merge that metadata file with a file defined statically.

I am running into "exception Parsing error: Unexpected end of file in field # 1 of record # 9."

Dynamically created metadata file
========================
<?xml version="1.0" encoding="UTF-8"?>
<Record fieldDelimiter="|" name="TestMetadata" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\r\n" skipSourceRows="0" type="delimited">
<Field eofAsDelimiter="false" name="ChargeMaster" type="string"/>
<Field eofAsDelimiter="false" name="Customer" type="string"/>
<Field eofAsDelimiter="false" name="EAM" type="string"/>
<Field eofAsDelimiter="false" name="GTIN" type="string"/>
<Field eofAsDelimiter="false" name="Golden_Tax" type="string"/>
<Field eofAsDelimiter="false" name="SS_ITEM_XREF" type="string"/>
<Field eofAsDelimiter="false" name="Vendor" type="string"/></Record>

Structure Writer details which creates about Metadata file using Dynamic Data Denormalization Design Pattern
=================================================================
Header Mask
<?xml version="1.0" encoding="UTF-8"?>
<Record fieldDelimiter="|" name="TestMetadata" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\\r\\n" skipSourceRows="0" type="delimited">

Body Mask
\r\n<Field eofAsDelimiter="false" name=\"$Name\" type=\"string\"/>

Footer Mask

</Record>

ERROR LOG FILE from Metadata Merge design pattern
==================================

ERROR [WatchDog] - Graph execution finished with error
ERROR [WatchDog] - Node DATA_READER1 finished with status: ERROR caused by: Parsing error: Unexpected end of file in field # 1 of record # 9, value: 'SimpleDataParser does not provide raw record.'
ERROR [WatchDog] - Node DATA_READER1 error details:
org.jetel.exception.BadDataFormatException: Parsing error: Unexpected end of file in field # 1 of record # 9, value: 'SimpleDataParser does not provide raw record.'
     at org.jetel.data.parser.SimpleDataParser.parsingErrorFound(SimpleDataParser.java:405)
     at org.jetel.data.parser.SimpleDataParser.readField(SimpleDataParser.java:324)
     at org.jetel.data.parser.SimpleDataParser.parseNext(SimpleDataParser.java:275)
     at org.jetel.data.parser.SimpleDataParser.getNext(SimpleDataParser.java:170)
     at org.jetel.util.MultiFileReader.getNext(MultiFileReader.java:415)
     at org.jetel.component.DataReader.execute(DataReader.java:261)
     at org.jetel.graph.Node.run(Node.java:414)
     at java.lang.Thread.run(Thread.java:619)

Edited by: kkonada on Jul 2, 2012 2:49 PM
  • 1. Re: Metadata Merge for Joins --Unexpected end of file in field # 1 of record#9
    kkonada Newbie
    Currently Being Moderated
    issue Solved. Problem seems to be a missing 'line break' after each line in dynamic data denormalization design pattern graph

    Body Mask

    ==================

    "<Field eofAsDelimiter="false" name=\"$Name\" type=\"string\"/>*\r\n*"

    Source code from graph

    =========================

    <Node enabled="enabled" fileURL="${META_DIR}/TESTXREFMD.fmt" footer="</Record> " guiHeight="93" guiName="STRUCTURE_WRITER0" guiWidth="155" guiX="748" guiY="31" header="<?xml version="1.0" encoding="UTF-8"?> <Record fieldDelimiter="|" name="TestMetadata" previewAttachmentCharset="ISO-8859-1" recordDelimiter="\\r\\n" skipSourceRows="0" type="delimited">" id="STRUCTURE_WRITER0" mask="<Field eofAsDelimiter="false" name=\"$Name\" type=\"string\"/>*\r\n*" type="STRUCTURE_WRITER"/>

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points