NW2004s (XUSER error (incorrect USER data owner))

[Former Member]

Hi Experts,

I have little problem with NW7.0. After restart the server, the SAP coudn't start.. All WP died, after start, and Disp+Work down...

i try to recreate the database user( note 39439) with xuser but not solved the problem... r3trans finished (0000).. everything looks like fine but the sap not run.

The all WP died wit the following error:

C Try to connect (DEFAULT) on connection 0 ...

C *** ERROR => Connect to database failed, rc = -10757 (XUSER error (incorrect USER data owner))

C Try to connect (SQLOPT) on connection 0 ...

C *** ERROR => Connect to database failed, rc = -10757 (XUSER error (incorrect USER data owner))

B ***LOG BY2=> sql error -10757 performing CON

B ***LOG BY0=> XUSER error (incorrect USER data owner)

B

B Mon Nov 03 11:16:16 2008

B ***LOG BY2=> sql error -10757 performing CON

B ***LOG BY0=> XUSER error (incorrect USER data owner)

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256)

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1)

The system is win2k3, SAPDB,UC, 64bit.

Could you help me please

Thanks and best regards

László Lantos

[former_member906139 · Accepted solution]

login with sidadm

Check DB connection with "R3trans -d".

It should return return code 0000.

It not then check trans.log at same location.

If it is giving DB connection error, then

Check with command "xuser list".

this will give list of users assign with userkeys.

The DEFAULT userkey (first one) should be assign to schema user (sapsid).

[Former Member · Accepted solution]

thank you for help, but not solved the issue...

C:\sapdb\programs\bin>r3trans -d

This is r3trans version 6.14 (release 700 - 14.02.08 - 14:55:00).

unicode enabled version

2EETW169 no connect possible: "DBMS = ADABAS D --- DBNAM

E = ''"

r3trans finished (0012).

C:\sapdb\programs\bin>xuser list

Warning: Open xuser entry file failed: incorrect USER data owner

C:\sapdb\programs\bin>xuser clear

C:\sapdb\programs\bin>xuser -U DEFAULT -u SAPSOS,Amazon123 -d SOS -n testgep -S

SAPR3 -t 0 set

C:\sapdb\programs\bin>xuser -U w -u SUPERDBA,Amazon123 -d SOS -n testgep -S SAPR

3 set

C:\sapdb\programs\bin>xuser -U c -u CONTROL,Amazon123 -d SOS -n testgep -S SAPR3

-t 0 set

C:\sapdb\programs\bin>xuser list

-

---

XUSER Entry 1

-

---

Key :DEFAULT

Username :SAPSOS

UsernameUCS2:S.A.P.S.O.S. . . . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :SOS

Nodename :testgep

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation :-1

Charset :<unspecified>

-

---

XUSER Entry 2

-

---

Key :w

Username :SUPERDBA

UsernameUCS2:S.U.P.E.R.D.B.A. . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :SOS

Nodename :testgep

Sqlmode :SAPR3

Cachelimit :-1

Timeout :-1

Isolation :-1

Charset :<unspecified>

-

---

XUSER Entry 3

-

---

Key :c

Username :CONTROL

UsernameUCS2:C.O.N.T.R.O.L. . . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :SOS

Nodename :testgep

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation :-1

Charset :<unspecified>

C:\sapdb\programs\bin>r3trans -d

This is r3trans version 6.14 (release 700 - 14.02.08 - 14:55:00).

unicode enabled version

r3trans finished (0000).

But after start sap ths disp+work and all WP die, and the WP log is same error:

Try to connect (SQLOPT) on connection 0 ...

C *** ERROR => Connect to database failed, rc = -10757 (XUSER error (incorrect USER data owner))

[dbsdbsql.cpp 137]

B ***LOG BY2=> sql error -10757 performing CON [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY0=> XUSER error (incorrect USER data owner) [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY2=> sql error -10757 performing CON [dblink#5 @ 431] [dblink 0431 ]

B ***LOG BY0=> XUSER error (incorrect USER data owner) [dblink#5 @ 431] [dblink 0431 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1440]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10468]

M

thanks,

LL

[former_member906139]

Can you please check schema in environment variable and in profiles, I think as work processes are not able to connect, the schema maintain in profile must be different than sap<sid>.

[Ayax]

After executing command R3trans -d check trans.log for errors.

Regards,

Ayax

[Former Member]

first r3trans -d error:

4 ETW000 [dbsdbsql ,00000] *** ERROR => Connect to database failed, rc = -10757 (XUSER error (incorrect USER data owner))

4 ETW000 9293 0.476691

4 ETW000 [dev trc ,00000] Try to connect (SQLOPT) on connection 0 ... 21 0.476712

4 ETW000 [dbsdbsql ,00000] *** ERROR => Connect to database failed, rc = -10757 (XUSER error (incorrect USER data owner))

4 ETW000 444 0.477156

after

xuser clear

xuser -U DEFAULT -u SAPSOS,Amazon123 -d SOS -n testgep -S SAPR3 -t 0 set

dbmcli -n testgep -d SOS -u SUPERDBA,Amazon123 -uk DEFAULT -us SAPSOS,Amazon123

then

C:\sapdb\programs\bin>r3trans -d

This is r3trans version 6.14 (release 700 - 14.02.08 - 14:55:00).

unicode enabled version

r3trans finished (0000).

But, the all WP die with:

• ERROR => Connect to database failed, rc = -10757 (XUSER error (incorrect USER data owner))

[dbsdbsql.cpp 113]

i think not, enough set DEFAULT user_key.. i think need some refresh or reload!?

thanks

LL