ABAP Runtime error !!! Timeout error

13249 Views

Hi friends,

This time i have an error in the production . The result of the error is becoz of the following short dump that occurs when a report is run . I would appreciate if you can give me some advice on how to overcome this issue . Sometime the report runs fine and fetches all the data from the table but sometimes it takes forever and results in a short dump.

Error analysis

-

After a certain length of time, the program is terminated. In the case of a work area, this means that

- endless loops(DO,WHILE, ...),

- database accesses producing an excessively large result set,

- database accesses without a suitable index (full table scan)

do not block the processing for too long.

The system profile "rdisp/max_wprun_time" contains the maximum runtime of a

program. The current setting is 600 seconds. Once this time limit has been exceeded,

the system tries to terminate any SQL statements that are currently

being executed and tells the ABAP processor to terminate the current

program. Then it waits for a maximum of 60 seconds. If the program is

still active, the work process is restarted.

In my SQL query i have used SELECT SINGLE ....INTO TABLE ... .

Should i use SELECT * .....INTO TABLE ????

Please let me know .

Thanks