Showing results for 
Search instead for 
Did you mean: 

DDIC & SAP* locked in CI Installtion

Former Member
0 Kudos


In ERP Central Instance installtion, 000 DDIC and SAP* locked.

I deleted sap* record in USR02, however cannot logon due to too many failed attemps.

In this case, how to unlock SAP* ,and logon Client 000?

Please help  me to solve this problem.

Best Regards,

Naomi Yamane

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

Hi Naomi Yamane,

Your issue resolved or not?

Thank you


Former Member
0 Kudos

Hi Naomi ,

Like you said in your question.

Are you facing this problem during installation of ERP Central instance ?? please provide info.

If you are facing this problem during installation then I have gone through this before when i was installing Netweaver 2004s sr2 on distributed system, during Central instance part installation last stages it gave me error ddic user is locked. Though i can see system is up can green and correct password still cannot login. I followed procedure to unlock it and continued installation.

Have a look at this document for unlocking Sap*.


Syed Athesham.

Active Contributor
0 Kudos

hi Naomi,

First check the value of parameter login/no_automatic_user_sapstar in instance profile which should be 0.

If User SAP* is locked and you have no other user to unlock then you need to run below SQL command to reset the password.

SQL> delete from SAPSR3.USR02 where bname='SAP*' and mandt='Client_Number';

now you can logon with SAP*


Former Member
0 Kudos


As you are saying that the id is locked. you can unlock it at os level.

If the user is locked you will need to update UFLAG field in table USR02.


Update SAPSR3.USR02 set UFLAG=0 where BNAME='DDIC' and MANDT=000


Rishi Abrol

Former Member
0 Kudos

Hi Naomi,

Here are some steps that can help you.

1. Delete the SAP* from client 000 using SQL query at database level.

2. commit the changes in database.

3. Set SAP parameter "login/no_automatic_user_sapstar=0" in SAP instance profile.

4. Restart the SAP system and use default password ,i.e.,pass.



Former Member
0 Kudos

Hi Naomi,

Did you try to login using login 'SAP*' with 'pass' password after deletition.



Active Contributor
0 Kudos

First of all, you need to check

login/no_automatic_user_sapstar parameter in the system profile (default or instance).

If needed, in operating system it is in

/usr/sap/<sid>/SYS/profile folder.

Be default it is 1, so if it is not there you need to add it and reset to 0.

Anyway, deleteing from USR02 is not enoguh; you need to restart the system.

Good luck!