+1
I am using excel as database actions in my bot. but intermittently it fails without giving an error. i am not sure if it due to VM network related issue or something else. Even there is no any pattern over there. Can someone help me to know the actual cause of it? below things i have already checked
Connection string
syntax
query
Best answer by Niyaz
View original
+2
Hi
I’m not sure whether you use the Database : Disconnect action as soon as the retrieval / updating is completed in the excel.
If you are continuously keeping the session open for a while if it is not working with that excel session as DB, there might be a chance of failing. This is cause one.
The other may be because on VM slowness. Though the excel is in the same VM, the slowness may also cause this issue.
My suggestion is,
+1
Niyaz, Thank you for you help. Yes I am using disconnect action but at end of bot. Does it necessary to connect and disconnect connection after each update action. Also the strange thing is it fails at any time intermittently. Hence not able to drill down the issue till the moment.
+2
Niyaz, Thank you for you help. Yes I am using disconnect action but at end of bot. Does it necessary to connect and disconnect connection after each update action. Also the strange thing is it fails at any time intermittently. Hence not able to drill down the issue till the moment.
Hi
It’s good to disconnect it once the action is completed.
If it’s a real DB then it will fine, but here we are trying to connect excel as DB through the Microsoft driver, it might cause an issue.
Hope it works well!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.