2011 Sep 13 12:49 PM
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?
2011 Sep 13 1:02 PM
just guessing, may it be that your table "profiles" is initial?
2011 Sep 13 1:01 PM
2011 Sep 13 1:02 PM
just guessing, may it be that your table "profiles" is initial?
2011 Sep 13 1:05 PM
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
2011 Sep 16 8:51 AM
We openend an OSS message for this, as it started failing after we implemented the latest Support Packs on our ECC 6.0