Error when activating aggregates - BI NW04s SPS10

[Former Member]

Hello experts,

I'm facing an error each time I try to activate an aggregate in our recently upgraded sandbox (BI NetWeaver 2004s) with SPS 10. The short dump is of type MESSAGE_TYPE_X.

It says: System error in program SAPLRSDDS and form RSDDS_TMP_NAME_GET

It seems that this function module (RSDDS_TMP_NAME_GET) is the reason behind the short dump. Any clue?

[Former Member · Accepted solution]

Hi Ali,

Kindly check any attribute hierarchy change run is running if not ,kindly try activating it once again.

Regards

KK

[Former Member]

Sanity Check -

<b>Aggregate Check tool -</b>

goto--> "Selection of Automatic Aggregate Check Mode" in the <b>Extras</b> menu in the Maintenance for Aggregate screen, allows you to schedule these checks automatically within the aggregate maintenance processes. This option is not enabled by default, as the additional execution time required by these checks affects performance.

The modes here are listed by their text values, not by C, Q, or A. Then choose when you want to execute the check. Be aware of what else is happening when you run these checks, especially with complex, parallel loading scenarios. You also have the option to specify execution after a change run or roll-up completes, or after a data deletion. This ensures that your aggregates stay consistent once you've deleted data.

Alternatively ..

you can also use

ABAP program RSDDK_CHECK_AGGREGATE, and therefore it can be executed in the foreground or background.

I would advocate to deactivate and activate the aggregates again to check for any inconsistencies.

Hope it Helps

Chetan

@CP..

[Former Member]

Thanks Chetan,

The problem is that these aggregates couldn't be created in the first place because of the short dump I'm getting everytime I try to activate them. I tried on various cubes and I always get the same error. The check on these aggregates before activation is ok. I'm thinking of that this is a bug.

[Former Member]

This issue was resolved by changing the intervals of Number Range Object RSDDAGCUBE in transaction SNRO. The intervals should be set to 100000 - 199999 with Current Number 100000.

I'm putting this on this thread so people who are searching on such a problem can get to this resolution.

Thanks.