Skip to Content
0
Feb 18, 2009 at 10:27 AM

DB02 refresh RSORATOD

354 Views

Hello

I have the following problem

In a BW system 30B since 3 of january i can't refresh the DB02 using the report RSORATOD.

If I try to schedule the report in dialog i have the dump time_out :

"The termination occurred in the ABAP program "SAPLSTD4" in

"DB02_ORA_FILL_DBA_SEGMENTS".

The main program was "SAPMSSY1 ".

The termination occurred in line 71 of the source code of the (Include)

program "LSTD4U05"

of the source code of program "LSTD4U05" (when calling the editor 710)."

When i try to schedule in background i have the dump MEMORY_NO_MORE_PAGING:

"The termination occurred in the ABAP program "RSORAT0D" in

"START-OF-SELECTION".

The main program was "RSORAT0D ".

The termination occurred in line 46 of the source code of the (Include)

program "RSORAT0D"

of the source code of program "RSORAT0D" (when calling the editor 460).

The program "RSORAT0D" was started as a background job. "

I've noted that all the time the job or process is running the select is hang on table DBA_SEGMENTS.

Probably It has too much data to analyze; how can i reduce it to complete the refresh of DB02? actually i can see only the tab "tablespaces" but not the tab tables and indexes neither "database system" .

How can i resolve this problem?

Thanks

Nicola