cancel
Showing results for 
Search instead for 
Did you mean: 

creation of R3trans (R3trans) process failed: No such file or directory

former_member184628
Participant
0 Kudos

Hi All,

While releasing the transport we are getting this error in our BI Development Server. The child Transport number is getting released but while releasing the parent transport it is throwing the below mentioned error.

######################################

Main export

Transport request : SIDK908697

System : SID

tp path : tp

Version and release: 372.04.88 700

creation of R3trans (R3trans) process failed: No such file or directory

Main export

End date and time : 20111224122747

Ended with return code: ===> 230 <===

######################################

When I am executing R3trans -d from SIDadm it is successful, return code is (0000). and also for your information we have two AS running on the same server.(DEV and QAS), also we have recently upgraded our Oracle also.

Need your help in resolving the issue.

Thanks,

Sharib Tasneem

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member188883
Active Contributor
0 Kudos

Hi,

This seems to be permission problem on trans directory.

Ensure the following

1) In STMS . Check transport tool is working fine

2) Ensure 777 permission on /usr/sap/trans.

Regards,

Deepak Kori

former_member184628
Participant
0 Kudos

Hi,

I checked the SLOG1201.SID in the /usr/sap/trans/log driectory and found the below error message:

ERROR: uncaught internal error: ORA-03114: not connected to ORACLE

ERROR: EXIT(16) -> process ID is: 18350278

ERROR: No entry for BWDK908699 in E070 or error during access.

ERROR BWDK908699 BWD E 0230 20120102113405 USERNAME USERNAME mbiwdq 20120102113400423

ERROR: stopping on error 230 during MAIN EXPORT

HALT 20120102113405

ERROR: uncaught internal error: ORA-03114: not connected to ORACLE

ERROR: EXIT(16) -> process ID is: 18677788

ERROR: No entry for BWDK908697 in E070 or error during access.

ERROR BWDK908697 BWD E 0230 20120102115320 USERNAME USERNAME mbiwdq 20120102115315225

ERROR: stopping on error 230 during MAIN EXPORT

Please let me know on how can I proceed.

Thanks,

Sharib tasneem

Former Member
0 Kudos

Hi,

Please follow the blow mentioned thread, its the same issue and got resolved.

Follow the instruction given by Markus in the thread.

Regards,

Amit Barnawal

former_member189725
Active Contributor
0 Kudos

Please issue the command as <sdi>adm and check the dev_tp file for the output .

tp CONNECT <SID> silent pf=TP_DOMAIN_<SID>.PFL

Please paste the log of the output.

Probably the table E070 is not accessible as there is a connectivity issue with the database.

former_member184628
Participant
0 Kudos

Hi,

Please find the log

mbiwdq:bwdadm 20> pwd

/usr/sap/trans/bin

mbiwdq:bwdadm 21> tp CONNECT BWD silent pf=TP_DOMAIN_BWD.PFL

initial value of NLS_LANG: 'AMERICAN_AMERICA.UTF8'

Best regards,

Sharib tasneem

former_member189725
Active Contributor
0 Kudos

There will be a file dev_tp in the directory /usr/sap/trans/bin .

Please paste the content of the file.

former_member184628
Participant
0 Kudos

Hi,

mbiwdq:bwdadm 36> cat dev_tp | pg

This is tp version 372.04.88 (release 700, unicode enabled)

Warning: Parameter DBLIBPATH is no longer used.

Connection to Database of BWD was successful.

tp finished with return code: 0

meaning:

Everything OK

Thanks

Sharib tasneem

Edited by: T.sharib on Jan 3, 2012 8:25 AM

Edited by: T.sharib on Jan 3, 2012 8:26 AM

Former Member
0 Kudos

Hi

Check if the following directories exist and have right permission set,

/usr/sap/trans/sapnames/<user ID of the person, who is releasing that TR> (should have 777) permission for that file.

Also, check (with permission 777)

/usr/sap/trans/log

/usr/sap/trans/tmp

/usr/sap/trans/data

/usr/sap/trans/cofiles

if, there is any file, related to that TR. Do this, ls -l <TR number>. . if there is any file try to rename it with extn ".old', and release the TR once again.

Run this report , SE38 > RSTPTEST and see if everything is green.

If still you are unable to then check, RDD* jobs are scheduled in the system.

~Rajesh

