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

Master Data jobs are hanging


Hi friends / Gurus,

We had an issue on Master data jobs. All the master data jobs especially Master data attributes are hanging. And while we monitor the job status in SM66 it is displaying as :

Report Action Table

SAPLRSDDTMPTAB Delete RSDD_TMPNM_ADM

Can anyone please suggest me how to get rid of this issue.

Thanks in advance !!

Regards,

Ramesh

error.png (3.1 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 03, 2014 at 11:15 AM

    We fixed this issue and processes are running fine now. Below SQL was in inactive status and it was blocking all other SQLs on table RSDD_TMPNM_ADM. We killed that session from DB level and other processes resumed and completed.

    INSERT INTO "DBDIFF" VALUES(:A0 ,:A1 ,:A2 ,:A3 ,:A4 )

    Please also refer note 1736564 which talks about same issue we faced.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Kaustubh,

      Thanks for the usefull information. But for as a workaround we executed the report SAP_DROP_TMPTABLES to clear the lock whenever the master data jobs getting hunged status. But this is not a permenant fix. I will verify whether the above note is implemented or not in our system.

      Thanks,

      Ramesh

  • author's profile photo Former Member
    Former Member
    Posted on Dec 17, 2013 at 09:20 AM

    1. Could you please check the DB02 for space?

    2. Could you please cancel the job from SM51 and manually load the data if it hanging for a long time?
    3. Could you please check the RFC connection in SM59?

    4. Could you please check the BGD process in SM50 to see if it's used up?

    Let me know if all above action doesn't work.

    Best Regards!

    Lee

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Lee,

      1) We checked with DB02 also and we don't have any space issue.

      2) We canceled the SM51 jobs and rerun the failed jobs, but they are keep on hanging

      3) And coming to RFC connection, some of the master data jobs are running without any issues

      4) we had sufficient BGD process are available.

      Regards,

      Ramesh

  • author's profile photo Former Member
    Former Member
    Posted on Dec 17, 2013 at 09:34 AM

    Hi Ramesh,

    Check in ST22 whether its going for dump. I think its giving dumps thats why its hanging.

    Thanks,

    Kamal

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 17, 2013 at 10:11 AM

    Hi ramesh,

    At which stage your facing this issue at info pack level or dtp level.

    Please check their respected job log at SM37.

    Thanks

    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.