SAP License Error

[Former Member]

Dear Gurus.

I have a system which we use to use as a STBY server, now its not a STBY server as it was used earlier now my PRD is running good. I have to re-configure it. Before i Proceed i tried login into Gui but unnable to login.

Error: Logon not possible (Error in License Check).

I have also tried with sap* and pass but error; Name or Password Incorrect.

I have also read many threads but didnt get any helpful notes.

Gurus Please Help.

Thanks

Mohd

[Former Member · Accepted solution]

Hi,

==>> Logon with user sap* in client 000

==>> Then reinstall sap license received through smp. If problem persists then requested new license from SAP.

[Former Member · Accepted solution]

Dear Gurus.

I have run the above script but the output is :- 0 rows deleted, i also tried logging with sap* and pass in 000 client the output is : Name or Password is Incorrect.

Please Help me resolve this Issue.

Thanks

Mohd

[Former Member · Accepted solution]

Hi,

Have you set the below parameters and did the reboot.

Thanks

Rishi Abrol

[Former Member · Accepted solution]

Dear Rishi.

I have seen the Default Profile the parametre doesnot exist. Do i need to add the parameter at O.S level and delete the user sap*, please give me clear picture step by step.

Thanks

Khan

[Former Member · Accepted solution]

Hi,

First try to set the parameter ,

Restart system and then try to login in 000 with pass.

If doesn't works .Try to delete it then try login in.

Thanks

RishI abrol

[Former Member · Accepted solution]

Dear Gurus.

I have added the parameter in the default profile and tried logging with sap* and pass in 000 client but unable to log in.

I also tried deleteing sap* at o.s level by using the below script in sql prompt but O/P : no rows deleted.

delete from SAPP01.usr02 where bname='SAP*' and mandt='000';

Please Help me resolve this issue.

Regards

Mohd.

[Former Member · Accepted solution]

Dear Gurus.

I have added the parameter in the default profile and tried logging with sap* and pass in 000 client but unable to log in.

I also tried deleteing sap* at o.s level by using the below script in sql prompt but O/P : no rows deleted.

delete from SAPP01.usr02 where bname='SAP*' and mandt='000';

Please Help me resolve this issue.

Regards

Mohd.

[Former Member · Accepted solution]

Dear Gurus.

I have added the parameter in the default profile and tried logging with sap* and pass in 000 client but unable to log in.

I also tried deleteing sap* at o.s level by using the below script in sql prompt but O/P : no rows deleted.

delete from SAPP01.usr02 where bname='SAP*' and mandt='000';

Please Help me resolve this issue.

Regards

Mohd.

[Former Member · Accepted solution]

What is your scema name. Is is not sapsr3.

delete from SAPSR3.usr02 where bname='SAP*' and mandt='000';

Thanks

Rishi Abrol

[Former Member · Accepted solution]

Hi,

in oracle user name = schema name .. so you can query dba_users:

> sqlplus "/ as sysdba"

> select username from dba_users;

Thanks

Rishi Abrol

[Former Member · Accepted solution]

The Scheme name is SAPP01.

Still i tried deleting by the Schema name SAPSR3 the output is  : table or view does not exist.

Thanks

Mohd.

[Reagan · Accepted solution]

Follow the steps given below.

You need to run the query against the with the right schema user

Regards

RB

[Former Member · Accepted solution]

Hi,

Try if you can do this  for client 001. Did you restart the database.

Thanks

Rishi Abrol

[Former Member · Accepted solution]

Dear Rishi.

I have deleted in client 001, O/P : 1 row deleted.

do i need to commit;

Earlier i have restarted using - stopsap all script. whether this is ok or i need to shutdown DB in sql prompt with shutdown immediate and start DB then SAP and try logging into 001 client with sap* andd pass.

Please Suggest.

Thanks

Mohd.

[Former Member · Accepted solution]

Hi,

Yes you  need to commit.

stopsap sap is ok. Now no need to do stopsap.

Just commit and try to login in sap* and pass in 001.

Thanks

Rishi Abrol

[Former Member · Accepted solution]

Dear Rishi.

I have done commit; and tried logging with sap* and pass.

O/P: Name or Password Incorrect.

Thanks

Mohd

[Former Member · Accepted solution]

Hi,

What is the result

sappfpar =check

login/no_automatic_user_sapstar

what value it returns...

Thanks

Rishi Abrol

[Former Member · Accepted solution]

How to check rishi could you pleas guide me.

Thanks

Mohd

[Reagan · Accepted solution]

Hello Mohd

You need to make sure that the paramater login/no_automatic_user_sapstar is mentioned only once in the profiles.

The parameter login/no_automatic_user_sapstar should be with value 0

If the parameter is set to 1 then you will not be able to login with SAP* and password PASS

Go to the profile directory /sapmnt/SID/profile and check the parameter in the profiles there.

Check my reply.

Regards

RB

[Former Member · Accepted solution]

Hi,

