on 09-11-2008 8:33 AM
Hi all,
I run a WebI query against BW 7 (XI3.0) and it display the following errors:
MDDataSetBW.GetCellData No more storage space available for extending an internal table. (WIS 10901)
To me it seems like a database resources issue. So how can we further troubleshoot this?
Or is there any performance tuning can be made on BO side?
Regards,
Derek
Hi Derek,
Means if you include all the items into the Web Intelligence query then they will retrieve data and based on the error message it is pretty clear that you are asking for too much data and running most likely out of memory in the backend.
Try to have less dimensions in the query panel and you will have no error, remember this is not an OLAP tool, the WEBI converts the query to MDX and obtain all the information in WEBI to create the microcube, if you have less dimensions the microcube is smaller and the data you need to retrieve from BW is smaller too.
Best regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In the BW OLAP Universe the Row Limit was set to 5000 rows as default. Try by increasing the row limit to get the data
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
you asking for too much data. keep in mind that the Web Intelligence query panel is what you asking for - not the Web Intelligence report.
ingo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
There is a limit of 1 million cells, maybe that is your problem. Also if you have memory problems in SAP system, you will probably find a dump in ST22. If it is really a memory problem, your system administrator will know what to do. Also you can test your MDX statement in SAP with transaction code MDXTEST.
Hope this helps ...
Luc
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Roland,
Thank you for the update but I could not fnd the SAP Note ID 1032461. Could you please provide me a proper place I can look for the note ID or please check with the Note ID if this is the right one.
I am also facing the same issue at my end and am stuck for a few reports due to this.
Thanks.
Sumeet.
Dear Sumeet
I have found the note on the Service Market Place https://websmp210.sap-ag.de/notes
Regards
Roland
HI,
Connect to BI7 and call transaction DB02, check tablespace size and %use.
Regards,
Alexis
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.