Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

OLEDB Crashed Blue Prism

NickLeGuerrier
Level 4

‎27-01-20 05:43 PM

Hello,

I have encountered some interesting behavior in Blue Prism today. We have a reconciliation process that connects to a spreadsheet using the OLEDB Blue Prism object and up until now the process of querying data has proven to be successful. However, when running the process in debug mode this morning, Blue Prism crashed unexpectedly with no exception messaging. I re-opened the application and the item is still locked in the queue, and there is no sign of anything going wrong in the log.

 

Has anyone encountered issues with OLEDB connectivity like this before? I imagine it may be related to opening and closing the OLEDB connection, but I am unsure.

Thank you,
Nick 



------------------------------
Nick LeGuerrier
Senior RPA Developer
------------------------------
0 Likes
3 REPLIES 3

John__Carter
Staff
Staff

‎28-01-20 09:48 AM

Might be worth a look for clues in the windows event log and then raising a ticket with our support team.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------
0 Likes

IanCampbell
Level 3

‎29-01-20 09:09 AM

Hi Nick,

I would check the windows event log as suggested by John. If that shows nothing else then try with some dummy data incase its a formatting issue with the data (i.e. the data source has changed​ column/table names etc), if that seems to be similar to how it used to be then it would be worthwhile checking your latest windows security updates as there was a few in the November security release from Microsoft that caused serious issues with the Access database engines used by OLE DB. Microsoft have released patches to resolve these issues that will hopefully help with your connection issue.

See Microsoft Database Engine patch details: https://support.office.com/en-gb/article/access-error-query-is-corrupt-fad205a5-9fd4-49f1-be83-f21636caedec

Hope this helps,

Ian

------------------------------
Ian Campbell
RPA Specialist
Allen & Overy
------------------------------
0 Likes

NickLeGuerrier
Level 4
In response to IanCampbell

‎29-01-20 02:11 PM

Thank you to both John and Ian for these suggestions. I will speak to our IT team and hopefully this solves the issue.

Regards,
Nick

------------------------------
Nick LeGuerrier
Senior RPA Developer
MD Financial Management
Ottawa
------------------------------
0 Likes