cancel
Showing results for 
Search instead for 
Did you mean: 

Problem running xuser commands

Former Member
0 Kudos

Hi,

I´m freshman in Maxdb and I´m working with an old version (SAP DB 7.3.0.62).

When I try to start SAP instance I get the error,

*** ERROR => Connect to database failed : sqlcode=-4008 (Unknown user name/password combination)

[dbslada.c    6083]

I guess I´ll solve my problem with note 39439 but when I try to run any xuser command a new command window opens asking for a login. This window:

             /SSSSSSS     /A     /PPPPPPP           /DDDDDDDD   /BBBBBBBB

            /SS//////    /AAA    /PP////PP          /DD/////DD  /BB/////BB

            /SS         /AA AA   /PP   /PP          /DD    /DD  /BB    /BB

             /SSSSSS   /AA  /AA  /PPPPPPP/  /SSSSS  /DD    /DD  /BBBBBBBB/

              /////SS  /AAAAAAA  /PP////    //////  /DD    /DD  /BB/////BB

                  /SS  /AA  /AA  /PP                /DD    /DD  /BB    /BB

            /SSSSSSS/  /AA  /AA  /PP                /DDDDDDDD/  /BBBBBBBB/

            ////////   ///  ///  ///                /////////   /////////

                          /SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS

                   /SSSSSSSS          U  S  E  R             SSSSSSSS//////

            /SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS//////

            /////////////////////////////////////////////////

       Username ==>                       Password ==>

 

I enter control or superdba users (I know password is correct because I can connect via dbmcli) but I get message USERNAME/PASSWORD ILLEGAL.

Anybody knows why I can´t execute xuser commands?

I´ll appreciate any help.

Thanks in advance,

Pablo.

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member603657
Participant
0 Kudos

Hello Natalia,

During ERP6.0 EHP8 Update using SUM tool, we get the error "Last error code set: XUSER key 'DEFAULT' does not exist or could not be identified" in SUM Phase "MOD_SELROADMAP/SELECT_ROADMAP!" (see screenshot in attachment).

Currently the SAP system running with latest MaxDB version in Windows Server 2019. Environment variables are correclty maintained in the server. Following result, we get with xuser command:

E:\sapdb\SID\db\bin>xuser -U DEFAULT list
------------------------------------------------
XUSER Entry 1
----------------
Key : DEFAULT
Username : <unspecified>
Password : <unspecified>
Dbname : <unspecified>
Nodename : <unspecified>
Sqlmode : <unspecified>
Cachelimit : -1
Timeout : -1
Isolation : -1

Any ideas are appreciated.

Thanks

Sreenivas

former_member229109
Active Contributor
0 Kudos

Hello Pablo,

when you are using 7.3 xuser version, you could logon xuser programm with sapr3 user and sap password, if the default password was not changed & default key xuser entries were created correctly

before for your OS login user. Or you need to know the correct password of the default key XUSER entry.

Please follow the note 25591 when you will change the passwords of database users,

and don't forget to update the XUSER data on all application servers in accordance with Note 39439

after you changed the passwords of the database users.

Regards, Natalia Khlopina

yashwanthkumar_kethineed
Active Participant
0 Kudos

Hi Pablo,

SAP DB 7.3 is quiet an old version. Update to a newer release if possible.

From the above information it is not clear for me which XUSER command are your running. Let me know the exact command.

Have you already created the XUSER entries for users <sid>adm and SAPService<sid> ?

Attach the output of command "xuser -ul".

http://www.sapdb.org/pdf/dbmcli_73eng.pdf (Page 24)

Connect to the database as DBM user and run the following sql command and attach the output-

dbmcli on DB> sql_execute select * from users

Regards,

Yashwanth