Solution to continuous yellow light during DTP loading/ODS Activation

I was lucky to have met both of them. Fortunately, the following two solutions helped me and shared them with you:

 

Start with activate:

Activation of M records from datastore object terminated

 

Q:

 

I am trying to activate the records in my ODS and getting the error above. I have been able to successfully load and activate initiate request, but now am having trouble with the activation. the record count hasn' t increased, and I have looked at the setting in rsodso_settings.

 

In the monitor, if I look at the status tab, it is green and show updated successfully. however, if I look at the details tab, this is where I see the error. prior to the activation error, I see a couple Red entries that read-"process 000065 returned with errors ". then, "process bctl_d4f7r7keuz78fxj3mo1rxm4q4 cocould not be terminated. terminate manually ".

 

When I look at the contents on the ODS, it shows the same number in the new data as the request I can't get to activate.

 

I 've also tried correcting the error in rsrv --> elementary test --> ODS objects --> check the status of the generated program of a Data Store object and have had no luck.

 

Any direction wocould be greatly appreciated.

 

Keith J

 

----------------------------------------------

A:

 

 

Hi Keith Johnson & Sheela

Thank you for youe response, I have solved the problem by deleting that participation request entry from the tables using SE16

Rsiccont, rsmonicdp & rsodsactreq.

Regards

S. alamelou

 

Source Document

 

Below is the DTP yellow light:

 

Applies

SAP Bi 7.0

Summary

Sometimes there arises a situation, wherein you need to change the status of a request that is getting loaded via a DTP. This article describes the solution for this scenario.

Author's bio

Rahul Bhandare is currently working in Patni Computer Systems Ltd as a sap bw consultant since last two years. He is mainly involved in development & Production Support Maintenance related work to sap bi.

Scenario

Consider following situations

1. DTP load for DSO is running more than its due time I. e. (taking more time to load data) and hence stays in yellow state for a long time and you want to stop the load to the DSO by changing the status of the loading request from yellow to red manually, but you deleted the ongoing background job for the DTP load.

2. A master data load through DTP failed as the background job for DTP failed with a short dump and you want to start a new DTP load but you cannot as there is a message saying"The old request is still running ".You cannot change the status for the old request to red or green as there is message"QM-action not allowed for master data ".You cannot delete the old request due to the message "request cannot be locked for delete ".

Solution

 

When old request in scenario 1 & 2 is in yellow status and you are not able to change/Delete the request, it's actually in a pseudo status. this request sits in Table rsbkrequest with processing type as 5 in data elements ustate, tstate and this 5 is actually "active" status which is obviusly wrong. one of the possible solutions is to ask a basis person to change the status to 3 in both ustate and tstate and then it allows reloading the data. once the data is successfully loaded, you can delete the previous bad request even though it is still in yellow. once the request is deleted, the Request status gets updated as "4" in Table rsbkrequest.

There is one more alternative solution, wherein you can manually change the status of the old request to red or green by using the function moduleRsbm_gui_change_ustate.

Following are the steps to change the Qm status of a yellow request to red/green by usingRsbm_gui_change_ustate

 

1. Select Request ID from target.

 

 

2. Go to se37 and execute the function module rsbm_gui_change_ustate.

 

 

3. Enter Request ID here and execute it.

 

 

4. Then change the status of the request to either red/green.

 

 

5. Request will have the status you selected in step 4 and delete the request if turned to red.

 

Related content

For more information, visit the http://www.sdn.sap.com/irj/sdn/nw-bi

.

Disclaimer and liability notice

This document may discuss sample coding or other information that does not include sap official interfaces and therefore is not supported by SAP. changes made based on this information are not supported and can be overwritten during an upgrade.

SAP will not be held liable for any damages caused by using or misusing the information, code or methods suggested in this document, and anyone using these methods does so his at/her own risk.

SAP offers no guarantees and assumes no responsibility or liability of any type with respect to the content of this technical article or code sample, including any liability resulting from incompatibility between the content within this document and the materials and services offered by SAP. you agree that you will not hold, or seek to hold, SAP responsible or liable with respect to the content of this document.