Transport Stuck

[Former Member]

Hi All,

By mistake instead of giving the client number I gave the SID and now the transport is stuck with the truck.

I tried to delete the transport after taking a back up of  respective co file and data file. Killed all the tp process. Refreshed the queue. Tried to add the transport again but no success.

Any suggesstions. This is a PRD import so little emergency.

Regards.

[former_member227283 · Accepted solution]

Dear Ambarish,

If you kill the TP Process, Cleared the TRBAT/TRJOB tables and deleted respected TR from Que as shown by Manas then it should not appear in the STMS list, it should have been disappear.

Is it still in STMS que after taking all above action or It get deleted but when you try to add the TR again it shows the truck symbol again ?

Regards,

Anil

[Former Member · Accepted solution]

Hi All,

Thank you for the replies.

The solution is found. After deleting the TR from the queue and taking the back up of the data file and co-file. Refreshed the queue. I placed back the co-file and data file and then this time restarted the server.

The TR was found without the truck.

Regards,

Ambarish.

[former_member185488]

Hi Ambarish,

The only way is to delete the entry from "Import Queue" and import it again.

Regards,

Jegan Raj

[Former Member]

Hello,

As you seem to have tried the conventional ways to resolve your problem with no luck.

Please check table TPSTAT. You will find an entry corresponding to your transport. You can delete the entry with importing status.

KR,

Amerjit

[Former Member]

Try to refresh information from Import Monitor.

[Former Member]

No change....

[Former Member]

Hi Ambarish,

If you are still facing the issue, can you please try going to import monitor:

And then delete the entry of the transport you are having issue with:

Then add the transport again in the buffer and import it.

Thanks,

Manas

[Former Member]

It doesnot allow you to delete

[karthikeyan_natarajan4]

Hi Ambarish,

Take a backup of transport buffer or rename the buffer file, try to add the TR using addtobuffer command from OS level.

Regards,

Kartik

[Former Member]

Hi Karthik,

No success.

Regards.

[karthikeyan_natarajan4]

Hi Ambarish,

You still see the Transport icon stuck or not able to add the TR to queue. what is the current status. Please explain.

regards,

Kartik

[former_member185327]

Hi Ambarish,

Did you checked the SLOG file?  What's showing there?

Regards

Anurag

[Former Member]

Hi Anurag,

The respective Slog file is not found in the slog directory.

And from frontend it says couldnot open the respective file.

Regards.

[former_member185327]

Hi Ambarish,

Can you kindly check if the RDDIMPDP job is scheduled from client 000 DDIC user.

Also please try to clean up the tables TRBAT, TRJOB and TRSTLOCKR tables.

Regards

Anurag

[Former Member]

Hi Anurag,

These all are checked and done.

Thanks.

[former_member185327]

Hi Ambarish,

This Transport Issue might be due to a variety of reasons.

However since you already told that you have performed some of the steps. I would still recommend you to go through this below notes just to compare the list of tasks that you have done matches with the tasks mentioned here.

556941 - Transport FAQ: Error scenarios

71353 - Transports hang during background steps

Kindly go through this above notes and check if you have done all the steps for the troubleshooting.

Regards

Anurag