FCC recordset error

[former_member564496]

Hi All,

I have completed the config for scenario File to IDOC scenario on PI 7.4

I am using FCC in my sender communication channel. The structure of the source message type is as below:

DT_xxxx

   |__Header

           |__Field1

           |__Field2

   |__LineItem

           |__Field1

           |__Field2

The scenario is working fine when both the records(Header, LineItem) are present in the input file. But when the input file contains only Header and Line item record is blank i am getting the error in sender channel as: Conversion of file content to XML failed at position 0: java.lang.Exception: ERROR consistency check in recordset . The requirement is that even if the LineItem record is blank the IDOC should get posted.

The occurence for Header is 1 and LineItem is 0..999.

Below are the FCC parameters which i have configured in sender channel:

Recordset structure :Header,1,LineItem,9999

ignoreRecordsetName = true

Header.fieldSeparator

Header.fieldNames

Header.endSeparator

LineItem.fieldSeparator

LineItem.fieldNames

LineItem.endSeparator

Note: I cannot use Key values as there is no field in data that can be used as key.

Request you all to please give your valuable suggestions on how this can be achieved.

Thanks and Regards,

Diksha

[maheswarareddykonda]

Diksha,

Note: I cannot use Key values as there is no field in data that can be used as key.

key field is mandatory , where ever structure is not flat.

so ..you can just add key field in structure your own. there must be identifier for Header and lineitem

[former_member564496]

Hi,

After adding the key field in the structure, as  the input data is not containing key values the message fails.

[maheswarareddykonda]

Diksha,

Adding key mean, we need to data gainst that key so that data will split to header and lineitem.

also data which shared is not proper..can you please share exact data which contains header and lineitem data..and let us know which data would be as a header and which data would be lineitem?

[suman_saha]

Hi,

As a key, you may put a header field.

Suman

[former_member564496]

Maheswarareddy,

The Line one in the data is Header and line two is Line Item.

Line Item is coming as blank and hence I am facing the issue.

[maheswarareddykonda]

ok, how you will decide first line is header and second line is line item..?

are you getting only two lines every time and first is header and second line is line item?

[former_member564496]

Header is manadatory occurence is 1 and will always occur.

Line item can occur maximum upto 999 times.

[maheswarareddykonda]

Diksha,

I am asking in file how you will decide which line is belongs to header and which line belongs to line item. for example,

ABC,field1,field2,field3...

xyz,field1,field2,field3...

xyz,field1,field2,field3...

here we can say ABC record is header and xyz record is lineitem.

same like that you also can see some identifier in your test data , that  identifier you can give keyfieldName in channel configuration. one for header and one for lineitem.

[sahithi_moparthi]

Hi,

Try by changing  details as below.

Recordset structure :Header,1,LineItem,*

Also change value from ascending  to variable.

[former_member564496]

Hi Sahithi,

Thanks for your suggestion. When i tried with *, i am getting the error as:

Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found:

Mandatory parameter 'xml.keyfieldName': no value found

[sahithi_moparthi]

Hi,

Can you please share sample data ?

[former_member564496]

Hi

PFB input data

[suman_saha]

Hi,

Use the parameter ignoreRecordsetName

Suman