DTP Stuck

[Former Member]

My DTP Job is stuck .Below is DTP job log..I have done prelim checks as foow.

1) 5 parralel process alloted

2) SM66 showing Seq read on table PMat_Plant

3) data load b/w 0material to DSO

Job started

Step 001 started (program RSBATCH_EXECUTE_PROZESS, variant &0000038867212,

Processing started for batch ID DTPR_7827197_1 process 2

EXTRACTION OF DATAPACKAGE 000001

All records forwarded...

What can be reason?

regards

nayab

[Former Member]

Hi Guys,

Let me attach the DTP monitor ...in more than 2.5 hrs only 1 packet is created

[RamanKorrapati]

Hi Nayab,

Is this is new design recently moved to production ? is it first time your facing issue for this dtp?

Seems like filter or routine causing this.  can you recheck your routine and filter values which your entered. mean while can you check your dtp job at SM37.

Assuming as deleted index before loading to cube.

if your using standard data source please name it.

are you loading master data to dso?

Thanks

[Former Member]

Hi Raman,

We have just finished DB2 migration

We are facing the issue first time .

I ve attached job log in post.

yes we are loading masterdata to DSO.

0material--> DSO

Thanks

[RamanKorrapati]

Hi,

Have you tried to debug your dtp? try and check it. where its taking too much time.

To debug dtp we need to set : at DTP level, last tab, processing mode as Serially in the dialog process for debugging.

Have you filters, if yes then what filter your using. is it loading particular input or excluding.

Please check on filters. because of filter your getting 0records.

Try to repair your DSO  at RSRV.

Other than this load, are you facing any error at dtp level while loading into targets? if its DB issue then we may need get error for loads also. seems like not DB issue.

Thanks

[Former Member]

Hi Raman,

I have carried out RSRV checks and in process of denugging the request.

I will share the progress.

thanks

Nayab

[rd1997]

hii please help me on how did you solve this issue. i am facing the exact same issue.

[AlexGourdet]

We're glad to have you in the community looking for answers to your questions, but you posted a few questions as an answer (which I converted to a comment) in a thread which is a few months old. || but you posted a comment in a thread which is a few year old by inactive thread (with former members) from

I want you to get the help you need, but you're unlikely to get any responses this way. Therefore, I'd like to offer some friendly advice:

* Try asking a new question instead at https://answers.sap.com/questions/ask.html.

* Familiarize yourself with https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.

* Take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html, as that will also help you when preparing questions for the community.

* Complete your profile by following the steps at https://developers.sap.com/tutorials/community-profile.html, as a complete profile encourages readers to respond.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the Best,
-Alex

[Former Member]

Hi Nayab,

Check if the error stack of the DTP is full.

If it is full, the performance of  DTP will be affected. So, Clear the error stack first.

Then run the DTP.

Hope it helps.

Regards,

Harish.

[Former Member]

@ Suman,

7-8  Background Processes doesnt help.

@Martin

Yes i am loading from 0Mateial as source and it is reading PMat_Plant in SM66.

Pmat_Plant is used in my end routine.

Maybe it is eating time up there in looking up Pmat_Plant..

Thanks

Nayab

[MGrob]

Most likely the issue is then pmat_plant (doesn't hurt to check it in rsrv) and go through your endroutine.

hope that helps

Martin

[former_member182470]

Create indexes on PMat_plant in SE11. This will dramatically improve the performance.

[former_member182470]

Missed my above reply?

[Former Member]

i noted ur reply.

But we never had indexes on this table...and never faced the issue...

the data volume is comparitavely same but performance is heavily degraded.

[MGrob]

Hi

2) SM66 showing Seq read on table PMat_Plant
3) data load b/w 0material to DSO

You're loading 0material to a DSO but your load is reading from pmat_plant? Are these related or is this just what sm66 shows? Check in Rsrv your 0material and the dso you are loading.

hope that helps

Martin

[Former Member]

Hi Suman,

The records are around 4 Lacs...

Daily loads would take 30 mins at max.

Please note that our system was down due to extensive DB2 migration for 2 days .The scheduled jobs including this DTP are taking time after migration.

Could this be related?...I wondered we will have better loading performance with DB2 ...

[former_member182470]

DB2 Migration could also be the reason. But change the DTP settings next time and run as per my suggestion. This will improve the performance.

[former_member182470]

As you see some activity is going on SM50, that means your DTP is in progress. You may have to wait till it gets over. Since how long it is running?

Next time, run with 7 or 8 BGds and Seelct Parallel extraction or increase the datapackagae size.