Skip to Content
author's profile photo Former Member
Former Member

Process chains for loading data to target is not functioning

Hi SAPians,

Recently, we have upgraded the firmware on IBM P590 with the help of IBM on Saturday i.e. 06/12/2008 (The firmware of P5-590 was SF235_209. It was upgraded to SF240_XXX) and since then the process chains for loading data to targets are not functioning properly. We have stopped all the SAP services, database services & OS services from our end and services have been rebooted after firmware upgrade.

However, the problem with the process chains that load transaction data and hierarchies is solved but the chains that load master data are still not working as scheduled.

We tried to load the master data manually, by running DTP to load data to an object analysis code (attributes) the request remained YELLOW. After refreshing it several times, the request turned into RED. The error message was - PROCESSING TERMINATED (screenshot 1 attached).

To mitigate this we tried deleting the bad request and it prompted with the below message:

"Cannot lock request DTPR_4C37TCZGDUDX1PXL38LVD9CLJ of table ZANLYSIS for deletion (Message no. RSMPC178)" (screenshot 2 attached)

Please advise us how the bad request should be deleted?

Regards,

Soujanya

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 12, 2008 at 06:52 AM

    Hi Sowjanya,

    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...

    Releasing LocK

    Gott Transaction Code SM12 and release the lock.

    Hope It helps you.

    Regardss,

    Nagaraju.V

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 11, 2008 at 06:55 PM

    Is the request still running? Check SM37 and make sure it's finished or cancelled and not active.

    If you know nothing is running, then you can go into SM12 and release the lock directly.

    Brian

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 22, 2008 at 03:34 PM

    Thanks Nagaraju. It worked.

    Regards,

    Soujnaya

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.