KNOWLEDGE BASE

When Signing In To Google Sheets, "The site can't be reached" Page Displays After Clicking The "Accept" Button For Google OAuth


Published: 16 Dec 2020
Last Modified Date: 17 Dec 2020

Issue

When signing in to Google Sheets, the error page the following error is displayed:

"The site can't be reached"

after clicking the "Accept" button for Google OAuth.

User-added image

From the logs, exception "No associated keychain entry found" can be found. For example:

// ziplogs\node1\dataserver_0.<build version>\logs\dataserver_node1-1.log
2020-12-10 14:09:16.142 +0900 (Default,0125197,,X9GtfKyq4YV6o9z2ZiH6FwAAAeA) catalina-exec-2 : ERROR com.tableausoftware.domain.keychain.KeychainService - event=KeychainService.decryptKeychainForDatasource.error totalTime=0.061 errorMessage="No associated keychain entry found, connattrs: {class=google-sheets, oauth-client=server-custom, username=<user name>} (errorCode=180007)"
com.tableausoftware.domain.exceptions.NotFoundException: No associated keychain entry found, connattrs: {class=google-sheets, oauth-client=server-custom, username=<user name} (errorCode=180007)

Environment

  • Tableau Server
  • Google Sheets

Resolution

Verify and make sure the Tableau server URL is set correctly with oauth.google.redirect_uri key by running the following tsm configuration set Options.
 
tsm configuration set -k oauth.google.redirect_uri -v <tableau server URL>/auth/add_oauth_token
tsm pending-changes apply

Please replace <tableau server URL> with the actual Tableau Server URL and make sure whether your Tableau Server is on https or http.
For more information see Change Google OAuth to Saved Credentials.

Cause

Tableau Server URL set is incorrect. The tsm command does not check the validity of the server URL upon running the configuration command.
As a data provider, Google Sheets needs an accessible and correct location (URL) to send access token back to Tableau Server. See Overview of the OAuth process.
 
Did this article resolve the issue?