cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

transport request not releasing

sivakumar_kilari3
Active Contributor

on ‎11-14-2008 1:28 PM

0 Kudos

Hi All,

While releasing transport request it takes more than 24 hours but still

not yet released. task has been released. Other requests are releasing and importing going fine. but one request is taking time.

Regards

Siva

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
‎01-16-2009 9:26 PM
0 Kudos

Hi Kumar,

Your log is showing that request is released. IT seems SE09/SE10 did not get refreshed. Refresh and check.

Thanks,

Kiran.

Show replies
Show replies
Former Member
‎11-17-2008 5:50 PM
0 Kudos

try

Note 358688 - Performance for request release: TLOCKPC

regards

dEE

Show replies
Show replies
Former Member
‎11-14-2008 1:56 PM
0 Kudos

check for tp and R3trans process

ps -eaf | grep tp

ps -eaf | grep R3trans

cheers,

-Sunil

Show replies
Show replies
sivakumar_kilari3
Active Contributor
‎11-14-2008 2:02 PM
0 Kudos

Hi Sunil,

sapdev:edvadm 5> ps -eaf | grep tp

root 733436 217194 0 15:46:35 - 0:00 ftpd

edvadm 1486898 716996 0 18:32:21 pts/1 0:00 grep tp

edvadm 1556480 778436 0 18:16:11 - 0:00 /usr/sap/EDV/DVEBMGS00/exe/tp

sapdev sapgw00 12726748 IDX=0

sapdev:edvadm 6> ps -eaf | grep R3trans

edvadm 1486904 716996 0 18:34:19 pts/1 0:00 grep R3trans

Regards

Siva

markus_doehr2
Active Contributor
‎11-14-2008 2:05 PM
0 Kudos

so your tp is still running

try

cd /usr/sap/trans/tmp
ls -lt | head

cd /usr/sap/trans/log
ls -lt | head

and check the latest logfiles.

Markus

sivakumar_kilari3
Active Contributor
‎11-14-2008 2:25 PM
0 Kudos

Log files also not there this request no. but task no is there.

Regards

Siva

markus_doehr2
Active Contributor
‎11-14-2008 2:27 PM
0 Kudos

What about the SLOG, ALOG and Q* files?

If you don't give us information we can't help you.

Markus

sivakumar_kilari3
Active Contributor
‎11-14-2008 2:29 PM
0 Kudos

Hi Markus,

This is the task log file.

1 ETP199X######################################

1 ETP182 CHECK WRITEABILITY OF BUFFERS

1 ETP101 transport order : "EDVK900773"

1 ETP102 system : "EDV"

1 ETP108 tp path : "tp"

1 ETP109 version and release : "372.04.36" "700"

1 ETP198

4 ETP201 Check target systems buffer: "/usr/sap/trans/buffer/EDV"

3 ETP203 Buffer "/usr/sap/trans/buffer/EDV" is writeable

1 ETP182 CHECK WRITEABILITY OF BUFFERS

1 ETP110 end date and time : "20081112153053"

1 ETP111 exit code : "0"

1 ETP199 ######################################

1 ETP199X######################################

1 ETP183 EXPORT PREPARATION

1 ETP101 transport order : "EDVK900773"

1 ETP102 system : "EDV"

1 ETP108 tp path : "tp"

1 ETP109 version and release : "372.04.36" "700"

1 ETP198

2 EPU230XExecution of the export pre-processing methods for request "EDVK900773"

4 EPU111 on the application server: "sapdev"

4 EPU138 in client : "200"

2 EPU235XStart: Version creation of the objects of the request "EDVK900773"

3 EPU237 Version creation started as update request

2 EPU236 End: Version creation of the objects of the request "EDVK900773"

2 EPU231XStart: Adjusting the object directory for the objects of the request "EDVK900773"

2 EPU232 End: Adapting the object directory for the objects of the request "EDVK900773"

2 ETN085 "Adding component vector" " " " " " "

2 ETN085 "Finished." " " " " " "

1 ETP183 EXPORT PREPARATION

1 ETP110 end date and time : "20081112153058"

1 ETP111 exit code : "0"

1 ETP199 ######################################

1 ETP199X######################################

1 ETP150 MAIN EXPORT

1 ETP101 transport order : "EDVK900773"

1 ETP102 system : "EDV"

1 ETP108 tp path : "tp"

1 ETP109 version and release : "372.04.36" "700"

1 ETP198

