I am facing an issue with Execute Query Activity. I have a simple select query (“Select * from Table1”) inside a while loop which runs fine on the first iteration. However, in the next iteration, it throws an exception “Execute Query: Object reference not set to an instance of an object”.
I then tried to use the Connect, Execute Query, and Disconnect activities. While doing this, again the first iteration went just fine. However, in the second iteration, the Connect activity threw an exception “Connect: External component has thrown an exception.”. I did supply the Database Connection handle to Execute Query and Disconnect Activities
UiPath Version: 2020.4.1
UiPath Database Activities Package version: 1.3.7369.25200
Database: MS Access
Your help would be greatly appreciated.