Skip to Content
0
Aug 09, 2016 at 10:55 AM

Scheduling Error for Web I report on BEx Query

99 Views

Hi All,

We have a Web I report created on BEx Query data provider .

A.While Scheduling ,default prompt value for report is 0111 (for example) only ,but why the scheduling getting failed every time with below error.


Error :: BW System BWP: Result set too large (900783 cells); data retrieval restricted by configuration (maximum = 900000 cells)



B.Moreover report has a prompt with default value (for example -0111) and data generated in the report with fields for 0111 only.

If we run the report with 0111 or some few values ,report was generated but If we run the report with all the prompt values,we are getting below error.

BW System BWP: Result set too large (900783 cells); data retrieval restricted by configuration (maximum = 900000 cells)


"Is there any configuration problem with Adaptive job server and Web I Adaptive processing server ?"


Kindly provide the solution to overcome this issue.


Note : 1. We can't reduce the prompt values ( all values should be selected )to over come this issue.


2.Global parameters i.e., increasing the cell size in BEx Query properties should be restricted.



Thanks

Ram

Attachments

Scheduling.PNG (7.2 kB)
BW Error.PNG (6.8 kB)