SAP MII 14.0 SP5 Patch 11 - Error has occurred while processing data stream Dynamic Query role is not assigned to the Data Server

[former_member191528]

Hello All,

We are using a two tier architecture.

Our Corp server calls the refinery server.

Our CORP MII server uses user id abc_user to connect to the refinery data server.

The user id abc_user has the SAP_xMII_Dynamic_Query role.

The data server also has the checkbox for allow dynamic query enabled.

But we are still getting the following error

Error has occurred while processing data stream
Dynamic Query role is not assigned to the Data Server; Use query template

Once we add the SAP_xMII_Dynamic_Query role to the data server everything works fine. Is this feature by design ?

Thanks,

Kiran

[Former Member · Accepted solution]

Hi,

This feature is by design.

Anushree

[former_member191528 · Accepted solution]

Thanks Anushree !!

I thought that just adding the role to the user and enabling the dynamic query checkbox on the data server should work.

But we even needed to add the role to the data server.

Thanks,

Kiran