KNOWLEDGE BASE

PostGres error When Attempting to log in with Site-SAML


Published: 19 Jan 2018
Last Modified Date: 20 Jun 2018

Issue

When attempting to log in to Tableau Server with Site-Specific SAML, the following error might occur:

org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO site_saml_sessions (site_luid, last_accessed_at, http_session, id, version) VALUES (?, ?, ?, ?, ?)]; SQL state [25006]; error code [0]; ERROR: cannot execute INSERT in a read-only transaction

If configured, Server-wide SAML will still function.

Environment

  • Multi-node Tableau Server with 2 Repositories
  • Site-Specific SAML

Resolution

As a Tableau Server Administrator, upgrade to Tableau Server 2018.1.2, 10.5.5, 10.4.8, 10.3.12. For more information, see Upgrading Tableau Server in Tableau Help. 

Cause

The Tableau Server Site-SAML service is sending login information to the passive Repository, which is in a read-only state.  The error messages generated by this action interrupt the otherwise successful SAML login and is related to a known issue (ID: 742835) which has been fixed in a recent release of Tableau Server.

Additional Information

Please note that this article is only applicable to Tableau Server clusters that have multiple repositories.
Did this article resolve the issue?