The MDAS service encountered an error.

[Former Member]

Hi Experts,

I have a BEx Query. On this I have created an Analysis Work Space in BO. I have one system for both (Dev & QA) in BO.

The Analysis Work Space query is executing without error in BO Dev, but it is throwing below error for QA query:

The MDAS service encountered an error.

Failed to execute getRepresentation() because the query state [USER_NOT_AUTHORIZED] is invalid. : com.businessobjects.multidimensional.services.MdasRuntimeException: Failed to execute getRepresentation() because the query state [USER_NOT_AUTHORIZED] is invalid.

I have gone through so many SDN topics related to this. But couldn't get much info on this.

Note: The query doesn't have any calculation.

Please suggest.

Best Regards,

Niranjan

[Former Member · Accepted solution]

Hi Niranjan,

BW is throwing this error most probably, you might need to check bw side.

This might help you

[Former Member · Accepted solution]

Hi Sarhan,

Thanks for the early reply.

I do not have any authorization variable or any authorization info object in my query.

Regards,

Niranjan

[Former Member · Accepted solution]

So you are sure that any characteristics is not marked as Authorization related.

If this is like that, let's wait for others to respond.

[Former Member · Accepted solution]

Hi Sarhan,

The issue got resolved when my Basis security team has given the RSECADMIN authorization to the test user id.

Thanks and Regards,

Niranjan Chechani