Recently I needed to check
large data set in PSA. I wanted to list all data records that arrived to PSA
from source system. Source was getting me over 3 millions of records. On PSA maintenance
selection screen there is a possibility to specify no of records that is
supposed to be displayed. Even I had approx. 3 millions of records I was not
able to get them all into PSA’s output screen.
I tried to debug the functionality
which displays the data. I found out that within the code there is limit on no
of records to be displayed:
MODULE user_command_0500 INPUT.
...
if g_record_max >= 2147483647.
g_record_max = 2147483646.
endif.
...
if g_record_max >= 2147483647.
g_record_max = 2147483646.
endif.
...
The limit is 2,147,483,647.
Even if I would exceed the number on the screen by entering higher no I would be
getting following error:
To be honest I’m not sure
why I was not able to pull out all the records. Finally I managed it differently
as I went directly to corresponding PSA transparent table via SE11. So at the
end it was not an issue; but I’m curious to know why I cannot see more (all) the
records.
PS: no 2,147,483,647 is prime
number and is one of only four known double Mersenne primes.
It has strong significance in computing because it is the maximum value for a
32-bit signed integer (int).
My other posts on PSA
topic:
No comments:
Post a Comment