I’m using Dremio v. 4.1.8. Much of the time, my Oracle connection works. However, I run across the following error,often once or twice a day, when trying to pull data via my Oracle connection
The source [myoraclesourcename ] is currently unavailable. Info: [Connection is not valid.]
If I resubmit my query, or use the UI to browse to another dataset used by that same connection, the error goes away, often for several hours/rest of the day.
I’m assuming this message might be occurring because for some reason, the connection closed, but don’t know for sure because of the ambiguity of the message.
Is there a fix or a workaround for this?