Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

memory-intensive consumption executing a webi document

Hi Experts,

When we execute a Webi document in an OLAP universe with a BexQuery on top at BW side we obtain following error message:

Error in MDDataSetBW.GetCellData. No more storage space available for extending an internal table.. (WIS 10901).

This execution should return aprox. 200 thousand rows. We are querying 10 dimensions and 2 ratios from universe. This 10 dimensions are 10 navigational attributes at BW side. There is an aggregate defiined in the cube that includes all these navigational attributes. When we use 8 or less dimensions the webi document finish successfully.

In ST22 we obtain a TSV_TNEW_PAGE_ALLOC_FAILED error because the process consumes 7GB of main memory.

We catch MDX instruction generated by webi document using RSTT:

SELECT {

[Measures].[4K1BCOQ4DGNEJQT7PX6JVDN4T],

[Measures].[4K1BCOXSWF942DCNVR8W5FLUL] }

ON COLUMNS ,

NON EMPTY

CROSSJOIN(

CROSSJOIN(

CROSSJOIN(

CROSSJOIN(

CROSSJOIN(

CROSSJOIN(

CROSSJOIN(

CROSSJOIN(

CROSSJOIN(

CROSSJOIN(

CROSSJOIN(

[0MATERIAL__ZBRANDTYP].[LEVEL01].MEMBERS,

{ [ZBOCALID__ZBOCALYFL].[X] } ),

[0MATERIAL__ZPURGRFAM].[LEVEL01].MEMBERS ),

[0MATERIAL__0RPA_WGH3].[LEVEL01].MEMBERS ),

[0MATERIAL__0RPA_WGH2].[LEVEL01].MEMBERS ),

[0MATERIAL__0RPA_WGH1].[LEVEL01].MEMBERS ),

[0CUSTOMER__ZDCHNG2ZT].[LEVEL01].MEMBERS ),

[0CUSTOMER__ZDCHNG1ZT].[LEVEL01].MEMBERS ),

[0CUSTOMER__ZRTPLTPZT].[LEVEL01].MEMBERS ),

[ZPRECIOAP].[LEVEL01].MEMBERS ),

[0CALMONTH].[LEVEL01].MEMBERS ),

[0SALESORG].[LEVEL01].MEMBERS )

DIMENSION PROPERTIES

[0CALMONTH].[40CALMONTH2],

[0SALESORG].[50COMP_CODE]

ON ROWS FROM [ZBORTSA01/ZBORTSA01_02]

SAP VARIABLES

[!V000002] INCLUDING [0CALMONTH].[201101]

[!V000006] INCLUDING [ZBOFNCM].[MESANT]

We are working with:

SAP BOE XI 3.1 SP3 FP2

SAP BI 7.00 (SAPKW70021)

If it is possible can someone please let me know how can i resolve this problem? What alternatives do we have? Upgrading to SAP BI 7.01 SP5 can solve the problem?

Best Regards,

Carles

Former Member
Not what you were looking for? View more on this topic or Ask a question