Transport is not ending/importing through OS level

[former_member339060]

Hi There,

Am running the script to import the transport from OS(HP-UX) level and it is hanging as below. I did check with /usr/sap/trans/log s and it  is mentioning as below. Kindly suggest me how to resolve this issue.

This is tp version 380.08.46 (release 721, unicode enabled)

Warning: Parameter DBLIBPATH is no longer used.

This is R3trans version 6.24 (release 721 - 26.09.13 - 20:13:07 ).

unicode enabled version

R3trans finished (0000)

after that nothing is coming.... its hanging like that....

START imp single           SID        20140224130528              sid       hostname 20140224130526006359

INFO  TBATG CONVERSION OF  SID N      not needed                  sid       hostname 20140224130526006359

INFO: apg locked (anticipatory program generation)

START MOVE NAMETABS        SID 6      20140224130528              sid       hostname 20140224130526006359

START tp_getprots          SID P      20140224130528              sid       hostname 20140224130526006359

STOP  tp_getprots          SID P      20140224130529              sid       hostname 20140224130526006359

STOP  MOVE NAMETABS        SID 6      20140224130529              sid       hostname 20140224130526006359

START MAIN IMPORT          SID I      20140224130529              sid       hostname 20140224130526006359

INFO: apg unlocked (anticipatory program generation)

STOP  MAIN IMPORT          SID I      20140224130532              sid       hostname 20140224130526006359

INFO  TBATG CREATION OF EN SID n      not needed                  sid       hostname 20140224130526006359

START SET VERSION FLAGS    SID V      20140224130532              sid       hostname 20140224130526006359

START tp_getprots          SID V      20140224130532              sid       hostname 20140224130526006359

STOP  tp_getprots          SID V      20140224130553              sid       hostname 20140224130526006359

STOP  SET VERSION FLAGS    SID V      20140224130553              sid       hostname 20140224130526006359

START tp_getprots          SID R      20140224130553              sid       hostname 20140224130526006359

STOP  imp single           SID   7002 20140224130631              sid       hostname 20140224130526006359

START imp single           SID        20140224130902              sid       hostname 20140224130902007005

INFO  TBATG CONVERSION OF  SID N      not needed                  sid       hostname 20140224130902007005

SID and hostnames are changed. Kindly help me asap.

Thanks,

Pavan.

[former_member182657 · Accepted solution]

Hi Pavan,

One more thing we need to check whether the archive directory is full in the system,Please re check this also & perform consistency check from STMS and share results.

Thanks

[former_member182657]

Good to hear your issue has been resolved.Request you to please close the thread.

Thanks,

Gaurav

[former_member339060]

Issue is resolved after freed up the space in folder /usr. Earlier it was 100% due to this reason issue has occured.

Thanks a lot Gaurav for your time and help.

Thanks,

Pavan

[former_member182657]

Hi Pavan,

Need few more checks confirmation from your end:

1) Check whether the job RDDIMPDP is runnning, else schedule the job by running the report RDDNEWPP in se38, from client 000 .

2. Share SM21 system logs.

3.Go to STMS --> Overview ---> Import ---> Go To ---> Import Monitor

You'll get a new screen with list of the imported request and you will find the request with a truck appear there , right click on it and then delete.

After that try to re import the transport again w/o tp import all options.

Thanks

[former_member182657]

Hi Pavan,

Are you doing mass transport ? I think you are using a script at OS level for mass transport of requests,please share the content of that script & ULOG file from /usr/sap/trans/log.

Thanks

[former_member339060]

I have followed the methods to delete the TRBAT and TRJOB and restarted the system. Stilll the trs are not importing. Kindly help any one.

Thanks,

Pavan.

[former_member182657]

Hi Pavan,

As suggested by Ram do a full restart,after that if you still faced same issue just go to --> /usr/sap/trans/tmp  directory,here you'll find any *.LOB(Transport buffer lock file) and rename or moved this .LOB as like <>.LOB to < >.LOB_old & try again.

Hope this will solve your issue.

Thanks,

Gaurav

[former_member339060]

Hi Gaurav,

There is no .LOB file in mentioned location and I did full restart of the system. Still the same issue. Kindly suggest me.

Thanks,

Pavan.

[former_member182657]

Hi Pavan,

Please confirm are there any entries present under tables TMSTLOCKR (TMS Lock Table for Individual Imports) ,TRBAT  , TRJOB .You can find via use of SE16n.

Cleanup these table after backup of table entries if any & try again.

Thanks

[former_member339060]

Hi Gaurav,

I have checked the TMSTLOCKR (TMS Lock Table for Individual Imports there are no entries but I can see transport request in TRBAT.

Thanks,

Pavan.

[former_member182657]

Hi Pavan,

As i suggested kindly take a backup of that table or entries in it (highly recommended) & cleanup the table via SE16n if you've the authorization for that Tranx or use SQL > delete * from sapr3.TRBAT,then please try again.

Thanks

[former_member339060]

Hi Gaurav,

I have deleted the TRBAT entries and tried still the same issue. Can you please suggest me.

Thanks,

Pavan.

[Sriram2009]

Hi Pravan

Just do the full restart (SAP instance & OS level) and than try again

Regards

Ram