Creating queue report from Database .net error

[AjithranBalasub]

Hi,

i'am having an issue with generating queue report from database select all?



------------------------------
Ajithran Balasubramanian
------------------------------

[Soumya21]

Hi @Ajithran Balasubramanian

I also faced this issue while exporting logs from blueprism, I think if logs have more data, then this issue will arise. Try exporting log file by filtering for specific data or date. and don't enable logging for actions do it for only actions which needed. 

Thanks,
Soumya

------------------------------
Soumya k RPA Developer
RPA Developer
Qualesce India Private Limited
Bangalore
------------------------------

[AjithranBalasub]

Hi souyma,

There is 79500 queue items i need to export in one go. if i export this page by page it will take time.

------------------------------
Ajithran Balasubramanian
------------------------------

[Tejaskumar_Darji · Accepted solution]

Hi,

You should try this by passing the date range. I would say export year by year that way it won't take long and also you won't notice memory errors.


In the control room also you can pass the date range on the Created date field to only export data for a year, check this guide here for more,


Also, you can try Queue Report VBO to export the data if that helps.

Let us know how it goes and if you need further help.

------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------

[AjithranBalasub]

Thanks for the detailed answer

------------------------------
Ajithran Balasubramanian
------------------------------