Skip to main content

We have been using BRES for a few months now but it’s been quite slow recently. 

IFS Apps 10 update 12 (Soon to be Update 19)

When we restarted it we noticed 4 reports started straight away but they never finish.

BRES Log

I found the reports on the BRES Report Queue but I can’t delete them.

BRES Report Queue

 

Can anyone tell me how I can clear these reports from the queue?

Currently no other reports can run.

Thanks

Paul

By the way we are running in OOXML mode

Further update. they do time out after 1 hour (3600 seconds set in the config file) but will try to run again when I restart the service.

In case anyone else has this issue, I’ve written a script that cleans the failing reports (older than 3 hours) out of the queue:

 

DECLARE

CURSOR cGetRows IS
Select p.report_id, p.result_key from ifsapp.XLR_REPORT_RENDERING_INFO p
where p.rendering_status = 'Rendering in Progress'
and p.created_date < sysdate - interval '3' hour;

report_id_ varchar2(10);
result_key_ varchar2(10);


BEGIN

  for row_ in cGetRows loop
      report_id_ := row_.report_id;
      result_key_ := row_.result_key;
      ifsapp.xlr_report_rendering_info_api.remove_instance(report_id_,result_key_);
      
    COMMIT;
  end loop;
  
END;

Reply


Terms & ConditionsCookie settings