No refresh_token found for Google Drive & Spreadsheets
I’m encountering an issue with a connection in Qlik Sense using the Google Drive & Spreadsheets connector in a multi-node environment.
The connection is created and works correctly when executed immediately on a specific node, but when I try to run it on other nodes within the cluster, I get the error: "No refresh_token found for Google Drive & Spreadsheets."
I’ve already ruled out any issues with the Google API Console configuration since the same connection works fine on another cluster. Has anyone faced this issue before or have suggestions on how to ensure the refresh_token is available across all nodes?
It looks like the error you're encountering is related to how authentication tokens are managed across the different nodes in the cluster. While the connection works fine on a specific node, the token might not be available on other nodes because it's not stored or shared in a centralized manner.
I’d suggest checking that the token and credentials are accessible from all nodes in the cluster, perhaps by ensuring that shared persistence is correctly configured if you're using it. Also, make sure the token hasn’t expired and that the configurations across nodes are consistent, including any environment settings or variables required for accessing Google APIs. Comparing the setup with the other cluster where everything works could also be helpful!
