Skip to Content
author's profile photo Former Member
Former Member

Multiple records error in Xacute Query, xMII 12.0

Hi Gurus,

I am on xMII 12.0. I have a transaction where i am getting multiple line items from a BAPI is ECC system & want to display these on to the browser. I have an output parameter where I am passing all the values. In my tracer I can see all the values of the ouput parameters correctly being recieved from the bapi.

I have created a Xacute Query to display my transaction output on the browser & linked it with my transaction. I am expecting to get the same output as i get in the tracer on the IE screen but i do not get it. The output parameter gives me the values of the last record only. But on individually executing the transaction the same variable gives me all the values.

Can someone help please.

Thanks & Regards

Abhik

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 11:39 PM

    Hi

    I have gone through your post and I think that the info provided by yu is not sufficent to answer yur question exactly but i would suggest yu the following solutions :-

    1. It may be the case that yu are not looping on the Response XML from the BAPI. You need to loop on the repeating node of the Response XML of the BAPI and on each loop yu need to append the record read to a xMII Output XML document using Row structure. Finally Yu can assign the document to the Output variable.

    2. Check for the type of Output Variable. I guess that it's String type. In that case, convert it to xml type.

    Hope it helps.

    Amit

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2008 at 08:14 AM

    Thanks guys for the extended help,

    My transaction has the following steps in sequence.

    1. JCO Interface to get details of BAPI (working fine)

    2. Repeator looped on the response table with data.

    3. Tracer on which global variable is displayed. In the Outgoing tab of the likns editor i am filling in the global variable (I have tried bothe types XML & String)

    The records are getting displayed correctly on the tracer message but when i link this to a Xacute Query then i am getting only the last record. I understand that the variable is getting overwritten.

    Amit I'll try to append all values to the row structure & then assign it to the output parameter of type XML. As from futher workings & your comments it sounds logical. I understand that the Xacute Query executes the whole transaction & gets the final value on to the screen so i get the last record only & this should solve when i always append the global variable in my transaction to the rowset. I will award the points once i finish the exercise. Logically i guess this should work.

    Thanks a lot for you help guys.

    Abhik

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 08:54 PM

    Abhik

    Is your output parameter type XML?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2008 at 03:17 PM

    Hi Amit,

    Thanks so much, you suggestion really helped, I have given you full points also. 😊

    However I have another question which is about the performance & will post it in another link.

    Also thanks Christian for the help link.

    Everyones help is appriciated.

    Abhik

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.