- SAP Community
- Products and Technology
- Additional Q&A
- Error :: R3trans -d
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Error :: R3trans -d
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
on 12-01-2009 10:14 AM
Hi All,
After performing Database Refresh, I dropped the source OPS$ user and re-created OPS$ user. But SAP Application is not starting as I am getting error which executing the command R3trans -d.
Find the error below:
<hostname>:(no_env):/root $ su - sidadm
<hostname>:sidadm> R3trans -d
This is R3trans version 6.09 (release 640 - 26.10.04 - 15:45:42).
2EETW000 sap_dext called with msgnr "2":
2EETW000 -
db call info -
2EETW000 function: db_ntab
2EETW000 fcode: NT_RDTDESCR
2EETW000 tabname: TADIR
2EETW000 len: 5
2EETW000 key: TADIR
2EETW000 retcode: 2
R3trans finished (0012).
<hostname>:sidadm> tail -50f trans.log
4 ETW000 33 0.095370
4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 2
4 ETW000 34 0.095404
4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 3
4 ETW000 28 0.095432
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 701 0.096133
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 252 0.096385
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 247 0.096632
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 246 0.096878
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 245 0.097123
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 247 0.097370
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 246 0.097616
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 246 0.097862
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 245 0.098107
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 272 0.098379
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 263 0.098642
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 248 0.098890
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 247 0.099137
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 246 0.099383
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 246 0.099629
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 247 0.099876
4 ETW000 [dbntab ,01000] ***LOG BZY=>unexpected return code 103 calling DbSlRead [dbntab#7 @ 10007]
4 ETW000 412 0.100288
2EETW000 sap_dext called with msgnr "2":
2EETW000 -
db call info -
2EETW000 function: db_ntab
2EETW000 fcode: NT_RDTDESCR
2EETW000 tabname: TADIR
2EETW000 len: 5
2EETW000 key: TADIR
2EETW000 retcode: 2
4 ETW000 [dev trc ,00000] db_con_rollback (con_da={R/3,0,0},th_rollback=1,tx=0)
4 ETW000 238 0.100526
4 ETW000 ROLLBACK (0).
Kindly look into the issue. Looking forward for your reply.
Thanks,
Soumya
Accepted Solutions (0)
Answers (6)
Answers (6)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hello Somya,
Did you change the db schema environment variable for both sidadm and orasid ? This needs to be done after DB refresh in case the schemas are different. Further you need to run ORADBUSR.SQL Check OSS note 361641 for that.
Regards.
Ruchit.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hi,
As replied by Markus, update your kernel.....
For present: paste only ERROR lines from dev_w0 log
Regards
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hello,
What is version of your SAP system.
If you are using system before NW04s, then schema will be SAP<SID>. In this case as you have done system refresh, schema will be different in DB and in environment variable for sidadm and orasid.
So adjust env variable as per your source system. and then give R3trans -d.
If error still persist, post whole log foir R3trans -d.
Regards,
Abhay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hi.
[SAP note 534765|https://websmp230.sap-ag.de/sap%28bD1kZSZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=534765] describes these errors and says that the db scheme is wrong...
I would check this first.
If that doesn't help write the necessary infos about your system (Release, OS, database (version), ...)
best regards,
Martin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
> This is R3trans version 6.09 (release 640 - 26.10.04 - 15:45:42).
you are using ANCIENT software versions (2004 - 5 years old!)
I suggest you update your kernel, the dbsl and then try again.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hi,
sidadm> tail -50f trans.log
Can you paste all of the trans.log
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hi Mark,
Find the below error log :
p19844dev131:t11adm> tail -50f trans.log
4 ETW000 33 0.095370
4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 2
4 ETW000 34 0.095404
4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 3
4 ETW000 28 0.095432
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 701 0.096133
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 252 0.096385
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 247 0.096632
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 246 0.096878
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 245 0.097123
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 247 0.097370
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 246 0.097616
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 246 0.097862
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 245 0.098107
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 272 0.098379
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 263 0.098642
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 248 0.098890
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 247 0.099137
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 246 0.099383
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 246 0.099629
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 247 0.099876
4 ETW000 [dbntab ,01000] ***LOG BZY=>unexpected return code 103 calling DbSlRead [dbntab#7 @ 10007]
4 ETW000 412 0.100288
2EETW000 sap_dext called with msgnr "2":
2EETW000 -
db call info -
2EETW000 function: db_ntab
2EETW000 fcode: NT_RDTDESCR
2EETW000 tabname: TADIR
2EETW000 len: 5
2EETW000 key: TADIR
2EETW000 retcode: 2
4 ETW000 [dev trc ,00000] db_con_rollback (con_da={R/3,0,0},th_rollback=1,tx=0)
4 ETW000 238 0.100526
4 ETW000 ROLLBACK (0).
Thanks,
Soumya
Edited by: Soumya Saha on Dec 2, 2009 10:57 AM
Edited by: Soumya Saha on Dec 2, 2009 10:58 AM
Edited by: Soumya Saha on Dec 2, 2009 10:58 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hi Mark,
This is what I am getting on doing tail -50f trans.log......
<hostname>:t11adm> tail -50f trans.log
4 ETW000 33 0.095370
4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 2
4 ETW000 34 0.095404
4 ETW000 [dev trc ,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 3
4 ETW000 28 0.095432
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 701 0.096133
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 252 0.096385
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 247 0.096632
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 246 0.096878
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 245 0.097123
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 247 0.097370
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 246 0.097616
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 246 0.097862
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 245 0.098107
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 272 0.098379
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 263 0.098642
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 248 0.098890
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 247 0.099137
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 246 0.099383
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 246 0.099629
4 ETW000 [dbntab ,01028] ***LOG BZY=>unexpected return code 103 calling DbSlExeRd [dbntab#7 @ 10281]
4 ETW000 247 0.099876
4 ETW000 [dbntab ,01000] ***LOG BZY=>unexpected return code 103 calling DbSlRead [dbntab#7 @ 10007]
4 ETW000 412 0.100288
2EETW000 sap_dext called with msgnr "2":
2EETW000 -
db call info -
2EETW000 function: db_ntab
2EETW000 fcode: NT_RDTDESCR
2EETW000 tabname: TADIR
2EETW000 len: 5
2EETW000 key: TADIR
2EETW000 retcode: 2
4 ETW000 [dev trc ,00000] db_con_rollback (con_da={R/3,0,0},th_rollback=1,tx=0)
4 ETW000 238 0.100526
4 ETW000 ROLLBACK (0).
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
- A report object, section or area with this name already exists in the report error in AR Invoice in Enterprise Resource Planning Q&A
- Creation Failed: Couldn't create an instance of Cloud Identity Services with plan Application in Human Capital Management Blogs by Members
- Using Integration Suite API's with Basic Auth in Technology Q&A
- Strategy to resolve taxes not being sent correctly on Ariba in Supply Chain Management Q&A
- CEWB: error in component allocation without change number in Enterprise Resource Planning Q&A
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.