Getting error while refreshing the Webi report

[Former Member]

Hi Guys,

I am getting error, while refreshing Webi reports. Error like:

A database error occured. The database error text is: Error in MDDataSetBW.GetCellData. Time limit exceeded.. (WIS 10901)

Could anyone please reply.

Regards,

[Henry_Banks]

Hi,

If it's not the universe limits, then I think you've hit the "MDX result contains too many cells" (more than 1million) problem.

So, I suspect a long running query, no filters/variable restrictions, and You've probably got a dump in ST22.

I don't know what BW you have, but if it is BW 7, do you have Enhancement Pack 01 and SP05<->10 ?

You should check out all the latest corrections from component BW-BEX-OT-MDX

the final proof of the pudding would be to enable MDA / SOFA log , capture the MDX SELECT statement and test it in BW MDXTEST - i bet you get the same error there.

regards,

H

[Former Member]

Make sure the ODBC connections are named exactly the same. "MS_ACCESS" is not the same as "MS_Access" when using DSNs for connections

Check it once.......

[Former Member]

Thanks for reply, I am using backend BW (BEx query).

Regards,