cancel
Showing results for 
Search instead for 
Did you mean: 

unable to logon to new client 100

Former Member
0 Kudos

Dear all,

I have created a new client 100 as a copy of client 001 in a fresh installation and am unable to logon to it with user sap, ddic or admin user in client 001. I have tried deleting sap from the new client 100 to enable access wtih default password but sap* does not appear to exist in the db schema.

The db schema in use is SAPSR4. The parameter is also set as below.

login/no_automatic_user_sapstar = 0

The SQL used is:

SQL> DELETE SAPSR4.USR02 WHERE MANDT='100' AND BNAME='SAP*';

Please advise.

Regards.

Accepted Solutions (1)

Accepted Solutions (1)

volker_borowski2
Active Contributor
0 Kudos

Hi,

> The db schema in use is SAPSR4. The parameter is also set as below.

> login/no_automatic_user_sapstar = 0

ok, check your profile parameter in RZ11 for the current value in

the running system. If it is 1, you need to restart as said before.

> The SQL used is:

> SQL> DELETE SAPSR4.USR02 WHERE MANDT='100' AND BNAME='SAP*';

... and you did a COMMIT in addition, did you ?

The reason then can be, that table USR02 is bufferd inside SAP.

If you already tried a login before the delete on db-level the old record might still be buffered.

Login to another client and execute $TAB as a transaction code.

This resets the table buffer (should not be done during high activity).

Open a new gui and try again.

Volker

Former Member
0 Kudos

Thanks Volker,

Only to make a minor correction here... the t-code was /$TAB and the rest went fine. I managed to logon with sap* and pw PASS.

Thanks for the tip.

Regards.

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

I hope u have not restarted the SAP instance after setting the parameter. If yes, restart the SAP instance and then try to login with the default password.

Hope this will resolve ur issue.

Regards,

Varadharajan M

Former Member
0 Kudos

Hi Mohammed,

Can you tell me what are all the profiles (SAP_CUST,SAP_USER etc) you have used during client copy??

Thanks,

Jagadish

Former Member
0 Kudos

Hi Mohammad,

Your Parameter seems to be ok... and your SQL statement is missing from clause..

The SQL used is:
SQL> DELETE SAPSR4.USR02 WHERE MANDT='100' AND BNAME='SAP*';

The correct statement should be like....

Delete from sapsr4.usr02 where bname='SAP*' and mandt='NNN'; (NNN=Your client)

Arguments in quotes are case sentitive...If you get an output like "1 record deleted", type commit;

All the best !