on 03-10-2015 12:18 PM
Hello BW Experts,
we have problems with the activation of one DSO in our system.
Our System is a SAP BW 7.40 SP04.
There has been an error a few months ago, but it was just found now. This results in a alot of requests which have to be activated again.
For the daily load/activation of this DSO, BW reaches the limits for activating requests.
I found this formula which shows the limits:
<Activation Packages> = <Numer of Requests> * <Sum of all records of the requests> / <Package Size of activationsteps>
Current Values: 698 Requests * 172.632.109 records / Package Size 20.000 (Standart) = 6.024.860
-> Max Activation Packages are 100.000
Therefore we tried to reactivate the requests manually in very small packages. (< 3 Request), but here we get the following errors:
RSODSO_TOOLS120: Aggregation behavior of InfoObjects could not be read
We found the SNote 1936995 - P11; DTP: ERROR DTP deletes RSODSACTUPDTYPE entries and also already implemented it.
Unfortunately this did not solve the problem.
My concerns are that this error already deleted some entries in the table RSODSACTUPDTYPE and the data in the DSO are corrupted.
Thanks in advance for your help.
Best regards
Christian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Roland,
thanks for the help! The first Note 1938958 seems to be not released so far.
Is the Problem with deleting the Aggregation behaviour solved with Note 1949141 or does Note 1936995 already could solve this?
Could you also please describe how to re-create the missing rsodsactupdtype entries manually and if it is worth the effort it takes to re-create about 700 Request entries?
BR
Christian
Hi Christian
Whoops sorry. Must have copied the wrong one. The correct one is 2065853.
Only the entries should be recreated which are missing from rstosdsactupdtype. If no requests were activated yet, the best would be to delete the non-active requests and reload them after the suggestions of the note above.
I know, for ~700 requests this might take long, however this would be the best and safest way.
To recreate the entries you can copy already existing requests with an ABAP program or with a database script.
br
Roland
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.