cancel
Showing results for 
Search instead for 
Did you mean: 

memory-intensive consumption executing a webi document

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Ingo,

We're working with SAP BO XI 3.1 SP3 but not with SAP BI 7.01 SP5. Anyway, we tried launching webi document with query stripping checked. As was expected we obtain the same error.

We'll work with our Base team colleagues to plan the upgrade to SAP BI 7.01 SP5.

Thanks a lot for answer so quickly.

IngoH
Active Contributor
0 Kudos

Hi,

you should move to SAP BusinessObjects XI 3.1 SP3 or higher, SAP BW 7.01 SP05 or higher and you should also make use f Query Stripping which is part of SP3.

Ingo