cancel
Showing results for 
Search instead for 
Did you mean: 

File Content Conversion File-File scenario

Former Member
0 Kudos

Dear experts,

I have been tweaking with file to file scenario where a simple file goes in source as text delimited and comes out in target as xml.

I know ,i finally get my scenario get working with these settings :

ROOT.fieldSeparator ,

ROOT.fieldNames Store_Id,TRDT,SKU,SALE_RETURN,PRICE_OVERRIDE,PROMOTION_NUMBER,PROMO_DETAIL_ID,MIX_MATCH_NUMBER,DISCOUNT_ID,QUANTITY,EXTENDED_SELLING_PRICE,EXTENDED_ORIGINAL_PRICE,DIFFERENCE_PRICE

ROOT.fieldContentFormatting trim

ROOT.endSeparator 'nl'

ROOT.missingLastfields add

ROOT.processFieldNames fromConfiguration

ignoreRecordsetName true

Now my question is where i can find all properties that are probable in ROOT.Other thing is  i kept on getting mapping related errors until i reached

at this stage of properties definition.But there was no tracking as of why i got that error.The error was :

Mapping "http://TPOCTEST_SFILE/OM_TPOCTEST" failed to execute: MappingException: Runtime Exception when executing application mapping program com/sap/xi/tf/_MM_TPOCTEST_; Details: com.sap.aii.mappingtool.tf7.IllegalInstanceException; Cannot create target element /ns0:MT_TPOCTEST_T/Record. Values missing in queue context. Target XSD requires a value for this element, but the target-field mapping does not create one. Check whether the XML instance is valid for the source XSD, and whether the target-field mapping fulfils the requirement of the target XSD

I resolved once i made settings on top but this was only a hit and trial.I dont know what actually was the reason behind this error.

I also used Test option of mapping and found things working.

Accepted Solutions (0)

Answers (1)

Answers (1)

Ryan-Crosby
Active Contributor
0 Kudos

Hi Aditya,

That error indicates that when you were facing problems with your FCC the system did not generate XML that worked with the mapping that you have OM_TPOCTEST.  The error is showing that you have a target node named Record which I'm guessing is set to 1...unbounded but your FCC did not generate XML that would map in such a manner that 1 or more nodes named Record would be created in your target message.

Regards,

Ryan Crosby