Skip to Content
0
Nov 07, 2012 at 09:16 PM

Error While Initial Filling of Aggregates

42 Views

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.