Error consistency check in recordset structure

[former_member233165]

Hi Bloggers,

I am doing a Flat file to Proxy scenario with Multilevel records in file structure at sender side.

MessageType

     Recordset

         Root_1

               Name-1

               Name-2....

          Root-2

               Name-4

               name-5...

          Root-3

                Name-7

                Name-8...

I was done with all content conversion (attached snippets), but getting the below issue. can any one please identify the cause and tell me some inputs to resolve.

Error:- Conversation of content to xml failed at position 0: Java.lang.Exception: Error consistency check in recordset structure validation (line no. :2 missing structure(s) before type GRNT0)

Thanks in advance. 🙂

Regards,

Dileep

[former_member233165 · Accepted solution]

As per my test file, there was a space after GRNT0 & GRNT1. So, i included that Space in the keyfield length.. It's working fine now..

So the content conversion is like this..

GRNT0.keyFieldValue = GRNT0 , keyfiledlength = 6

GRNT0G.keyFieldValue = GRNT0G, keyfieldlength = 6

GRNT1.keyFieldValue = GRNT1 , keyfiledlength = 6

GRNT1R.keyFieldValue = GRNT1R, keyfieldlength = 6

Thanks,

Dileep

[manoj_khavatkopp]

Can you please provide the screenshot of FCC for  GRNT0G

[former_member233165]

Hi Manoj,

Please find attached the FCC snippet for GRNT0.

Thanks,

Dileep

[former_member186851]

Try adding this NameA.lastFieldsOptional yes.

[former_member233165]

Raghu, i was already added this, but no luck. 😞

[manoj_khavatkopp]

Dilip need screenshot for GRNT0G not GRNT0

[former_member233165]

Hi Manoj,

please fin the below snippet for the same.

Thanks,

Dileep

[former_member233165]

Sorry, please find the original snippet of GRNT0G here..

[manoj_khavatkopp]

My guess is this error is due to conflict in the key of GRNT0G and GRNT0

in brief :

GRNT0.keyFieldValue = GRNT0 , keyfiledlength = 5

GRNT0G.keyFieldValue = GRNT0G , keyfieldlength = 6

Now in you input file you have data like :

GRNT0GRADES ........so on.

Now for this line matches Both the key-field value, may be this is causing the issue.

Just to confirm  try this:

GRNT0.keyFieldValue = GRNT0 , keyfiledlength = 5

GRNT0G.keyFieldValue = ABCDEF, keyfieldlength = 6

and in the input file replace GRNT0G to ABCDEF in the second line .

Try this and let us know what is the outcome.

Br,

Manoj

[former_member233165]

Hi Manoj,

Thanks for the suggestion 🙂

It worked when i tested with some Dummy names.. as like you suggested. But my concern is.. I am getting field names same as first and second records with different data as like below snippet.. How can i pass them thru.. Please suggest..

Thanks,

Dileep

[former_member186851]

Hello Dilip,

Check the below discussion and try accordingly.

[former_member233165]

Hie Raghu,

Thanks for your quick response, I was configured all the content in the FCC level as per the above thread. But still facing the same issue.

Any more suggestions plz.

Thanks,

Dileep

[former_member186851]

Hello Dilip,

Then it could because of less characters in the incoming file,Check the length with the length you configured in the FCC.