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.
I found the reports on the BRES Report Queue but I can’t delete them.
Can anyone tell me how I can clear these reports from the queue?
Currently no other reports can run.
Thanks
Paul
Best answer by TSPPRICH
View originalBy 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;
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
