cancel
Showing results for 
Search instead for 
Did you mean: 

SQL query linked to Repeater in MII BLS

350

Setup a BLS in MII 15.2 with sql query, Repeater and PAPI. Expected result of query is a single column of numbers: 1.00, 2.00 etc.The MII transaction is executed through a hook inside SAP ME using the MII_TRANS_EXT hook.

The query results is linked to the repeater using queryname.Results{/Rowsets/Rowset/Row}

This sql query - Repeater combination has stopped functioning now.. it did function correctly for a while.

Also, when the BLS transaction is executed directly from MII (after removing the INPUT_XML variable assignments), the query functions seamlessly along with the repeater..but the moment I run the BLS using the MII_TRANS_EXT hook, it fails.

Is there any authorization issue which prevents the sql query results from transferring information to the Repeater?

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

This issue got solved, the query was looking up a Operation number inside ME with a version 'A' however it was being stored in the table with '#', so the query itself didn't fetch results to be fed into the repeater.

Answers (1)

Answers (1)

agentry_src
Active Contributor
0 Kudos

There should be no authorization issues within the BLS from the Query Template to the repeater.

I did not understand what you mean by removing the INPUT_XML variable assignments. Why would you need to do that (and what kind of data is contained in the INPUT_XML?

Can you provide a screenshot of the transaction? Also are you working with an xacute query to call the BLS or is this a direct call?

Regards, Mike