KNOWLEDGE BASE

PostGres error When Attempting to log in with Site-SAML


Published: 19 Jan 2018
Last Modified Date: 24 Sep 2019

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

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 releases of Tableau Server.

Additional Information

Please note that this article is only applicable to Tableau Server clusters that have multiple repositories.


Discuss this article... Feedback Forum
Did this article resolve the issue?