Skip to Content
author's profile photo
Former Member

Has exceeded the maximum permitted runtime

Hello All,

I am handling Insurance utilization report. It gives you information whether Insurance is covered by Consigner , Consignee or Insurance not required

It's dumping in the production system because it's taking to much time to retrieve the data. The error message was <b>"Has exceeded the maximum permitted runtime without interruption, and has been terminated"</b>

select bkpfxblnr bkpfbldat BKPFBUKRS ekbebewtp rbkplifnr rbkprmwwr ekbeebeln ekbeebelp ekbelfbnr ekbelfgja lfa1name1 lfa1ort01 lfa1~pstlz

into corresponding fields of table i_table from lfa1 inner join rbkp on lfa1lifnr = rbkplifnr join ekbe on ekbebelnr = rbkpbelnr

and ekbegjahr = rbkpgjahr join bkpf on bkpfbukrs = rbkpbukrs and bkpfxblnr = rbkpxblnr

and bkpfbldat = rbkpbldat where bkpfblart = 'RE' and bkpfBSTAT = ' ' and bkpfbudat in s_date and bkpfbukrs in s_bukrs

and rbkpblart = 'RE' and rbkpstblg = ' ' and ekbe~bewtp = 'Q'.

please tell me how to increase the performance of the above statement or if there any other way I can handle this please let me know.

Thanks & Best Regards,

Mahesh

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Posted on Aug 23, 2007 at 02:18 PM

    Hello,

    Since your posting does not contain any information on the amount of data and used access path it's impossible to give any advice.

    Some remarks:

    - run the report in batch environment, in this case rdisp/max_wprun_time is ignored.

    - DB2 for z/OS or DB2 for LUW(DB6) ? If DB6 move the thread to the DB6 forum

    - if SAP standard report, open a problem ticket at SAP

    Regards,

    Thomas

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 23, 2007 at 02:53 PM

    it may be normal to get this error if the request is big.

    ask your user to run this job in background instead.

    Add comment
    10|10000 characters needed characters exceeded