Not able to login into the new client.

[Former Member]

Hi,

I have done a client copy of the new system, client copy wen t successfull. Now i am trying to login to the new client with the SAP* and password PASS, after a certain , i get a run time error as below

Short text

Time limit exceeded.

What happened?

The program "SAPMSYST" has exceeded the maximum permitted runtime without

interruption and has therefore been terminated.

Error analysis

After a specific time, the program is terminated to make the work area

available to other users who may be waiting.

This is to prevent a work area being blocked unnecessarily long by, for

example:

- Endless loops (DO, WHILE, ...),

- Database accesses with a large result set

- Database accesses without a suitable index (full table scan)

The maximum runtime of a program is limited by the system profile

parameter "rdisp/max_wprun_time". The current setting is 600 seconds. If this

time limit is

exceeded, the system attempts to cancel any running SQL statement or

signals the ABAP processor to stop the running program. Then the system

waits another 60 seconds maximum. If the program is then still active,

the work process is restarted.

Only the above information is displayed, nothing more than that.I have tried to restart the system and still the same issue.

What can be done now.

Thanks

[Former Member]

Hallo,

Please stop SAP and DB and start again then you should be able to login, as i had a same problem.

thanks

ram

[Former Member]

thanks

[Former Member]

Hi Krishna,

Perform an update optimizer statistics and then try to login into the new client. If you are still facing the same issue, execute SAP load generator in any of the existing clients and then try logging in.

Regards,

Varadhu

[Former Member]

How to perform the update optimizer statistics and which client is it 000 or 001 with SAP* username.

thanks

[Former Member]

Hi,

For running Optimizer follow below steps.

Login as OS level as ora<SID> user.

run brtools

Choose option 7 Database Statistics

Choose option 1 Update database statistics

After complition of this try to login.

Hope it will help you.

Shambo

[Former Member]

Activate your sap* and then you will be able to login with password 'pass'. Remember you will need to restart SAP system.

check for further info in the link below.

[http://help.sap.com/saphelp_45b/helpdata/en/52/671792439b11d1896f0000e8322d00/content.htm]

[Former Member]

It is accepting the password, to login to the main screen of SAP it is producing the shortdump as above.

[Former Member]

check the value of this parameter.login/no_automatic_user_sapstar.

Thanks

Presu