Database error occured;database error text is:Error in MDDataSetBW.GetCellData;Time limit excede:(wis 10901)

[former_member221192]

hi,

While refreshing webi report following error is coming..

Database error occured;database error text is:Error in

MDDataSetBW.GetCellData;Time limit exceeded..(wis 10901)

plz help me,,find the screen shot of error..

[sateesh_kumar1]

Hi Ganapathy ,

I guess your error is related to BW authorizations.

for testing apply that user authorization as a filter in Bex and check.

[Former Member]

Check the universe parameter for query run time restriction and try increasing that parameter to see if that makes any difference..

[former_member221192]

hi,

Query run time resrication removed,,still that error is coming..

[former_member189638]

How much time does it take in BEx to show the output and how much time does is it run on WebI before showing this error?

[former_member221192]

40 minutes webi report is running ,after that error is showing....

[IngoH]

Hello Ganapthy,

have you actually tried to run the BEx query with all elements that are showing in the Web Intelligence report placed in the ROWS to execute the report ?

regards

Ingo

[IngoH]

Hello,

are you able to execute the BEx query with all the elements that are used by Web Intelligence set into the rows in transaction RSRT?

regards

Ingo Hilgefort

[former_member221192]

yes..

[IngoH]

Hello Ganapathy,

when you execute the BEx query in transaction RSRT did you place all elements that are used by the Web Intelligence report in the Result Objects Panel into the rows of the BEx query BEFORE you execute the BEx query ?

Which version of SAP BusinessObjects are you using ?

I assume you use the direct connection to the BEx query correct ?

Ingo

[former_member221192]

Hi,

Top of bex  i am Creating universe,that universe i am using in webi report..

version:SAP Bussiness Object XI 3.1

[IngoH]

Hello Ganapathy,

when you execute the BEx query in transaction RSRT did you place all elements that are used by the Web Intelligence report in the Result Objects Panel into the rows of the BEx query BEFORE you execute the BEx query ?

regards

Ingo

[Former Member]

Hi Ganapathy,

please check the below link, hope it will help you.

http://www.forumtopics.com/busobj/viewtopic.php?t=47074&highlight