michalides
New Member
Hi guys,
I have a process scheduled to run every 30 min which uses a macro to query a SQL entry from database. Yesterday I got unexpectedly an error "Excel is waiting for an OLE action to finish" From what I googled it looks like "Object Linking and Embedding action" is pending with another program (most probably the db) which caused my robot to stuck on this stage the whole night (as seen below).
View attachment 1543398487637.png
Only after I clicked OK the process moved to another stage and as you can see it was stuck on that Run Billing Macro action for 17 hours.
View attachment 1543398373052.png
Looks like this is thing which doesn't resolve to an exception but is just pending forever instead.
My question: Do you have any idea how to handle this inside the process if this OLE window pops up again so the process don't get stuck on this action?
I already did some things which might help to prevent the window to pop up but I need to be handle it somehow when it pops up.
Any ideas appreciated.
Thanks
I have a process scheduled to run every 30 min which uses a macro to query a SQL entry from database. Yesterday I got unexpectedly an error "Excel is waiting for an OLE action to finish" From what I googled it looks like "Object Linking and Embedding action" is pending with another program (most probably the db) which caused my robot to stuck on this stage the whole night (as seen below).
View attachment 1543398487637.png
Only after I clicked OK the process moved to another stage and as you can see it was stuck on that Run Billing Macro action for 17 hours.
View attachment 1543398373052.png
Looks like this is thing which doesn't resolve to an exception but is just pending forever instead.
My question: Do you have any idea how to handle this inside the process if this OLE window pops up again so the process don't get stuck on this action?
I already did some things which might help to prevent the window to pop up but I need to be handle it somehow when it pops up.
Any ideas appreciated.
Thanks