Master Data jobs are hanging

[Former Member]

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

[Former Member · Accepted solution]

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.

[Former Member · Accepted solution]

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

[RamanKorrapati]

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

[Former Member]

Hi Raman,

Im facing this issue in DTP level.  Please see attachment for more information.

Thanks,

Ramesh

[RamanKorrapati]

Hi,

is it full load or delta load.

is there any routines at your transformations?

for master data source you may be selected handling duplicate record key option at dtp level.

Thanks

[Former Member]

Hi,

What I can see from your screen capture is that your DTP is trying to handle duplicate records in your datapackage. I'd suggest you to define semantic keys in your data package along with duplicate records handling. Then trigger the DTP.

Let us know the progress.

Br, H

[Former Member]

Hi Raman,

Those all are delta loads and we don't have any routines also.

For duplicate handling we have enabled the option 'Handle Duplicates' in DTP level.

Thanks

Ramesh

[Former Member]

Hi Harish,

For full load master data jobs also we are facing the same issue.

Regards,

Ramesh

[Former Member]

And also we are maintained the Symantic Groups in DTP filter.

Thanks

Ramesh

[Former Member]

Hi,

Is this issue fixed? We are facing similar issue in BW 7.3 system where report SAPLRSDDTMPTAB is hung at table RSDD_TMPNM_ADM for multiple processes.

[Former Member]

Hi Ramesh,

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

Thanks,

Kamal

[Former Member]

Hi Kamal,

Just now checked with dumps also.  We don't have any dumps for these jobs.

Thanks,

Ramesh

[Former Member]

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

[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