To run this you need to login at os level and run this with SIDADM.

Thanks

Rishi Abrol

[Former Member · Accepted solution]

Dear Rishi

The Output of sappfpar. I have run this command twice.

sappfpar
Parameter-Name....: login/no_automatic_user_sapstar
sappfpar=>sapparam(1c): No Profile used.
sappfpar=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
Result............: 1

Parameter-Name....: login/no_automatic_user_sapstar = 0;
Result............: 1
Parameter-Name....: Result............:
Parameter-Name....: Result............:
Parameter-Name....:

Dear RB.

I have checked all profile the parameter is only once in default profile with value 0, and is the password pass or PASS.

Gurus Please Help me come out of this Issue.

Thanks

Mohd

[Former Member · Accepted solution]

Hi,

The value shows as 1 so this means that the profile parameter is set to 1 in some other profile.

Do you have unix system if yes.

The go in /sapmnt/SID/profile

more <prolfile name> | grep login/no_automatic_user_sapstar

Thanks

Rishi Abrol

[Former Member · Accepted solution]

Dear Rishi.

I have copied all profiles to my local pc and thoroughly checked and the value is 0 and the parameter is only once. There is other parameter : login/system_client = 001 which is to display default client no in the client menu where we spcify during login to Gui.

What might be the possibility that this issue is not getting sorted out.

Thanks

Mohd.

[Former Member · Accepted solution]

Hi,

As the sappfpar =check is showing the value 1 so this means there is some thing that is overwriting the value 0.

What is the version of the sap system that you have

What is the OS.

is that any parameters as login/no_automatic_user_sap* or login/no_automatic_user_sapstar

Thanks

Rishi Abrol

[Former Member · Accepted solution]

Thanks Rishi.

The Issue resolved.

It was the parameter i have given wrong

login/no_automatic_user_sap*= 0  (Wrong).

login/no_automatic_user_sapstar = 0 is the correct one as you mentioned.

Thanks For Your Support.

Really Thankful to all Basis Gurus who supported me specially Rishi and RB.

Regards

Mohd

[Reagan]

Hello

I believe this is an Oracle database.

If yes please provide me the output of these queries.

select OWNER from DBA_TABLES where TABLE_NAME='T000';

select BNAME, MANDT, UFLAG from SCHEMA.USR02 where BNAME='SAP*';

Replace SCHEMA with the output from the first query

Check the value of the parameter login/no_automatic_user_sapstar in all the profiles in the profile directory. (START, DEFAULT, INSTANCE)

Regards

RB

[Former Member]

Hi RB.

Below is the O/P of the comands:

select OWNER from DBA_TABLES where TABLE_NAME='T000';

OWNER
------------------------------
SAPP01

select BNAME, MANDT, UFLAG from SAPP01.USR02 BNAME='SAP*';

select BNAME, MANDT, UFLAG from SAPP01.USR02 BNAME='SAP*'

                                                  *

ERROR at line 1:

ORA-00933: SQL command not properly ended

select BNAME, MANDT, UFLAG from SCHEMA.USR02 where BNAME= 'SAP*';

select BNAME, MANDT, UFLAG from SCHEMA.USR02 where BNAME= 'SAP*'

                                       *

ERROR at line 1:
ORA-00942: table or view does not exist

I have also checked the parameter in profiles, it is only in default profile and the value is 0.

Thanks for your support RB.

Regards

Mohd

[Reagan]

Hello

Please provide the output of these

select BNAME, MANDT, UFLAG from SAPP01.USR02 where BNAME= 'SAP*';

su - p01adm

cdpro

grep automatic ./*

Regards

RB

[Former Member]

Dear Gurus.

The Issue resolved.

It was the parameter i have given wrong

login/no_automatic_user_sap*= 0  (Wrong).

login/no_automatic_user_sapstar = 0 is the correct one as you mentioned.

Thanks For Your Support.

Really Thankful to all Basis Gurus who supported me specially Rishi and RB.

Regards

Mohd

[Reagan]

There is an article for SAP* user reset. This can be used when in need.

http://it.toolbox.com/wiki/index.php/How_to_reset_user_SAP*

Regards

RB

[Former Member]

Hi,

Can you please explain more .

If you thing that its a license issue please install the permanent license again.

Has the hardware key changed or system no. If yes them apply for new license.

try to reset the password at database level and then login and apply license.

Step1 :

login as orasid and sqlplus "/as sysdba"

delete from <SAP SCHEMA>.usr02 where bname = 'SAP*' and mandt = '<client-number>';

example

delete from sapsr3.usr02 where bname ='SAP*' and mandt ='000';

Step 2 : stop the SAP & DB

Step 3 :  set the parameter login/no_automatic_user_sapstar = 0 in the default profile avalable in /sapmnt/<SID>/profile

Step 4 : start the DB & den SAP

Step 5 : login to the system using SAP* and password as pass  ( all in lower case)

Thanks

Rishi Abrol