Skip to Content

Values missing in queue context

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

Untitled.png (21.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

10 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 06, 2015 at 12:15 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 06, 2015 at 12:10 PM

    Hi,

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

    Regards,

    Alex

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 06, 2015 at 12:12 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 06, 2015 at 12:36 PM

    My Target structure and mapping to Lineitems  looks like below :


    Untitled.png (36.8 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Jan 07, 2015 at 06:44 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Jan 07, 2015 at 07:01 AM


    Capture.PNG (43.6 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Jan 07, 2015 at 07:24 AM

    Hi

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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Jan 07, 2015 at 08:43 AM

    Tried Collapse Context,no use.still the same error

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 07, 2015 at 10:02 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 07, 2015 at 10:17 AM

    Hi,

    Not sure if you added manually the first two tags e.g. Messages & Message1 when you pasted the test data for your mapping?

    Update:- I think my above question should not be the reason as I saw just now that you are able to see the values in display queue.

    Regards,

    Sarvesh

    Add comment
    10|10000 characters needed characters exceeded