No more storage space available for extending an internal table (0IC_C03)

[Former Member]

Hi

We are using the standard solution for Inventory Management (cube 0IC_C03). When our
users run a query to see the stock of all our materials we get the error
message “No more storage space available for extending an internal table”. This
happens both in BEx web and in Analyzer. The query uses the non-cumulative key
figures so it is not possible to build aggregates as far I understand.  We also compress all requests when data is
loaded.  Is there a way to tune the query or the cube so our users can see the stock of all their materials without using
filters and running the query multiple times?

We only see this error using this specific cube. We have other large queries running on a
much bigger data volume that run fine without any errors.

We use BW 7.0 SP23.

Kind regards

Erik

[former_member21257]

Hi Eric,

Are you restricting on a time characteristic?

Do you have the latest FEP (FrontEnd Patch) level ?

Rgds,

Colum

[Former Member]

Hi Colum Cronin

Yes, we are on GUI and BEx 7.20 with latest patch level.

Erik

[former_member186445]

you could limit the number of fields displayed in the report...

does the query run long time or do you quickly have the dump?

[Former Member]

Hi M
Tibollo

The
query has only one characteristic plus two key figures. The query runs for
about 5 minutes and then it dumps.

Erik

[former_member186445]

do you have any idea about the total number of lines that would be in the output?

[Former Member]

The query  should deliver about 80 000 lines. We have other queries (on other cubes) that does this
without any problems.