Again SAP_XMB_PERF_AGGREGATE

[rainer_hbenthal]

Hi,

i need to ask again about this jiob cuase this is runing for over two days now...

i implemented the index mentioned in the sap notes. Still the job is running and running.

We have round about 18.000.000 entries in SXMSPFRAHW, and the job log starts with

1800 aggregates so far

now we have

75.000 aggregates so far.

What does that mean? Is this aggregated in packets of 75.000 now or are only 75.000 out of 18.000.000 rows aggregated?

Can somebody send me an extraction of his joblog and the number of rows he has in SXMSPFRAWH?

Thx in advance

[former_member334189]

Dear Rainer,

as far as I understand you have applied SAP Note 1083220, but the result did not turn out satisfactory.

The algorithm of data aggregation has been replaced as of XI3.0 SP21 / PI7.00 SP14 / PI7.10 SP4, where the new algorithm has proved to result in a tremendous speedup. This fix is available for prior support package levels as a pilot implementation per SAP Note 1082836. SAP needs to check the affected system beforehand to ensure that the correction does resolve the issue. Please do not apply this fix without prior consultation of SAP.

Kindly open an OSS message at BC-XI-IS with reference to this thread and demand this ticket to be forwarded to Development Level straight away. I will take care of it and carry out a specific check in your system.

Best regards,

Harald Keimer

XI Development Support

SAP AG, Walldorf