Import is running from last one week

[Former Member]

Dear expert

i transported a request from QAS to PRD and it was showing (Import Running ,showing Truck) for 2 hours .So, I deleted it and made new transport request from consultant When i import it then it also showed Import Running. After it i transported more request but all transport requests are showing Import Running from 2 hours in STMS.

I have seen forum and i deleted it from import monitor and i removed from TMSTLOCKR and TRBATbut i ts not working

what should i do for this issue?

regards,

[Former Member · Accepted solution]

you can check in task manager, search for R3trans and tp.

cheers,

-Sunil

[Former Member · Accepted solution]

There are two tp.exe is there but no r3trans is showing

[markus_doehr2 · Accepted solution]

Please check the latest logs in /usr/sap/trans/log.

Markus

[Former Member · Accepted solution]

Ya it say the some back ground job is not started sapevt.exe SAP_TRIGGER_RDDIMPDP -t name=PRD background job not started

[markus_doehr2 · Accepted solution]

- logon to client 000 (not using SAP* or DDIC)

- execute program RDDNEWPP

Markus

[Former Member · Accepted solution]

It should be in high priority or normal

[markus_doehr2 · Accepted solution]

I'd use high priority.

Markus

[Former Member · Accepted solution]

It says that jaob has been scheduled but when i want to see it by sm37 it says that no job matches the selection criteria

[markus_doehr2 · Accepted solution]

Yes - because it will run event triggered.

Markus

[Former Member · Accepted solution]

now i can impotr

[markus_doehr2 · Accepted solution]

> now i can impotr

was that a question? If yes, yes - you can now retry the import. End the tp processes running before you start the import another time.

Markus

[Former Member · Accepted solution]

I have to re start the server or what because it is not working the error

[markus_doehr2 · Accepted solution]

No - you can just kill the running tp processes using task manager and rerun the import.

If it does not work please check again the last logs.

Markus

[Former Member · Accepted solution]

ya i checked all the things same error is showing there in the log file

[markus_doehr2 · Accepted solution]

Please post the content (last lines) of the logfile.

Markus

[Former Member · Accepted solution]

(logon to client 000 (not using SAP* or DDIC)

execute program RDDNEWPP )

I have just now seen a SAP note71353 where i got the following info (user should be DDIC)

a) Log on as the DDIC user to client 000.

b) Call transaction SM37.

c) Choose the selections:

Job name: RDD*

User: DDIC

Selection date: leave these fields empty

Only jobs with the status 'Active'.

[markus_doehr2 · Accepted solution]

Are there free batch processes in your system?

Markus

[Former Member · Accepted solution]

START imp single PRD 20081111180419 ADMIN bmwprd 20081111180419

START tp_getprots PRD J 20081111180420 ADMIN bmwprd 20081111180419

WARNING: System PRD. Warning. 20081111181010 :

ERROR: The following call returned with exit code 7:

ERROR: sapevt.exe SAP_TRIGGER_RDDIMPDP -t name=PRD

ERROR: Background jobs cannot be started.

ERROR: Please check trace file dev_evt.

WARNING: (This warning is harmless if no further warnings follow.)

[Former Member · Accepted solution]

yes all are free

[former_member204746 · Accepted solution]

read your error message and act accordingly:

Please check trace file dev_evt

[Former Member · Accepted solution]

Tue Nov 11 18:46:17 2008

Trace File of External Event Raiser (Level=2, Append=0)

Tue Nov 11 18:46:19 2008

EventID: SAP_TRIGGER_RDDIMPDP

• ERROR ***: Cannot determine mshost

Tue Nov 11 18:49:19 2008

Trace File of External Event Raiser (Level=0, Append=1)

EventID: SAP_TRIGGER_RDDIMPDP

• ERROR ***: Cannot determine mshost

Tue Nov 11 18:50:19 2008

Trace File of External Event Raiser (Level=0, Append=1)

EventID: SAP_TRIGGER_RDDIMPDP

• ERROR ***: Cannot determine mshost

[Former Member · Accepted solution]

thanku very much due to your help i have solved the problem

[nirmal_konchada · Accepted solution]

Hello Rupesh,

Can you please let me know how, u solved this problem???

Regards,

Nirmal

[Former Member · Accepted solution]

After doing above activity

i just restarted the system after that its working

Rupesh

[markus_doehr2]

What is in transport request? If you e. g. create an Index on your testsystem and transport that, it can take a long time to create that in the target system because tables are usually bigger in production systems...

What do you see during the import in SM66?

Markus

[Former Member]

These request are generated in Development system and sm66 is showing nothing

[markus_doehr2]

- is there a tp and/or R3trans running on OS level?

- do you see any logfiles changed recently in /usr/sap/trans/tmp?

Markus

[Former Member]

Ther is no new log files in the usr/sap/trans/temp

[Former Member]

how to check is there a tp and/or R3trans running on OS level?