Issue with Access DB residing in Shared Location from VDI

[SushmaDas]

​Hi Team,

The Project I am working on uses Microsoft Access DB which is around 350MB saved in the shared drive. Blue prism code accesses data through OLEDB . The Select Query works fine when running the process in Desktop, but the same query fails with Error Message "System Resource Exceeded" while running in a VDI.

Can you please help me out what is the issue with the two Environments?

------------------------------
Sushma Das
System Analyst
Legal and General
------------------------------

[RobinToll]

First, there is actually a known MS bug that may apply to you. Check out this page: https://stackoverflow.com/questions/155959/oledbexception-system-resources-exceeded.

That being said... The error literally means what it says - some system resource the query is using is being exceeded. Most often when I see this it's actually around pooled connections. Is this a single query that fails, or a series of queries happening in a loop? Are you repeatedly connecting or using a single connection? Is it one query or a series of queries?

Another article I found that talks about some of the potential connection problems: https://stackoverflow.com/questions/155959/oledbexception-system-resources-exceeded

Hope this helps!

------------------------------
Robin Toll
Senior Product Consultant
Blue Prism
------------------------------