Question Re: Values missing in queue context in Technology Q&A

Values missing in queue context

sahana_ps — Tue, 06 Jan 2015 11:54:37 GMT

Hi All,

I have encountered this ERROR many times,but this time I am unable to figure out the reason behind this mapping failure.Below is my source structure image

I am getting ERROR as below

Cannot create target element /ns0:Messages/ns0:Message1/ns2:GLJournalsDataPost[2]/GL_Document/DocumentHeader/LineItem. 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

Here its not pointing to any particular field value.Many records are there with Header and LineItem details.If i test each record individually in ESR test tab it works but if i test all records at a time it fails with above error.Kindly need your help

Re: Values missing in queue context

AlexanderApel — Tue, 06 Jan 2015 12:10:56 GMT

Hi,

try Occurrences with 0..1. Then you can see your target message.

Regards,

Alex

Re: Values missing in queue context

Former Member — Tue, 06 Jan 2015 12:12:17 GMT

Hello Sahana,

I suppose here you are sharing your source structure,can you plz share your target structure as well.

As to just the occurrences.

Regards

Naveen

Re: Values missing in queue context

praveen_sutra — Tue, 06 Jan 2015 12:15:01 GMT

hi Sahana,

The number of entries in target getting created for LineItem is not the same as expected.

Yes its true that on checking on individual level it might not give error.

So you need to check what is the no of Lineitems getting generated with the context for target xml.

There might be not the right elements in each context so Please make sure you put proper context change and no of elements in total queue should be appropriate.

Please share your target structure and Mapping for better clarity.

Hope this helps.

thanks and regards,

Praveen T

Re: Values missing in queue context

sahana_ps — Tue, 06 Jan 2015 12:36:34 GMT

My Target structure and mapping to Lineitems looks like below :

Re: Values missing in queue context

praveen_sutra — Tue, 06 Jan 2015 13:21:56 GMT

hi Sahana,

Please check

1) if no of elements in office is equal to no of elements of LineItem by doing display queue.

both should be same.

2) if target Line elements generated is having same no of context change as the no of Line items to be generated in the target XML.

I know this is little complex but my suggestion would be put a [splitbyvalue] after formatbyexample that will give you a better understanding.

hope this helps.

thanks and regards,

Praveen T

Re: Values missing in queue context

sendhil_kumar — Tue, 06 Jan 2015 13:27:30 GMT

Hi Sahana,

The number of Line Items and Number of Values in Office should be the same. If you can see display queue in formatbyExample, you can identlify the difference.

Hope this helps.

---

Sendhil

Re: Values missing in queue context

former_member191435 — Tue, 06 Jan 2015 13:57:55 GMT

where is this office field..... in line items where it exactly coming...

Meanwhile you can do one thing...

Use mapwiddefault

Officefield ----> Map wid defalut ----> Remove context

Let me know still if u face an issue...

Thanks,

Sreenivas

Re: Values missing in queue context

sahana_ps — Wed, 07 Jan 2015 06:44:23 GMT

Hi all,

I am still facing same issue.

I checked number of Line Items and Number of Values in Office are same.

I tried adding Map with Default after office field ,still the same issue

Re: Values missing in queue context

former_member191435 — Wed, 07 Jan 2015 06:49:03 GMT

can you please show me your display queue....

Meanwhile use sort function to sort the values of office field and do the splitbyvalue change function...

Thanks,

Sreenivas

Re: Values missing in queue context

sahana_ps — Wed, 07 Jan 2015 07:01:31 GMT

Re: Values missing in queue context

sendhil_kumar — Wed, 07 Jan 2015 07:03:12 GMT

Hi Sahana,

The values might be same since, you have used split by Value (ValueChange), there could be two or more consecutive values of Office might be same. That will be the reason for this.

Sendhil

Re: Values missing in queue context

sendhil_kumar — Wed, 07 Jan 2015 07:11:44 GMT

Hi,

There is one less Line item here. That is throwing error here. Can you please provide one more screenshot showing Line item and Office in source structure?

Sendhil

Re: Values missing in queue context

former_member191435 — Wed, 07 Jan 2015 07:17:03 GMT

count no of line items and office fields first and let me know.....

as per ur screen shot no of line items 59 and office fields are 60...

Let me know on which structure this office field.

Thanks,

Sreenivas

Re: Values missing in queue context

sahana_ps — Wed, 07 Jan 2015 07:24:47 GMT

Both are same,since context change is added after formatbyExample ,its showing as 59 and 60

Re: Values missing in queue context

former_member191435 — Wed, 07 Jan 2015 07:33:50 GMT

can you please explain your scenario...

Do you want to create for one office field value to one kind of line items and one office field to oke kind of line items..

for one office field you need to create 1 generaldata post...

Try to use collapse context after formatbyexample for line items mapping and let me know...

please let us know

Re: Values missing in queue context

former_member191435 — Wed, 07 Jan 2015 08:01:04 GMT

please find the difference using collpase context and without collapse context after format by example...

Without collpase context it will crreate the no of line items that exists for first office field..

Withcollpase context it will create only the no of line items that we have the office field values...

Thanks,

Sreenivas

Re: Values missing in queue context

sahana_ps — Wed, 07 Jan 2015 08:43:53 GMT

Tried Collapse Context,no use.still the same error

Re: Values missing in queue context

former_member191435 — Wed, 07 Jan 2015 08:53:25 GMT

show me the error are you getting this error in lineitems field or root tag Lineitem error

Re: Values missing in queue context

sahana_ps — Wed, 07 Jan 2015 10:02:32 GMT

It's not for LineItems Field.Its for the root tag