Query error OLAP BO Universe

[Former Member]

Hello,

We are at BOXI 3.1 SP2. We have some BO universes on top of OLAP MSAS 2008 cubes.

Recently for some of our queries, we have started getting these intermittent errors - same error message all the time

"A database error occured. error text is "Failed to execute MDX query" Reason: the component Microsoft OLE DB provider for Analysis Services 2008 returned Server error( Server : the operation has been cancelled ) 
(WIS 10901)" 

The Cube folks have run some tracing on their side - but could not isolate any explicit clues as to what causes the query to error on BO side.

Has anyone seen something like this before? Your help would be much appreciated.

[Former Member]

Make sure you download and install the MSAS client tools on the BOE server. Your MSAS admin team will be able to help with this.

[Former Member]

Deepu,

We already have the necessary drivers on our BO servers. Do note that our errors are intermittent and for some queries. Rest of them run perfectly fine.

[Former Member]

Try enabling the trace as per the note below to get more info on the BOE side.

https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F6465...