Skip to Content
avatar image
Former Member

Optional Recordset substructure in FCC

Hi Experts,

I am very new to SAP PI and need help to resolve issue related to  FCC in  sender file adapter.

We have requirement as below :

file structure will be like

NameA   A  1111 2222 33333

NameB   B  1111 2222 33333

NameC   C  1111 2222 33333

NameD   D  1111 2222 33333

NameA   A  1111 2222 33333

NameB   B  1111 2222 33333

NameD   D  1111 2222 33333

Substructure NameC is optional, if there is any value then we need to use it otherwise ignore it.

I have mentioned below values in parameters.

NameA.keyFieldValue

NameA.fieldFixedLengths

NameA.endSeparator

NameA.fieldNames

In Recordset Structure : NameA,1, NameB,1, NameC,*, NameD,1 

All is working fine when we have value  for substructure NameC but when it not there is file then getting error as below :

Conversion of file content to XML failed at position 0: java.lang.Exception: ERROR consistency check in recordset structure validation (line no. 4: missing structure(s) before type 'NameA').


I have gone through multiple blogs but not got any resolution for this specific error.



Warm Regards,

Naveen K


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 18, 2015 at 04:48 PM

    Hi,

    Can you please share your structure.Could you please let us know what is the field separtor between the fields.It seems field separator paramter is missing.As per the above ex:It looks like the separator is space.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Vishnu,

      It is mentioned as  0 : unbounded.

      We are just not able to make this L11_DL as optional structure.

      Warm Regards,

      Naveen K