4 ETW000 R3trans version 6.14 (release 700 - 28.07.08 - 15:52:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 12.11.2008 - 15:31:04

4 ETW000 control file: /usr/sap/trans/tmp/EDVKK900773.EDV

4 ETW000 > #pid 1564674 on sapdev (edvadm)

4 ETW000 > export

4 ETW000 > file='/usr/sap/trans/data/R900773.EDV'

4 ETW000 > client=200

4 ETW000 > buffersync=yes

4 ETW000 >

4 ETW000 > use comm 'EDVK900773'

4 ETW000 R3trans was called as follows: R3trans -w /usr/sap/trans/tmp/EDVE900773.EDV /usr/sap/trans/tmp/EDVKK900773.EDV

4 ETW000 Connected to DBMS = ORACLE --- dbs_ora_tnsname = 'EDV' --- SYSTEM = 'EDV'.

4 ETW690 COMMIT "0" "0"

4 ETW000 trace at level 1 opened for a given file pointer

4 ETW000

4 ETW000 ================== STEP 1 =====================

4 ETW000 date&time : 12.11.2008 - 15:31:04

4 ETW000 function : EXPORT

4 ETW000 data file : /usr/sap/trans/data/R900773.EDV

4 ETW000 buffersync : YES

4 ETW000 client : 200

4 ETW000 Syslog: k CQ3 : UMGSETTING& rscpexcc 12

4 ETW000 GetDBMigrateCodePagesLangs uses TCP0D, TCPDB, TCP0C.

4 ETW000 Language : ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdi(),./:;& (ISO-ARHECSDEENFRELHUITJADAPLZFNLNOPTSKRUESTRFISVBGLTLVZ1SRZHTHKOROSLHRMSUKETAFISCASHIDZ2Z3Z4Z5Z6Z7Z8Z9)

4 ETW000 Compression : L

4 ETW000 l.s.m. : VECTOR

4 ETW000 commit : 100000

4 ETW000 table cache : dynamic

4 ETW000

3 ETW673XUse Commandfile "EDVK900773"

4 ETW000 /* HR_PA_Actions_Setup Actions (PA40) */

4 ETW000 trfunction: 'W' (customizing transport)

4 ETW000 trstatus : 'O'

4 ETW000 tarsystem : /ALL/

4 ETW000 user : RAHULD

4 ETW000 date : 12.11.2008 - 15:30:53

4 ETW000 1 entry from E070 exported (EDVK900773 ).

4 ETW000 2 entries from E071 exported (EDVK900773 *).

4 ETW000 22 entries from E071K exported (EDVK900773 *).

4 ETW000 5 entries from E071KF exported (EDVK900773 *).

4 ETW000 1 entry from E070C exported (EDVK900773 ).

4 ETW000 108 entries from E070A exported (EDVK900773 *).

4 ETW000 0 entries from CTS_SERIAL exported (EDVK900773 *).

4 ETW000 1 entry from E07T exported (EDVK900773 *).

3 ETW678Xstart export of "R3TRTABUT529A" ...

4 ETW000 0 entries from STABULOG exported (TABUT529A *).

4 ETW000 1 entry from T529A exported (200CO).

4 ETW000 1 entry from T529A exported (200DE).

4 ETW000 1 entry from T529A exported (200DH).

4 ETW000 1 entry from T529A exported (200EX).

4 ETW000 1 entry from T529A exported (200HA).

4 ETW000 1 entry from T529A exported (200IP).

4 ETW000 1 entry from T529A exported (200PR).

4 ETW000 1 entry from T529A exported (200RE).

4 ETW000 1 entry from T529A exported (200SE).

4 ETW000 1 entry from T529A exported (200SU).

4 ETW000 1 entry from T529A exported (200TR).

4 ETW000 1 entry from T529T exported (200ECO).

4 ETW000 1 entry from T529T exported (200EDE).

4 ETW000 1 entry from T529T exported (200EDH).

4 ETW000 1 entry from T529T exported (200EEX).

4 ETW000 1 entry from T529T exported (200EHA).

4 ETW000 1 entry from T529T exported (200EIP).

4 ETW000 1 entry from T529T exported (200EPR).

4 ETW000 1 entry from T529T exported (200ERE).

4 ETW000 1 entry from T529T exported (200ESE).

4 ETW000 1 entry from T529T exported (200ESU).

4 ETW000 1 entry from T529T exported (200ETR).

4 ETW679 end export of "R3TRTABUT529A".

4 ETW000 EDVK900773 touched.

4 ETW000 EDVK900773 released.

4 ETW000 4837 bytes written.

4 ETW000 Transport overhead 30.5 %.

4 ETW000 Data compressed to 8.5 %.

4 ETW000 Duration: 0 sec (4837 bytes/sec).

4 ETW000 0 tables in P-buffer synchronized.

4 ETW000 0 tables in R-buffer synchronized.

4 ETW690 COMMIT "512" "512"

4 ETW000

4 ETW000 Summary:

4 ETW000

4 ETW000 1 COMML exported

4 ETW000 1 COMMT exported

4 ETW000 2 DELETE commands exported

4 ETW000 Totally 22 tabentries exported

4 ETW000

4 ETW000 [dev trc ,00000] Disconnecting from ALL connections: 496153 0.496153

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 67 0.496220

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0x11102c7f8,usrhp=0x111018fc0)

4 ETW000 1330 0.497550

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x11102c7f8,srvhp=0x11102ca18)

4 ETW000 861 0.498411

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 2036 0.500447

4 ETW000 [dev trc ,00000] Disconnected from connection 0 56 0.500503

4 ETW000 [dev trc ,00000] statistics db_con_commit (com_total=2, com_tx=2)

4 ETW000 323 0.500826

4 ETW000 [dev trc ,00000] statistics db_con_rollback (roll_total=0, roll_tx=0)

4 ETW000 75 0.500901

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 12.11.2008 - 15:31:04

1 ETP150 MAIN EXPORT

1 ETP110 end date and time : "20081112153104"

1 ETP111 exit code : "0"

1 ETP199 ######################################

Regards

Siva

markus_doehr2
Active Contributor
‎11-14-2008 2:32 PM
0 Kudos

This looks all good to me.

I think the state of the transport is wrong in SE09/SE10 (or wherever you released the transport).

Can you import the request?

Markus

sivakumar_kilari3
Active Contributor
‎11-14-2008 2:38 PM
0 Kudos

Markus,

Task has released but request not released.

sm50 status,

Report:SAPLTR_PROJECT_LOCKS

Table: TLOCKPC

Regards

Siva

former_member204746
Active Contributor
‎11-14-2008 1:40 PM
0 Kudos

check transport logs from /usr/sap/trans/tmp and /usr/sap/trans/log

Show replies
Show replies
sivakumar_kilari3
Active Contributor
‎11-14-2008 1:50 PM
0 Kudos

Hi Eric,

Thanks for your reply.

I didn't get any error in logs.

Regards

Siva

Ask a Question