SAP VERSION : -4001,Unknown user name/password combination in operational state ADMIN

[rlabarca]

Hi experts,

i'm getting the following error when performing an In-place upgrade from 7.7 to 7.9.

SAP VERSION     : -4001,Unknown user name/password combination in operational state ADMIN

The db is in admin mode, the user and password of the control user are Ok, they where checked in dbmcli and in SAP.

It's a single DB instance, SAP is shut down.

If i skip this error then i get another error

ERR:  Upgrade failed

ERR:    Error checking Upgrade

ERR:      There are files locked by the following processes:

ERR:      | Process Id | Command Line

ERR:      | 243        | /sapdb/<SID>/db/pgm/kernel <SID> -diagpipe 14

ERR:      | 244        | /sapdb/<SID>/db/pgm/kernel <SID> -diagpipe 14

ERR:      Terminate all locking processes and rerun the installer.

I'm pretty sure that the second error is because of the first one.

Could it be that the control user doesn't have permision to work on ADMIN mode?

thanks a lot.

Rafael.

[rlabarca · Accepted solution]

Finally the issue was solved by Yashwanth trough an oss message.

What we did:

1.- Correct the first DBM user

dbm_configset SAPDB12 CONTROL

2.- unlock files of previous updates attempts.

SDBUPD -reset_instancedata <database_name>

3.- Run the update.

Thanks a lot to everyone.

Rafael.

[rlabarca]

Hi,

Just to let you know.

Before I posted this message i created a SMP message.

The message was for 3 days with high priority and they haven't been able to find a solution, that's why I asked for help here.

Today they finally told me that the message would have to be sent to development team because they couldn't solve it.

As it seems to be a special case scenario I'll keep you posted about what i get from them.

Anyhow, any help is appreciated.

Regards,

Rafael.

[former_member184473]

Hello Rafael,

Proceed as mentioned in note 1492467:

If the database is not in the operational state ONLINE, the following error may occur:
  SAP VERSION  : -4001,Unknown user name/password combination in operational state ADMIN
Change the database to the operational state ONLINE and execute the DBUPDATE script again.

Regards,

Eduardo

[rlabarca]

Eduardo,

The upgrade guide says that it has to be in ADMIN mode, i've tried in ONLINE but it doesn't work either.

thanks anyways.

Regards.

[yashwanthkumar_kethineed]

Hello Rafael,

1)

Please provide the output of dbm command 'sql_execute select * from users'

2)

Attach the DBUPDATE log to the thread.

3)

Let me know the complete version and build of the current MaxDB 7.7 and the version you are trying to upgrade to - I would like to see if the issue is reproducible in our internal systems.

Regards, Yashwanth

[rlabarca]

Yashwanth,

1.-

dbmcli on <host> : <SID>>sql_execute select * from users

OK

END

'CONTROL';'';'CONTROL';'ADMIN';'MULTIPLE';(null);(null);(null);'DEFAULT';'20070817';'00212439';'20070817';'00212439';'20070817';'00212439';'<SID>';'<host>';0;'NO';(null)

'SUPERDBA';'';'SUPERDBA';'SYSDBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'20050725';'00123416';'20120607';'00095207';'20120607';'00095250';'<SID>';'<host>';10;'NO';(null)

'SUPERDBA';'';'SAP<SID>';'DBA';'MULTIPLE';(null);(null);(null);'ASCII';'20050725';'00123457';'20050725';'00123457';'20050725';'00123457';'<SID>';'<host>';14;'NO';(null)

2.- attached...

3.- 

Current version

dbmcli on isox : CRD>version

OK

version,os,dbroot,logon,code,swap

"7.7.07","UNIX","/sapdb/CRD/db",True,ASCII,1

Target version

7.9.08 Build 05

Thanks in advance.

Rafael.

SDBUPD.txt.zip

DBUPDATE.txt.zip

[yashwanthkumar_kethineed]

Hello Rafael,

1)

Explanation for error code -4001: Unknown user name/password combination in operational state ADMIN

Explanation

The specified combination of user name and password is unknown in the operational state ADMIN. Access to the database system is only possible with the first DBM user.

You can create several users of type DBM. But, during the database installation the so called first DBM operator is created. User name and password of the first DBM operator are specified during the installation.

2)

From the output you attached for "select * from users" it is clear that the CONTROL user is not the

first DBM user.

Control user was created on 2007/08/17

Superdba on 2012/06/07

SAP<SID> user on 2005/07/25

3)

You can correct a lost first DBM property with the command below:
dbm_configset SAPDB12 CONTROL

4)

Restart and try the upgrade again.

Regards,

Yashwanth

[former_member188883]

Hi Rafael,

Some Db processes are still running and hence locking the upgrade.

Could you take a restart and restart the upgrade.

Hope this helps.

Regards,

Deepak Kori

[rlabarca]

Hi Deepak,

I've restarted the upgrade, the server, everything.

If i manually kill those processes the upgrade fails, i've checked and the processes are created when the DB is started in ADMIN mode.

Could it be the error of the control user?

SAP VERSION     : -4001,Unknown user name/password combination in operational state ADMIN

Regards and thanks in advance.

Rafael.