cancel
Showing results for 
Search instead for 
Did you mean: 

System Copy: Authorization failure

Former Member
0 Kudos

Hello,

Currently I'm trying to implement a standy instance via system copy with backup/restore.

I'm using the Installation Master Installation_Master_6.20_6.40_05_08 and have already installed the Central Instance successfully. Anymore I have restored the database in the target system too. Everything seems to be fine. When I start the Installer again to finalise the system copy it begins from the last transaction and following Error occurs:

Could not load the system tables. SOLUTION: Check the files "dbm.prt" and "dbm.ins" in the run directory of the database (search for "load_systab") or contact SAP Support.

I already have loaded the system tables without any error

load_systab -u <SYSDBA-source>,<pwd> -ud domain

I checked the Logs dbm.prt

0x0000061e INF          1 DBMSrvCo A DBM Server client connection was established at 2011-09-15 13:45:52 (client process has process ID 1563 on computer xxx.xx.net).
0x0000061e INF        421 DBMSrv   Command 'user_response ...' was executed since 2011-09-15 13:45:52.
0x0000061e ERR     -24580 DBMSrv   ERR_COMMAND_FAILED: Command 'user_response' has ended and failed with return code -24950.
0x0000061e ERR     -24950 DBMSrv   ERR_USRFAIL: User authorization failed
0x0000061e INF          2 DBMSrvCo A DBM Server client connection was released (client process has process ID 1563 on computer xxx.xx.net).

dbm.ins looks fine:

// *
...
// M	START	20110915	00114944
// *
COMMIT
// *
// R	==================================
// *
// R	Installation successfully finished
// *
// R	==================================
// *
// M	Releasing user connection (USER: 'SUPERDBA'). Open transactions are rolled back (AUTOCOMMIT OFF session)
// *
ROLLBACK WORK
// *
// E -25392:	'' 
...

I also checked the KnlMsg (converted with protconv):

Thread      0x4C0 Task    142  2011-09-15 11:48:01     RTESec         2:  User SUPERDBA attempts to connect
2011-09-15 11:48:01     RTESec         0:  Authentication method: EXTERNAL
2011-09-15 11:48:01     RTESec         0:  Authenticated identity: sdb
2011-09-15 11:48:01     RTESec         0:  Authentication rejected
2011-09-15 11:48:01     RTESec         0:  Authentication method: SCRAMMD5
2011-09-15 11:48:01     RTESec         0:  Authentication rejected
Thread      0x4C0 Task    142  2011-09-15 11:48:02     CONNECT    12651:  Connection released (ERP, T142, connection obj. 7f716d960bb0)

The database versions are equal (MaxDB 7.7.07.32).

Operating System: SUSE Linux Enterprise Server 11 (x86_64) (both)

By the way the passwords in both systems are equal.

When analysing the problem I noticed that the DOMAIN user is missing in the standby instance. In the source system the user is existing.

user_getall

Therefor I checked the dbm.cfg in the standby instance. It's empty. In the source system the file contains following

AUTOSAVE            =1
DBADTL              =1

In fact, the database works fine. But I can't finalize the system copy.

Anyone an idea what the problem is and how to solve it?

Regards,

Veysel

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hello

The problem is solved. I have reset the passwords of all users (superdba, control nad sap<sid>) to the standards. The Installer could not process the installation with my new passwords.

Thank you all for your help.

Regards

Former Member
0 Kudos

Hi,

It's because of XUSER Authorization.

Follow the procedure as maintained in SAP Note 39439 - XUSER entries for SAP DB and MaxDB

Regards,

Darshan

Former Member
0 Kudos

Hello,

Thank you. I have maintained the Xuser as described in note and compared it with the source system.

Unfortunately the same error still occurs.

Former Member
0 Kudos

Thank you.

I exactly followed the instructions described in note 129352 except for the declaring the SYSDBA. In the target system I have had an older version of the

database 7.5 but I have upgraded it to the same version afterwards. Both database version are equal.

Output of the query select * from users in the source system:

'CONTROL';'';'CONTROL';'ADMIN';'MULTIPLE';(null);(null);(null);'DEFAULT';'20110618';'00131504';'20110618';'00131504';'20110618';'00131504';'ERP';'fleuerhr3p1';0;'NO';(null)
'SUPERDBA';'';'SUPERDBA';'SYSDBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'20100829';'00122321';'20110820';'00190015';'20110820';'00190015';'ERP';'fleuerhr3p1';10;'NO';(null)
'SUPERDBA';'';'SAPERP';'DBA';'MULTIPLE';(null);(null);(null);'ASCII';'20100829';'00122331';'20110820';'00190325';'20110820';'00190325';'ERP';'fleuerhr3p1';14;'NO';(null)

Output of the command user_getall in the target system:

CONTROL
SUPERDBA

Output of the command user_getall in the source system:

CONTROL
SUPERDBA
DOMAIN

Output of the command param_directget CONTROLUSERID in the target system:

CONTROLUSERID    CONTROL

I have executed following commands in right order as desribed:

db_offline

user_sysdba SUPERDBA,admin

db_online

load_systab -u SUPERDBA,admin

As you can see in the dbm.prt the system tables was installed successfully but the error still exists.

Output of the dbm.prt

2011-09-16 10:02:28 0x000012c0 INF        283 DBMSrv   Command 'user_sysdba ...' is being executed.
2011-09-16 10:02:28 0x000012c0 INF        419 DBMSrv   Command 'user_sysdba' has ended with return code 0.
2011-09-16 10:02:31 0x000012c0 INF        283 DBMSrv   Command 'db_online' is being executed.
2011-09-16 10:02:31 0x000012c0 INF        419 DBMSrv   Command 'db_online' has ended with return code 0.
2011-09-16 10:03:20 0x000012c0 INF        283 DBMSrv   Command 'load_systab ...' is being executed.
2011-09-16 10:03:24 0x000012c0 INF        419 DBMSrv   Command 'load_systab' has ended with return code 0.
2011-09-16 10:12:55 0x0000133a INF          1 DBMSrvCo A DBM Server client connection was established at 2011-09-16 10:12:55 (client process has process ID 4920 on computer fleuerhr3p2.groupdomain.net).
2011-09-16 10:12:55 0x0000133a INF        421 DBMSrv   Command 'user_response ...' was executed since 2011-09-16 10:12:55.
2011-09-16 10:12:55 0x0000133a ERR     -24580 DBMSrv   ERR_COMMAND_FAILED: Command 'user_response' has ended and failed with return code -24950.
                    0x0000133a ERR     -24950 DBMSrv   ERR_USRFAIL: User authorization failed

former_member229109
Active Contributor
0 Kudos

Hello Veysel

1. Are you SAP customer?

If Yes => SAP Note 129352 (Homogeneous System Copy with MaxDB)

SAP Note 1014782 (FAQ: MaxDB System Copy)

2. Please update the message with additonal information:

  • What are the DBM and SYSDBA users of the source database?

Post the output of SQL statement "select * from users"

  • With what dbm user did you create the target database?

Post output of the dbm commands:

user_getall

param_directget CONTROLUSERID

3. You have 7.7 database version => You have not "domain" user any more.

MAXDB library:

see document "Managing Users" at

http://maxdb.sap.com/doc/7_7/45/01f20034166c32e10000000a114a6b/content.htm

In some cases, as of Version 7.7, db_online automatically restarts load_systab. So before db_online, after you done the restore of the source database backup in the target database, you need to run the following command to declare the SYSDBA user:

dbmcli -d <database_name> -u <dbm_user>,<password> user_sysdba <sysdba_user_source>,<sysdba_user_password_source>

Regards, Natalia Khlopina