Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Transaction RSUSR100 times out

0 Kudos
451

Dear Guru's,

For an internal audit, I have to get all the users that have had the profile SAP_ALL and SAP_NEW since 01/01/2011 until now. They might not have this profile anymore.

When I try this with RSUSR100, I get a time out. The parameter is now set to 1000 seconds, and I don't want to increase it to an arbitrary number, as I don't know how long the program will take to finish.

The query it time ous on is the following :

SELECT *

FROM usr11

INTO CORRESPONDING FIELDS OF TABLE lt_profiles

BYPASSING BUFFER

FOR ALL ENTRIES IN profiles

WHERE langu IN lr_languages

AND profn EQ profiles-profn

AND aktps IN lr_aktpas.

The table usr11 contains 225000 lines. I'm working on a SAP ECC 6.0 system, our OS is AIX and the database is Oracle 10.2.

Do you know how I could get the result out of SAP?

1 ACCEPTED SOLUTION

Former Member
0 Kudos
194

just guessing, may it be that your table "profiles" is initial?

4 REPLIES 4

Former Member
0 Kudos
194

Run it in the background (use a batchjob)

Former Member
0 Kudos
195

just guessing, may it be that your table "profiles" is initial?

BH2408
Active Contributor
0 Kudos
194

Hi,

As for your server the online running time limit is 1000 Sec, so it is as time out.

1. Run the program or Tcode in the Background. (Better way for this problem ).

2. We can able to increase the time limit (But it is not suggestible solution) by asking the BASIS people, but it will change the Server online time.

BR,

Bharani

0 Kudos
194

We openend an OSS message for this, as it started failing after we implemented the latest Support Packs on our ECC 6.0