In my flow I am doing three of the above - on consecutive files.
The connect activity is working well, however intermittently it will fail, and upon retry is unresponsive, and nothing happens. There doesn’t seem to be any consistency with the failures. Sometimes it might be the first Excel file connect, sometimes the second - when debugging in studio once the Connect to Database connection fails - retrying results in no response, or indeed another fail, just nothing.
Has anyone experienced anything similar - unsure where to go from here, the process requires stability to access the data.
One of the main issues is when attempting to retry - the next connect just seems to become unresponsive and doesn’t follow through with a retry - I’ve tried killing ‘Excel’ first before attempting another - but this doesn’t work
Yes - the bot copies a file locally then connects and queries this excel file.
I am debugging a Test.xaml in the machine where the copying is already done, so I am purely running the connecting//disconnecting/querying, and getting the same connecting error sporadically.
Yes - the same as the full process - I am doing this 3 times - I am reproducing the same error - and if I retry the Connect activity - nothing happens - not even an error sometimes
Close everything, create brand new project, just process a single file (don’t copy/paste anything from the existing xaml file), reproduce the error and post some screenshots of your process and the result please.
I am having issues there connecting to the DB but seems different to that of the original Process file - looking into that.
I have noticed the ‘Connection Pooling’ Tab is having positive effects, when setting this Pool Timeout to 60 - but unsure if this is a graceful resolution..