cancel
Showing results for 
Search instead for 
Did you mean: 

OLAP Query not running

HariCS23
Contributor
0 Kudos

Hi Gurus

I am getting and exception while executing a MDX Query through OLAP Query .

All my queries were running properly until yesterday from OLAP query as well as through MDXTest TCode .

But today it gives me an excetion

com.sap.lhcommon.webservice.SoapException: The XML for Analysis provider encountered an error

I know it is generic error description for any kind of error back from BW but here situation is

My query is running from MDXTest with out any problem .

Any ideas on this like where to see the logs..etc?

Thanks in advance.

-Hari

Accepted Solutions (0)

Answers (1)

Answers (1)

HariCS23
Contributor
0 Kudos

It is solved.

It was because User which we used for configuring data server doesn't have enough roles.

I have created a new connection with my user name and it works .

But interesting thing here is, it was working with the system user i was using with old roles and security team claims that they haven't changed any role for that user . But last day that user locked because of pswd expriration and it was unlocked .After wards my OLAP Queries are stopped working .

And its really pain with out getting proper error message from OLAP Query.

From my experience to debug these kind of errors:

Make sure your MDX query runs from MDX Test .

If it runs successfully, then we can narrow down to the connection setting in MII .

Thanks

Hari