topic Re: Time Limit Exceeded in Application Development and Automation Discussions

Time Limit Exceeded

Former Member — Wed, 09 Apr 2008 07:41:32 GMT

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

Re: Time Limit Exceeded

Former Member — Wed, 09 Apr 2008 08:16:44 GMT

Hi,

In your program you mention up to 5000 rows ...

Regards...

Re: Time Limit Exceeded

Former Member — Wed, 09 Apr 2008 08:48:43 GMT

Isn't there a better way to solve this problem?

Like execute the program in job mode or something??

Re: Time Limit Exceeded

Former Member — Wed, 09 Apr 2008 08:51:55 GMT

Run the program in the background.

Re: Time Limit Exceeded

Former Member — Wed, 09 Apr 2008 08:52:01 GMT

can u paste ur code here..

Re: Time Limit Exceeded

Former Member — Wed, 09 Apr 2008 09:00:01 GMT

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.