2008 Apr 09 8:41 AM
Hello..
I'm testing my program.. Now when I select all possible options I get the 'Time Limit Exceeded' error.
Now my question. Is there a way to split the action because all it does is write text into a table of variables. when I get the error the table already contains 57000 records.. Thats more than half of them so.. Is there some way to restart the time limit counter after 50000 records or something?
Greets
2008 Apr 09 9:16 AM
Hi,
In your program you mention up to 5000 rows ...
Regards...
2008 Apr 09 9:16 AM
2008 Apr 09 9:48 AM
Isn't there a better way to solve this problem?
Like execute the program in job mode or something??
2008 Apr 09 9:51 AM
2008 Apr 09 9:52 AM
2008 Apr 09 10:00 AM
I loop for like 3000 persons in 100 tables.
So the code that stands below is executed like 3000 times..
For every row I get I split the row with the help of the table structure.
The splitted part I write to a text variable.
(here's where I think it goes wrong..)
* get data form internal table tabname into <it>
SELECT * FROM (tabname) INTO CORRESPONDING FIELDS OF TABLE <it>
WHERE pernr EQ personellnumber AND begda GE startdate AND begda LE
enddate.
LOOP AT <it> ASSIGNING <temp>.
LOOP AT datafields WHERE infotype = tabname+2.
ASSIGN COMPONENT datafields-field_name OF STRUCTURE
<temp> TO <wa>.
* check if the field should be scrambled.
IF down_scr_flds = 'X'.
REFRESH cust_scr.
SELECT * FROM zcustom_scramble INTO cust_scr WHERE
profile_id = profile_id AND infotype = tabname AND field_name =
datafields-field_name.
MOVE cust_scr-scram_value TO <wa>.
ENDSELECT.
ENDIF.
* check if they want to change the pernr
IF datafields-field_name EQ 'PERNR' AND down_pernr = 'X'.
LOOP AT pernrs_oldnew WHERE old_pernr = <wa>.
MOVE pernrs_oldnew-new_pernr TO <wa>.
ENDLOOP.
ENDIF.
MOVE <wa> TO output_tab-data+datafields-field_start.
ENDLOOP
APPEND output_tab.
ENDLOOP.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |