cannot delete request in master data

[Former Member]

hi all,

i have BI 7.0. I load master data (is Info provider). the DTP-request is yellow. reason is "record by second try in Q-table booked" (msg-nr. RSDMD217).

now i cannot load other DTP's, because the system message is "the old request is still running".

i cannot change the status for the old request in red or green. msg-nr. RSM032. qm-action not allowed for master data

i cannot delete the old request. msg-nr. RSMPC178. request cannot locked for delete. there is no lock in RS12.

any idea.

regards Andreas

[Former Member]

Thank you very much! It helps me too!

[Former Member]

a good program

[Former Member]

hi Debjani,

congratulations.

the problem is solved.

thanks and regards

Andreas

[Former Member]

Hi.....

Follow the below procedure to make yellow request to RED:

Use SE37, to execute the function module RSBM_GUI_CHANGE_USTATE

From the next screen, for I_REQUID enter that request ID and execute.

From the next screen, select 'Status Erroneous' radiobutton and continue.

This Function Module, change the status of request from Green / Yellow to RED.

Once it is RED, you can manually delete that request...

Hope this helps.....

Regards,

Debjani......

Edited by: Debjani Mukherjee on Oct 10, 2008 12:51 PM

[Former Member]

thanks this helped me too

[Former Member]

Very helpful !

Do you think that I could also make use of this function in the case of a request that would do a timeout for sure ? Or is it wiser to wait for the timeout/try to kill the process in SM50 ?

[Former Member]

Thanks much Debjani! It helped me.

Out of curiosity: Does anyone know why this happens?

I experience this whenever I execute a process chain and the associated DTP / Infopackage retrieves some records from source system into PSA but gives a Yellow (warning) message in the monitor that there are not records to process. It does nothing from then on.

[Former Member]

Had the same problem: Red DTP-request in master data attributes could be deleted.

Used the function module to make it again "red". Then it could be deleted.

Thanks, a lot for your reply.

Thomas

[Former Member]

Very Useful. Cheers.

[Former Member]

Tnx. Very useful.

[Former Member]

Excellent. Solved our problem.

Thanks!