cancel
Showing results for 
Search instead for 
Did you mean: 

Transport struck for hours

Former Member
0 Kudos

Hi,

We are not able to import any more transport as one of our transport is running for hours.We tried to delete that & try to re-import it but the same thing is happening.Even I tried to delete the entry from trbat table but all in vain.Need suggestion

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Das,

It looks like lock issue. Please check SLOG and verify if current PID is waiting for any other process to be completed. If yes, please rename the latest LOC and LOB files then import should be running fine.

Hope it helps you.

Thanks,

Siva Kumar

Former Member
0 Kudos

Do you have a back log of jobs? Sometimes you have a large number of TRFC jobs that are backloged so the other jobs are waiting. If you do the step to run the RDDNEWPP step, schedule the jobs with a high priority so they would run before lower priority jobs. That may help them to run in a timely manner.

former_member188883
Active Contributor
0 Kudos

Hi,

Please check whether RDDIMPDP job is running or not. Please check details in SLOG.

Regards,

Deepak Kori

Former Member
0 Kudos

RDDIMPDP has run half an hour ago & the new one is in release state.What should be the time interval of RDDIMPDP job?

Pasting the slog entry:

START imp single

START CMDIMPORT

STOP CMDIMPORT

START CREATE VERSIONS BEFO

START tp_getprots

STOP tp_getprots

STOP CREATE VERSIONS BEFO

INFO TBATG CONVERSION OF

START MOVE NAMETABS

START tp_getprots

STOP tp_getprots

STOP MOVE NAMETABS

START MAIN IMPORT

STOP MAIN IMPORT

INFO TBATG CREATION OF EN

START CREATE VERSIONS AFTE

START tp_getprots

STOP tp_getprots

STOP CREATE VERSIONS AFTE

START EXECUTION OF REPORTS

START tp_getprots

STOP tp_getprots

STOP EXECUTION OF REPORTS

STOP imp single

START INFORM SAP-SYSTEM OF

START tp_getprots

STOP tp_getprots

STOP INFORM SAP-SYSTEM OF

START imp single

START CMDIMPORT

STOP CMDIMPORT

START CREATE VERSIONS BEFO

START tp_getprots

STOP tp_getprots

STOP CREATE VERSIONS BEFO

INFO TBATG CONVERSION OF

START MOVE NAMETABS

START tp_getprots

STOP tp_getprots

STOP MOVE NAMETABS

START MAIN IMPORT

STOP MAIN IMPORT

INFO TBATG CREATION OF EN

START CREATE VERSIONS AFTE

START tp_getprots

STOP tp_getprots

STOP CREATE VERSIONS AFTE

START EXECUTION OF REPORTS

START tp_getprots

STOP tp_getprots

STOP EXECUTION OF REPORTS

STOP imp single

START INFORM SAP-SYSTEM OF

START tp_getprots

STOP tp_getprots

STOP INFORM SAP-SYSTEM OF

START imp single

START CMDIMPORT

STOP CMDIMPORT

START CREATE VERSIONS BEFO

START tp_getprots

STOP tp_getprots

STOP CREATE VERSIONS BEFO

INFO TBATG CONVERSION OF

START MOVE NAMETABS

START tp_getprots

STOP tp_getprots

STOP MOVE NAMETABS

START MAIN IMPORT

STOP MAIN IMPORT

INFO TBATG CREATION OF EN

START CREATE VERSIONS AFTE

START tp_getprots

STOP tp_getprots

STOP CREATE VERSIONS AFTE

sunny_pahuja2
Active Contributor
0 Kudos

RDDIMPDP has run half an hour ago & the new one is in release state.What should be the time interval of RDDIMPDP job?

>

>

RDDIMPDP job is an event trigger job. Please perform consistency check in STMS and then check the logs.

Thanks

Sunny

Former Member
0 Kudos

I have done consistency check & pasting the slog:

START imp single

START CMDIMPORT

