on 11-02-2011 3:12 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please check whether RDDIMPDP job is running or not. Please check details in SLOG.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
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
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
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
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.