Hi everyone! I have a scheduled flow that runs eve...
# ask-community
g
Hi everyone! I have a scheduled flow that runs everyday successfully, but when I try to quick run it, the last task fails with the following message: Can't open lib 'ODBC Driver 17 for SQL Server' : file not found". Is there a runtime difference between scheduled run and quick run?
k
Hey @Gustavo de Paula, Quick Run literally creates a run with schedule “now” so not really, unless you have a different RunConfig, or Parameters, or it’s being picked up by a different Agent than the one you expected
g
I've found that re registering the flow fixes the problem, but after the weekend boot it comes back, making it work only when scheduled.
k
What boots over the weekend? The agent?
g
Only the pc I use to register the flow. The agent is running in a kubernetes pod that doesnt get booted
k
That should be fine. I don’t know why that would affect it. And then you re-register and everything works again?
g
exactly
k
What storage do you use for the Flow and do you have other agents running?
g
I use the azure blob storage using the
stored_as_script=True
and I have only this one agent running
k
Nothing here sounds off to me. If it already lives on Azure, as long as the agent can authenticate and pick up the flow (I assume through secrets or env vars), you should be fine. After registration, nothing is needed on the host machine so a boot should not affect this, especially if it runs on Kubernetes. I assume the ODBC Driver for SQL Server is on the Kubernetes image, so that should also work fine over time.
Does SQL Server live on some remote server?