STOP CMDIMPORT

START CREATE VERSIONS BEFO

START tp_getprots

STOP tp_getprots

STOP CREATE VERSIONS BEFO

INFO TBATG CONVERSION OF

START MOVE NAMETABS

START tp_getprots

STOP tp_getprots

STOP MOVE NAMETABS

START MAIN IMPORT

STOP MAIN IMPORT

INFO TBATG CREATION OF EN

START CREATE VERSIONS AFTE

START tp_getprots

STOP tp_getprots

STOP CREATE VERSIONS AFTE

START EXECUTION OF REPORTS

START tp_getprots

STOP tp_getprots

STOP EXECUTION OF REPORTS

STOP imp single

START INFORM SAP-SYSTEM OF

START tp_getprots

STOP tp_getprots

STOP INFORM SAP-SYSTEM OF

START imp single

START CMDIMPORT

STOP CMDIMPORT

START CREATE VERSIONS BEFO

START tp_getprots

STOP tp_getprots

STOP CREATE VERSIONS BEFO

INFO TBATG CONVERSION OF

START MOVE NAMETABS

START tp_getprots

STOP tp_getprots

STOP MOVE NAMETABS

START MAIN IMPORT

STOP MAIN IMPORT

INFO TBATG CREATION OF EN

START CREATE VERSIONS AFTE

START tp_getprots

STOP tp_getprots

STOP CREATE VERSIONS AFTE

START EXECUTION OF REPORTS

START tp_getprots

STOP tp_getprots

STOP EXECUTION OF REPORTS

STOP imp single

START INFORM SAP-SYSTEM OF

START tp_getprots

STOP tp_getprots

STOP INFORM SAP-SYSTEM OF

START imp single

START CMDIMPORT

STOP CMDIMPORT

START CREATE VERSIONS BEFO

START tp_getprots

STOP tp_getprots

STOP CREATE VERSIONS BEFO

INFO TBATG CONVERSION OF

START MOVE NAMETABS

START tp_getprots

STOP tp_getprots

STOP MOVE NAMETABS

START MAIN IMPORT

STOP MAIN IMPORT

INFO TBATG CREATION OF EN

START CREATE VERSIONS AFTE

START tp_getprots

STOP tp_getprots

STOP CREATE VERSIONS AFTE..

If it is an event trigger job then why rddimpdp should be running always?When an event will occur it should run then only.

It is showing with the truck: Import running in the Import queue of STMS.

tomas_black
Active Contributor
0 Kudos

Hello N.Das,

check the latest SLOG file created in /usr/sap/trans/log directory. See if it contains entries similar to the following:


WARNING: ...\sapmnt\trans\tmp\SAPKKE60031.ABC is already in
use (33870), I'm waiting 4 sec (20090706211037). My name: pid 4

This is a very common issue for transports stuck on the import queue. To fix it, please follow note #[12746 |https://bosap-support.wdf.sap.corp/sap/support/notes/12746](basically move/delete the file that's locking the import - SAPKKE60031.ABC on this example - and repeat the import. Stop all imports and kill any remaining tp/R3trans processes on the OS level before)

Common files that cause this lock also have extension .LOC or .LOB.

Best regards,

Tomas Black

former_member188883
Active Contributor
0 Kudos

Hi,

Go to transaction code se38 and run the report RDDPUTPP and RDDNEWPP every 5 mins or event based to get past your import process. Above 2 programs can help you in running RDDIMPDP program as per requirement,

As per the information shared by you there seesm to be some issue in running RDDIMPDP program.

Hope this helps.

Regards,

Deepak Kori

former_member227283
Active Contributor
0 Kudos

Hi Das,

Simply do the following steps it should resolve your issue.

1. Delete the runing transport request from STMS Que.

2. Delete the all entries from TRBAT table using SM30.

3. GoTo OS level and kill all your TP process.

Once above all 3 steps are done. Then try to import the request.

Thanks,

Anil Bhandary