unable to login to sap development system

[Former Member]

When iam applying service packs,some has restarted the server. After restart the system everything is fine MMC is started. Database connection is ok. tp connection ok. Every thing is ok. When iam trying to login sap system I entered ddic user 000 client. Iam not able to login to my system.

The error which iam getting is Sid: SYSTEM MESSAGE SYNTAX ERROR IN PROGRAM SPAMS380.

I'am not able to login any client, with ddic,sap*, any user id.

Please give me the solution quickly.

I'am Applying Support Packs in Development system.

[former_member190272]

Hi ,

If all the users are locked, they can be unlocked by

a)Try this command at ur sql plus query level

Go to cmd prompt.

Sqlplus /nolog

conn /as sysdba

this will take you to the sqlprompt.

Just execute the earlier commands there.

sqlplus>UPDATE SAP<schema>.usr02 set uflag=0 where mandt=<CLNT NO> and uflag=64; this statement actually unlocks the users of that particular client. So, try for every client in that sap system.

b) You can delete sap* user

Go to cmd prompt.

Sqlplus /nolog

conn /as sysdba

sqlplus>DELETE SAP<SID>.usr02 where mandt='CLIENT.NO' and bname=SAP*;

Note:-

After doing this restart the system. So, that a new user with the name "sap" gets generated with password "pass". Provided the parameter is set login/no_automatic_user_sapstar= 0 (Automatic user SAP is permitted).

Thanks

Pankaj Kumar