cancel
Showing results for 
Search instead for 
Did you mean: 

The number range object does not exist for aggregate

petr_halamicek2
Explorer
0 Kudos

Hi all,

I have a trouble with aggregates activation and filling.

In daily process chain we have program SAP_AGGREGATES_ACTIVATE_FILL for aggregate filling.

The filling of aggregates which belong to one particular cube fails everyday with error message "The number range object does not exist".

What is interesting when I manualy select "repeat" on the process chain step which failed, the aggregate is filled without any error.

I suspected that number range buffer could be an issue and therefore I increased number of numbers in buffer in SNRO (buffer set up to 500).

I've checked a table RSDDIMELOC and found all corresponding number ranges "BID*' for the problematic aggregates and increased the buffer.

But unfortunatelly it didn't help. It seems that number ranges for aggregates are generated at the moment when aggregate is filled.

It means that the setting I did yesterday for existing number ranges (from table RSDDIMELOC) is not valid today. Today I can see for the same aggregates new number ranges specified in this table.

We are on BW 7.0 version, Support package 31.

This problem started when we migrated from MSSQL database to ORACLE last week.

Any idea is very welcome.

Thank you.

Accepted Solutions (1)

Accepted Solutions (1)

petr_halamicek2
Explorer
0 Kudos

HI Guys,

just a short feedback. Problem is caused by Oracle setting for parallel data processing.

Workaround in BW can be setting in RSBATCHPARALLEL table.

For aggregates I set up AGGRFILL with 1 parallel process.

This setting solved my problem.

We used to have 2 parallel proccesses set up in this table for aggregates.

I don't see any decrease in performance after this setting.

Regards,

Petr

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Petr,

Sorry my answer might be lame. Did you try RSRV?

Thanks,

Krishna.

petr_halamicek2
Explorer
0 Kudos

Hi Krishna,

Yes I tried the RSRV transaction.

Thanks,

Petr

Former Member
0 Kudos

Hello Petr,

Please review these knowledge base article and follow the solution part:

1020812 - Number Range Interval Missing

310751 - Number Ranges for Active Characteristics are Missing

Hope it helps, br, Andras

petr_halamicek2
Explorer
0 Kudos

Hello Andras,

thank you for your answer. Unfortunatelly it didn't correct my problem.

I implemented everything from the 2 notes above but the aggregates filling and activation is still failing.

I wanted to be sure that no number range is missing for any characteristic and therefore I run the RSD1 number range check for all characteristics. This step did not identify any issue.

If you or someone else has idea how to solved this issue, it would be very appreciated.

Thank you.