26.12.10

SAP Note 15819 - ST04; ABAP/4 runtime error in RSORA50

Symptom:

Transaction ST04, Report RSORA050, COMPUTE_INT_PLUS_OVERFLOW

Tools->Administration->Monitor->Performance->Database->Activity. This is transaction ST04.

Use Goto->Current Statistics->By client
-or-
Button "Detail Analysis menu" and then button "SAP Client by resource".

Push "since reset" button on database performance: stats by client and get an ABAP short dump (run time error COMPUTE_INT_PLUS_OVERFLOW or COLLECT_OVERFLOW).

The termination occurred in the ABAP/4 program "RSORA050" in form "BUILD-TAB-STAT7".

Cause and prerequisites

Fields of structure TAB_SUM and other structures were too small for installations with many servers and/or extremely different situations between the "reset" time and the actual time.

Solution
1. First correction:
(This correction is for release 3.0F this note is included in HOT PACKAGE 18.)

The structure TAB_SUM in RSORA050 should be extended as follows:

Old version (lines 1390-1570 in the editor):

DATA: BEGIN OF TAB_SUM,
CURRENT_OPEN_CURSOR(10) TYPE I,
USER_CALLS(10) TYPE I,
RECURSIVE_CALLS(10) TYPE I,
USER_COMMITS(10) TYPE I,
USER_ROLLBACKS(10) TYPE I,
PARSE_COUNT(10) TYPE I,

DB_BLOCK_GETS(10) TYPE I,
CONSISTENT_GETS(10) TYPE I,
PHYSICAL_READS(10) TYPE I,
PHYSICAL_WRITES(10) TYPE I,
REDO_BLOCKS_WRITTEN(10) TYPE I,

TABLE_SCANS_LONG(10) TYPE I,
TABLE_SCAN_ROWS_GOT(10) TYPE I,
TABLE_FETCH_BY_ROWI(10) TYPE I,
TABLE_FETCH_CONT_RO(10) TYPE I,
END OF TAB_SUM.

Modified version with changed type & size (same lines):

DATA: BEGIN OF TAB_SUM,
CURRENT_OPEN_CURSOR(16) TYPE P,
USER_CALLS(16) TYPE P,
RECURSIVE_CALLS(16) TYPE P,
USER_COMMITS(16) TYPE P,
USER_ROLLBACKS(16) TYPE P,
PARSE_COUNT(16) TYPE P,

DB_BLOCK_GETS(16) TYPE P,
CONSISTENT_GETS(16) TYPE P,
PHYSICAL_READS(16) TYPE P,
PHYSICAL_WRITES(16) TYPE P,
REDO_BLOCKS_WRITTEN(16) TYPE P,

TABLE_SCANS_LONG(16) TYPE P,
TABLE_SCAN_ROWS_GOT(16) TYPE P,
TABLE_FETCH_BY_ROWI(16) TYPE P,
TABLE_FETCH_CONT_RO(16) TYPE P,
END OF TAB_SUM.

2. Second correction (corrected with 4.5A):

Please apply the same changes also to structures TAB_STATEI, TAB_STAT, CENTRAL, ORACLE, NETTO, CLIENT, CENTRAL%, CLIENT%.

Additional key words

ST04, RSORA050, COLLECT_OVERFLOW, COMPUTE_INT_PLUS_OVERFLOW

No comments:

Post a Comment