on 11-01-2010 3:43 PM
system is running normally except for one process. When the end users try to pull up customer overview in tcode cic0, the screen just hangs up. In the work process information from sm50, I see that report RECVBP02 is running and it is running a sequential read on the tableEABLG but it pauses after a while. All other transacations run just fine. Please see below for more detailed info on the work process. Buffers, CPU, memory, Index all look good. Any ideas as to what else could be causing this ?
No Ty. PID Status Reasn Start Err Sem CPU Time Cl. User
0 DIA 25932 Running Yes 14:45 3088 100 A658979
Report / Spool action
SAPLEL24
Main Program
RECVBP02
Action Table
Sequential Read EABLG
Waiting f. since
Last SQL statement
SELECT
*
FROM
SELECT
*
FROM
"EABLG" T_00 INNER JOIN "EABL" T_01 ON T_01 . "MANDT" = :A0 AND T_00 . "ABLBELNR" = T_01 . "ABLBELNR"
WHERE
T_00 . "MANDT" = :A1 AND T_00 . "ANLAGE" = :A2 AND T_01 . "ADAT" BETWEEN :A3 AND :A4 AND T_01 .
"ABLSTAT" IN ( :A5 , :A6 , :A7 , :A8 , :A9 )#
Direct Read 366 14,676
Sequential Read 267 2160329
Insert 0 0
Update 0 0
Delete 0 0
Sources 0 (Bytes)
RSQL 980,082 (Bytes)
Commit 0
DB Procedure Calls 0 0
Roles / Memory Number Time (usec)
Roll In 1 1,657
Roll Out 1 612
Roll 237,568 (Bytes)
Page 90,112 (Bytes)
Memory (Total) 25,149,844 (Bytes)
Memory(Total Private) 0 (Bytes)
Memory (used) 8,379,712 (Bytes)
Memory (Max. Transaction) 29,328,992 (Bytes)
Memory (Max. Dialog Step) 25,139,136 (Bytes)
Development Environ. Number Time (usec)
Generate 0
Load Report 55,647
Load Screen 0 (Bytes) 7,636
Load CUA 602
Read Dictionary 0
RFC 0 Calls 0.00000000000000
Queue API 0 (Bytes) 0
Ad Opcodes 0 0
Hm! check how many entries are there in table EABLG from SE16.
Also check the db stats for table EABLG in DB20 if you are oracle and you are restricting your selection while executing the report.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.