We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

Re: [sap-basis] TP unlocksys gives the return code 232

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Posted by adhanuka
on May 9 at 11:59 PM
Mark this reply as helpfulMark as helpful
its because its trying to find a DB with SID = d65_shd which is your shadow
instance.
Check for the environment variables and correct the same and retry...

On Mon, May 10, 2010 at 11:13 AM, seshu_t via sap-basis <
sap-basis@groups.ittoolbox.com> wrote:

> Posted by seshu_t
> on May 9 at 11:11 PM
> Hi all,
>
> We're upgrading 4.7EE to ECC6 ehp4, now we're in the downtime road map
> stage,at MAIN_NEWBAS/PRODCHK_UPG ,the error as below
>
> Last error code set: Release of SAP_HRCAR was not found in the database
> Release of SAP_HRCAT was not found in the database Release of SAP_HRCAU was
> not found in the database Release of SAP_HRCBE was not found in the database
>
>
> so we are following a note 1433921,saying us to create and run a new
> report, to do this we need to unlock the system using TP command,but we got
> an error as below...
>
> E:\usr\sap\D65\SYS\exe\run>tp UNLOCKSYS D65
> pf=E:\usr\sap\trans\bin\TP_DOMAIN_D6
> 5.PFL
> sapparam: sapargv( argc, argv) has not been called.
> sapparam(1c): No Profile used.
> sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
> This is tp version 372.04.40 (release 701)
> ERROR: Connect to D65 failed (20100510084126, probably wrong environment).
> TRACE-INFO: 1: [dev trc ,00000] Mon May 10 08:41:26 2010
> 4390 0.004390
> TRACE-INFO: 2: [dev trc ,00000] load shared library (dbmssslib.dll), hdl 0
> , addr 10C70000
> TRACE-INFO: 3:
> 10 0.004400
> TRACE-INFO: 4: [dev trc ,00000] using "E:\usr\sap\D65\SYS\exe\run\dbms
> sslib.dll" 9 0.004409
> TRACE-INFO: 5: [dev trc ,00000] Thread ID:13992
> 4376 0.008785
> TRACE-INFO: 6: [dev trc ,00000] Thank You for using the SLOLEDB-interface
> 11 0.008796
> TRACE-INFO: 7: [dev trc ,00000] Using dynamic link library 'E:\usr\sap\D65
> \SYS\exe\run\dbmssslib.dll'
> TRACE-INFO: 8:
> 26 0.008822
> TRACE-INFO: 9: [dev trc ,00000] dbmssslib.dll patch info
> 14 0.008836
> TRACE-INFO: 10: [dev trc ,00000] patchlevel 0
> 8 0.008844
> TRACE-INFO: 11: [dev trc ,00000] patchno 31
> 10 0.008854
> TRACE-INFO: 12: [dev trc ,00000] patchcomment Handle long parameters as
> LOBs (1296540) 10 0.008864
> TRACE-INFO: 13: [dev trc ,00000] np:(local) connection used on WILLSYS65
> 71 0.008935
> TRACE-INFO: 14: [dev trc ,00000] CopyLocalParameters: dbuser is 'd65_shd'
> 10 0.008945
> TRACE-INFO: 15: [dev trc ,00000] Using Provider SQLNCLI
> 7126 0.016071
> TRACE-INFO: 16: [dev trc ,00000] OpenOledbConnection: MARS property was se
> t successfully. 147 0.016218
> TRACE-INFO: 17: [dev trc ,00000] ExecuteAndFlush return code: 0x80040e14 S
> tmt: [if user_name() != 'd65_shd' setuser 'd65_shd']
> TRACE-INFO: 18:
> 98082 0.114300
> TRACE-INFO: 19: [dev trc ,00000] ExecuteAndFlush: line 6601. hr: 0x80040e1
> 4 Setuser failed because of one of the following reasons: the database
> principal
> 'd65_shd' does not exist, its corresponding server principal does not have
> serv
> er access, this type of database principal cannot be impersonated, or you
> do not
> have permission.
> TRACE-INFO: 20:
> 53 0.114353
> TRACE-INFO: 21: [dev trc ,00000] sloledb.cpp [ExecuteAndFlush,line 6601]:
> Error/Message: (err 15157, sev 0), Setuser failed because of one of the
> followin
> g reasons: the database principal 'd65_shd' does not exist, its
> corresponding se
> rver principal does not have server access, this type of database principal
> cann
> ot be impersonated, or you do not have permission.
> TRACE-INFO: 22:
> 42 0.114395
> TRACE-INFO: 23: [dev trc ,00000] Procname: [ExecuteAndFlush - no proc]
> 12 0.114407
> TRACE-INFO: 24: [dev trc ,00000] setuser 'd65_shd' failed -- connect termi
> nated 18 0.114425
> TRACE-INFO: 25: [dev trc ,00000] Using Provider SQLNCLI
> 8498 0.122923
> TRACE-INFO: 26: [dev trc ,00000] OpenOledbConnection: MARS property was se
> t successfully. 121 0.123044
> TRACE-INFO: 27: [dev trc ,00000] ExecuteAndFlush return code: 0x80040e14 S
> tmt: [if user_name() != 'd65_shd' setuser 'd65_shd']
> TRACE-INFO: 28:
> 3991 0.127035
> TRACE-INFO: 29: [dev trc ,00000] ExecuteAndFlush: line 6601. hr: 0x80040e1
> 4 Setuser failed because of one of the following reasons: the database
> principal
> 'd65_shd' does not exist, its corresponding server principal does not have
> serv
> er access, this type of database principal cannot be impersonated, or you
> do not
> have permission.
> TRACE-INFO: 30:
> 44 0.127079
> TRACE-INFO: 31: [dev trc ,00000] sloledb.cpp [ExecuteAndFlush,line 6601]:
> Error/Message: (err 15157, sev 0), Setuser failed because of one of the
> followin
> g reasons: the database principal 'd65_shd' does not exist, its
> corresponding se
> rver principal does not have server access, this type of database principal
> cann
> ot be impersonated, or you do not have permission.
> TRACE-INFO: 32:
> 37 0.127116
> TRACE-INFO: 33: [dev trc ,00000] Procname: [ExecuteAndFlush - no proc]
> 9 0.127125
> TRACE-INFO: 34: [dev trc ,00000] setuser 'd65_shd' failed -- connect termi
> nated 15 0.127140
> TRACE-INFO: 35: [dev trc ,00000] Using Provider SQLNCLI
> 11570 0.138710
> TRACE-INFO: 36: [dev trc ,00000] OpenOledbConnection: MARS property was se
> t successfully. 106 0.138816
> TRACE-INFO: 37: [dev trc ,00000] ExecuteAndFlush return code: 0x80040e14 S
> tmt: [if user_name() != 'd65_shd' setuser 'd65_shd']
> TRACE-INFO: 38:
> 3952 0.142768
> TRACE-INFO: 39: [dev trc ,00000] ExecuteAndFlush: line 6601. hr: 0x80040e1
> 4 Setuser failed because of one of the following reasons: the database
> principal
> 'd65_shd' does not exist, its corresponding server principal does not have
> serv
> er access, this type of database principal cannot be impersonated, or you
> do not
> have permission.
> TRACE-INFO: 40:
> 37 0.142805
> TRACE-INFO: 41: [dev trc ,00000] sloledb.cpp [ExecuteAndFlush,line 6601]:
> Error/Message: (err 15157, sev 0), Setuser failed because of one of the
> followin
> g reasons: the database principal 'd65_shd' does not exist, its
> corresponding se
> rver principal does not have server access, this type of database principal
> cann
> ot be impersonated, or you do not have permission.
> TRACE-INFO: 42:
> 36 0.142841
> TRACE-INFO: 43: [dev trc ,00000] Procname: [ExecuteAndFlush - no proc]
> 9 0.142850
> TRACE-INFO: 44: [dev trc ,00000] setuser 'd65_shd' failed -- connect termi
> nated 14 0.142864
> TRACE-INFO: 45: [dev trc ,00000] failed to establish conn to np:(local).
> 11234 0.154098
> TRACE-INFO: 46: [dev trc ,00000] Retrying without protocol specifier: (loc
> al) 17 0.154115
> TRACE-INFO: 47: [dev trc ,00000] Using Provider SQLNCLI
> 118 0.154233
> TRACE-INFO: 48: [dev trc ,00000] OpenOledbConnection: MARS property was se
> t successfully. 134 0.154367
> TRACE-INFO: 49: [dev trc ,00000] ExecuteAndFlush return code: 0x80040e14 S
> tmt: [if user_name() != 'd65_shd' setuser 'd65_shd']
> TRACE-INFO: 50:
> 7111 0.161478
> TRACE-INFO: 51: [dev trc ,00000] ExecuteAndFlush: line 6601. hr: 0x80040e1
> 4 Setuser failed because of one of the following reasons: the database
> principal
> 'd65_shd' does not exist, its corresponding server principal does not have
> serv
> er access, this type of database principal cannot be impersonated, or you
> do not
> have permission.
> TRACE-INFO: 52:
> 38 0.161516
> TRACE-INFO: 53: [dev trc ,00000] sloledb.cpp [ExecuteAndFlush,line 6601]:
> Error/Message: (err 15157, sev 0), Setuser failed because of one of the
> followin
> g reasons: the database principal 'd65_shd' does not exist, its
> corresponding se
> rver principal does not have server access, this type of database principal
> cann
> ot be impersonated, or you do not have permission.
> TRACE-INFO: 54:
> 36 0.161552
> TRACE-INFO: 55: [dev trc ,00000] Procname: [ExecuteAndFlush - no proc]
> 9 0.161561
> TRACE-INFO: 56: [dev trc ,00000] setuser 'd65_shd' failed -- connect termi
> nated 15 0.161576
> TRACE-INFO: 57: [dev trc ,00000] Using Provider SQLNCLI
> 8267 0.169843
> TRACE-INFO: 58: [dev trc ,00000] OpenOledbConnection: MARS property was se
> t successfully. 131 0.169974
> TRACE-INFO: 59: [dev trc ,00000] ExecuteAndFlush return code: 0x80040e14 S
> tmt: [if user_name() != 'd65_shd' setuser 'd65_shd']
> TRACE-INFO: 60:
> 4208 0.174182
> TRACE-INFO: 61: [dev trc ,00000] ExecuteAndFlush: line 6601. hr: 0x80040e1
> 4 Setuser failed because of one of the following reasons: the database
> principal
> 'd65_shd' does not exist, its corresponding server principal does not have
> serv
> er access, this type of database principal cannot be impersonated, or you
> do not
> have permission.
> TRACE-INFO: 62:
> 37 0.174219
> TRACE-INFO: 63: [dev trc ,00000] sloledb.cpp [ExecuteAndFlush,line 6601]:
> Error/Message: (err 15157, sev 0), Setuser failed because of one of the
> followin
> g reasons: the database principal 'd65_shd' does not exist, its
> corresponding se
> rver principal does not have server access, this type of database principal
> cann
> ot be impersonated, or you do not have permission.
> TRACE-INFO: 64:
> 37 0.174256
> TRACE-INFO: 65: [dev trc ,00000] Procname: [ExecuteAndFlush - no proc]
> 9 0.174265
> TRACE-INFO: 66: [dev trc ,00000] setuser 'd65_shd' failed -- connect termi
> nated 15 0.174280
> TRACE-INFO: 67: [dev trc ,00000] Using Provider SQLNCLI
> 11128 0.185408
> TRACE-INFO: 68: [dev trc ,00000] OpenOledbConnection: MARS property was se
> t successfully. 115 0.185523
> TRACE-INFO: 69: [dev trc ,00000] ExecuteAndFlush return code: 0x80040e14 S
> tmt: [if user_name() != 'd65_shd' setuser 'd65_shd']
> TRACE-INFO: 70:
> 4097 0.189620
> TRACE-INFO: 71: [dev trc ,00000] ExecuteAndFlush: line 6601. hr: 0x80040e1
> 4 Setuser failed because of one of the following reasons: the database
> principal
> 'd65_shd' does not exist, its corresponding server principal does not have
> serv
> er access, this type of database principal cannot be impersonated, or you
> do not
> have permission.
> TRACE-INFO: 72:
> 37 0.189657
> TRACE-INFO: 73: [dev trc ,00000] sloledb.cpp [ExecuteAndFlush,line 6601]:
> Error/Message: (err 15157, sev 0), Setuser failed because of one of the
> followin
> g reasons: the database principal 'd65_shd' does not exist, its
> corresponding se
> rver principal does not have server access, this type of database principal
> cann
> ot be impersonated, or you do not have permission.
> TRACE-INFO: 74:
> 36 0.189693
> TRACE-INFO: 75: [dev trc ,00000] Procname: [ExecuteAndFlush - no proc]
> 9 0.189702
> TRACE-INFO: 76: [dev trc ,00000] setuser 'd65_shd' failed -- connect termi
> nated 15 0.189717
> TRACE-INFO: 77: [dev trc ,00000] failed to establish conn. 0
> 11223 0.200940
> TRACE-INFO: 78: [dblink ,00431] ***LOG BY2=>sql error -1 performing C
> ON [dblink#3 @ 431]
> TRACE-INFO: 79:
> 188 0.201128
> TRACE-INFO: 80: [dblink ,00431] ***LOG BY0=>Setuser failed because of one
> of the following reasons: the database principal 'd65_shd' does not exist,
> its
> corresponding server principal does not have server access, this type of
> databas
> e principal cannot be impersonated, or you do not have permission.
> [dblink#3 @ 4
> 31]
> TRACE-INFO: 81:
> 23 0.201151
>
> tp returncode summary:
>
> TOOLS: Highest return code of single steps was: 0
> ERRORS: Highest tp internal error was: 0232
> tp finished with return code: 232
> meaning:
> connect failed
>
> Please give us a resolution ASAP..
__.____._
Copyright © 2010 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251

0 comments:

Post a Comment

T r a n s l a t e to your language