on 02-05-2015 12:53 PM
Hi Experts,
We are receiving flat file with pipe delimited file from the source system.
First row Contains Header Data and from Second row onwards contains Record data.
Sender structure Receiver Structure
Invoice
RecordSet Invoice
RecordSet
Header Header
Batch_Date Batch_Date
Record Record
Field1 Field1
Field2 Field2
Field3 Field3
i defined FCC parameters as below
Document Offset 1
Recordset Name: RecordSet
Recordset Structure: Header,1,Record,*
Header.fieldSeparator:|
Header.endSeparator:'nl'
Header.fieldNames:Filler1,Filler2,Batch_Date,Filler3
Record.fieldSeparator:l
Record.endSeparator:'nl'
RecordSet.fieldSeparator:'nl'
Record.fieldNames:Filler, Field1, Filler2,Filler3 Field2.
But the Header is not populating in the inbound payload,only Record is populating, Due to that it is failing in mapping.
Error" Cannot produce target element /ns0:ConcurInvoice2/RecordSet. Queue does not have enougth values in context, Queue does not have enough values to generate Target structure".
Please help me to fix this.
Regards
Bhargava Krishna
Bhargava,
Document Offset 1, ignores first line of input file. Make it zero and try.
Also try Link
NameA.missingLastFields
If the inbound structure has less fields than specified in the configuration then the XML outbound structure is created as follows:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Bhargava,
Please set NameA.keyFieldValue.
"If you have entered a variable number of substructures under Recordset Structure, that is, you have entered the value* for at least one structure, specify a Key Field Name."
Please check help link.
Hi Bhargava,
Try NameA.additionalLastFields
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
71 | |
10 | |
10 | |
7 | |
6 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.