The number range object does not exist for aggregate
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.
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.