SAP Server too slow

[Former Member]

Dear Concern,

We have recently setup a new SAP Server. We have completed all the Installation steps.

And SAP is working fine.

The whole issue is coming when We try to delete a imported Custom Data Dictionary Object from SAP be it Custom Table/ Structure/Data Element etc.

i..e We have imported Co and Data files in this new SAP Server. Due to some reasons, we need to delete the Objects imported through the SAP Server.

And when we try to delete Custom Data Dictionary Objects, program dumps.. And nothing is deleted.

Please advice me what is the root cause and what should i do to avoid this?

[Former Member]

Dear Concern,

We have recently setup a new SAP Server. We have completed all the Installation steps.

And SAP is working fine.

The whole issue is coming when We try to delete a imported Custom Data Dictionary Object from SAP be it Custom Table/ Structure/Data Element etc.

i..e We have imported Co and Data files in this new SAP Server. Due to some reasons, we need to delete the Objects imported through the SAP Server.

And when we try to delete Custom Data Dictionary Objects, program dumps.. And nothing is deleted.

Please advice me what is the root cause and what should i do to avoid this?

[Former Member]

Hi Suruchi,

Please check the dump details in ST22 and post them here.

BR.

[Former Member]

Time limit exceeded.

t happened?

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

interruption and has therefore been terminated.

t can you do?

Note down which actions and inputs caused the error.

To process the problem further, contact you SAP system

administrator.

Using Transaction ST22 for ABAP Dump Analysis, you can look

at and manage termination messages, and you can also

keep them for a long time.

or 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.

How to correct the error

	Programs with long runtime should generally be started as background
	jobs. If this is not possible, you can increase the system profile
	parameter "rdisp/max_wprun_time".

	Depending on the cause of the error, you may have to take one of the
	following measures:
	- Endless loop: Correct program;
	- Dataset resulting from database access is too large:
	Instead of "SELECT * ... ENDSELECT", use "SELECT * INTO internal table
	(for example);
	- Database has unsuitable index: Check index generation.

	If the error occures in a non-modified SAP program, you may be able to
	find an interim solution in an SAP Note.
	If you have access to SAP Notes, carry out a search with the following
	keywords:

[arindam_m]

Hi,

Check transaction RZ10. Change your parameter rdisp/max_wprun_time to increase time out value.

Cheers,

Arindam

[Former Member]

Hi Suruchi,

You need to schedule your deletion operation as a background task.

BR.

[Former Member]

Can you please tell me how to schedule the deletion operation as a background task.

[Former Member]

I already increase rdisp/max_wprun_time to increase time out value. But no results

[Former Member]

Hi Sururchi,

Please see

http://help.sap.com/saphelp_nw70/helpdata/en/c4/3a7f87505211d189550000e829fbbd/content.htm

BR.

[arindam_m]

Then background execution may help you

[Former Member]

Hi Suruchi,

You need to perform Post-installation Activity followed by SGEN to increase SAP System Performance.

Regards,

Shashanka

[Former Member]

Can you please let me know what all Post-installation Activity is required?