DTP overall status yellow, but technical status is green

[Former Member]

Hi all,

This issue has been reported many times and with all the SCN-solutions/tips and OSS notes available, the problem still persists in our BW system.

We recently went from BW 7.3 SP7 to SP12, after which this problem started to show up. It's the exact problem as mentioned in note 1897899:

http://service.sap.com/sap/support/notes/1897899

This note however, has been applied in SP11 and the coding is already present in our system.

Has anyone experienced the same, or should I create a support message with SAP?

Thanks,

Eduard

[shashank-01kamal]

Hi all,

Maybe it will be helpful for someone, we faced the same issue and turned out that in "Execute" tab of DTP, the settings for updating Overall state was set to manual. After changing it, the DTP worked just fine.

Regards,

SK

[Former Member]

Hi Ebrantjes,

Is the loading happening to cube?

If yes try to manually change the status...You might get a dump

Then check RSMDATASTATE table, field AGGREXIST...if it is not flagged this issue can happen...

[Former Member]

Hi Eduard,

Please try to implement the SAP Notes 2003024 and 1929606 if the  RSPC_PROCESS_FINISH is not called automatically by the DTP variant.

This should fix your problem.

Thanks and Regards,

Raghu

[Former Member]

Thanks, but both notes are in lower support packs than we are already on.

[Former Member]

See if anything in the below composite note helps,

2093582 - Composite note for hanging DTP processes in Process Chains

If the notes mentioned are below your SPs please raise an OSS message with SAP.

Thanks,

Raghu

[Former Member]

Yep... OSS message has been made.

Thanks,

Eduard

[muratakpolat2]

Dear Eduard,

our system is now upgraded to SPS12 as well and we have the same issue now.

Did you get a solution (from your OSS message)?

Thanks

Murat

[Former Member]

Hi Murat,

Yes, we did. There's a note to fix this that we had overlooked: note 2029354.

I hope this helps for you.

Cheers,
Eduard

[muratakpolat2]

Hi Eduard

Thank you for the quick response, will let you know if the note solved our problem as well!

@Nayab: manually changing the overall status works out, but we want avoid any kind of manual interaction during loading

Regards

Murat

[Former Member]

Hi,

See though the technical status is green sometimes dtp may behave obnormally.

so to overcome such cases we use the above function module to turn overall status to green.

Regards,

Abdul Rawoof Syed.

[Former Member]

HI E. Brantjes,

i think its patch issue can put error message am unable to open the link....

or you use the function module RSBM_GUI_CHANGE_USTATE.

Regards,

Abdul Rawoof Syed.

[Former Member]

Hi Abdul,

Thanks for your reply.

The thing is, I don't want manual intervention. The DTP has technical status green, so it should proceed without having to do anything.

cheers,

Eduard