former_member184628
Participant
0 Kudos

Hi Rajesh,

The permission are proper with 777 across trans directory.

It has not released any transport in the system. Also I tried SE38 > RSTPTEST, the output is all green.

Also I checked that SM37 for the jobs, there is not job running/ready/cancelled/finished/released or planned in the system which starts with RDD* from last 1 month.

Best Regards,

Sharib Tasneem

Former Member
0 Kudos

Hello Sharib,

Please run the report RDDNEWPP. It will schedule RDDIMPDP job. I suggest you to unmount and remount /usr/sap/trans if you haven't done yet.

Thanks,

Siva Kumar

former_member184628
Participant
0 Kudos

Hi Shiv,

Even After scheduling the Job with Normal priority in the 000 and other client is throwing the same error during release of the TP.

Main export

Transport request : BWDK908707

System : BWD

tp path : tp

Version and release: 372.04.88 700

creation of R3trans (R3trans) process failed: No such file or directory

Main export

End date and time : 20120103154651

Ended with return code: ===> 230 <===

Any Other suggestion?

Thanks,

Sharib tasneem

Former Member
0 Kudos

Hello Sharib,

Please make sure RDDIMPDP is scheduled in that client as well and give a try.

Thanks,

Siva Kumar

Former Member
0 Kudos

Hi,

Go to AL11 on the appserver and check if you are able to navigate to the trans directory?

Regards,

Vamshi.

former_member189725
Active Contributor
0 Kudos

Can you try to release the request again . Seems there was a problem connecting to the database . It now seems that tp is able to connect to the database.

Edited by: Ratnajit Dey on Jan 3, 2012 4:32 PM

former_member184628
Participant
0 Kudos

Hi Siva,

I have scheduled the task in client 000 with DDIC user and in other client with my login id.

But Still the Release of TP is failing.

Thanks,

Sharib

former_member184628
Participant
0 Kudos

Hi Vamshi,

Through AL11 I can navigate to all the dirctories in TRANS_DIR.

Thanks,

Sharib

Former Member
0 Kudos

Hello Sharib,

Can you update R3trans and tp patch level and give a try?

Thanks,

Siva Kumar

Former Member
0 Kudos

Hi

Can you please place you dev_tp log, here ? Also, if you are trying to release the TR from App server, better switch to central instance and repeat that.

go to SM51 > select central instance and double click on that. Repeat the export process again.

Is this issue a user specific or its happening across all the user and for all TRs ?

~Rajesh

former_member189725
Active Contributor
0 Kudos

Please check under /usr/sap/trans , there are data and cofiles directories present.

Also check the tp logs for more information under /usr/sap/trans/log.

former_member184628
Participant
0 Kudos

Hi,

I checked the log and found that msg:

1 ETP182 CHECK WRITEABILITY OF BUFFERS

1 ETP101 transport order : "BWDK908697"

1 ETP102 system : "BWD"

1 ETP108 tp path : "tp"

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

1 ETP198

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

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

1 ETP182 CHECK WRITEABILITY OF BUFFERS

1 ETP110 end date and time : "20111224130058"

1 ETP111 exit code : "0"

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

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

1 ETP183 EXPORT PREPARATION

1 ETP101 transport order : "BWDK908697"

1 ETP102 system : "BWD"

1 ETP108 tp path : "tp"

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

1 ETP198

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

4 EPU111 on the application server: "mbiwdq"

4 EPU138 in client : "100"

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

3 EPU237 Version creation started as update request

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

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

WDK908697"

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

K908697"

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

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

4WETO087 Attribute "EXPORT_TIMESTAMP" can only be assigned once per request

1 ETP183 EXPORT PREPARATION

1 ETP110 end date and time : "20111224130100"

1 ETP111 exit code : "4"

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

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

1 ETP150 MAIN EXPORT

1 ETP101 transport order : "BWDK908697"

1 ETP102 system : "BWD"

1 ETP108 tp path : "tp"

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

1 ETP198

1AETP000 creation of R3trans (R3trans) process failed: No such file or directory

2EETP200 Export with errors, request will not be imported

1 ETP150 MAIN EXPORT

1 ETP110 end date and time : "20111224130106"

1 ETP111 exit code : "230"

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

Thanks,

Sharib

Edited by: T.sharib on Jan 2, 2012 9:30 AM