on 01-02-2012 7:43 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.