Skip to Content
0
Sep 18, 2014 at 08:36 PM

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

65 Views

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