cancel
Showing results for 
Search instead for 
Did you mean: 

How do I reset RSMDATASTATE after a load to a Datamart is decommissioned?

2023_kurt
Explorer
0 Kudos
162

Here is the context and background for my question:

The System is BW 7.52 on Hana. I have a base cube (ZBase_CB1) that was used as the source to feed a secondary cube (ZCO1234). The feed was performed via a delta DTP, but now that load has been decommissioned. I cannot delete ZCO1234 because the static data might be needed. But the problem is such that I cannot compress ZBase_CB1 because the system tells me all datamarts have not been updated.

Request 7,563,690 not datamarted to all data targets. Please do this first.

Message no. RSM1548

What is the proper method to remediate this issue permanently?  In my sandbox and development instance, I can update the DMALL field of RSMDATASTATE which seems to fix the issue, but I cannot do the same in a closed system. 

 

View Entire Topic
Savio_Dmello
Active Participant

When you say "load has been decommissioned" Can you elaborate? Do you still have transformation? if yes, you can create a new DTP or use existing DTP to perform an init without data transfer by setting the DTP processing mode as  'No Data Transfer; Delta Status in Source: Fetched'. Once you execute the load with this setting, the DataMart criteria will be fulfilled and you will be able to compress the request in source. Manually updating the DMALL field of RSMDATASTATE is not recommended.   

roland_szajko
Product and Topic Expert
Product and Topic Expert
0 Kudos

This might be also helpful:

  • 2121399 Compression of InfoCube requests not possible
  • 1450242 P24: Remove DTP from delta administration; logical deletion
2023_kurt
Explorer
0 Kudos
The cube and load mechanisms that were decommissioned were deleted from the system, thus leaving a void.
roland_szajko
Product and Topic Expert
Product and Topic Expert
0 Kudos
I would suggest to go through the KBA-s which I provided earlier.