Skip to Content

Error While (Initial) Filling Up of Aggregates

Hi All,

We are encountering TempSpace (PSATEMP) error while filling up the aggregate created on top of GL Total cube. As in case of initial fill it is considering all data from the base cube which is around 100 Million.

We increased the TempSpace to an extent that we cannot go any further. Also there is no standard option available where we can select reuests for initial filling.

Error:

SQL Error: 12801

we decrease the block size form blank (default 100,000,000) to 1,000,000 in SPRO settings

 SAP Customizing Implementation Guide  SAP NetWeaver  Business Warehouse  Performance Settings  Parameters for Aggregates  .

but still it is consuming the entire TempSpace also there is no change in the backend SQL runnning in Oracle side (we were expecting some inclusion of wher claws there)

As we are out of option to fill this aggregate, we look forward to SAP SDN community to help us out.

Note:- The aggregate is system proposed and the Document No is included in that.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Nov 08, 2012 at 10:53 PM

    Since this is a question about BW, it belongs in the BW space (called SAP Netweaver Business Warehouse) and not the Data Warehousing space. I've moved the thread, but please use this space for these types of questions in the future.

    Regards,

    Ethan

    (moderator)

    Add a comment
    10|10000 characters needed characters exceeded