KNOWLEDGE BASE

When Opening Views Only The Timestamp And Unknown ID Are Intermittently Displayed


Published: 02 Apr 2021
Last Modified Date: 05 Apr 2021

Issue

Unable to display Vizs. When opening views, only the timestamp, and unknown ID are intermittently displayed. 
Refreshing the screen/viz on the web browser may resolve the issue temporarily.
This issue occurs indeterminately in a multi-node environment with two repository instances (active and passive).

User-added image

 

Environment

  • Tableau Server
  • Multi-node Tableau Server deployment
  • Two repository instances (active and passive)

Resolution

Workaround
Use the tsm topology failover-repository command to perform a repository Failover.
Configure a preferred active repository active node if you want Tableau Server to select a specific node upon startup.
For more information see Repository Failover.

Cause

This issue may be related to the poor performance of the computer running the active repository.

Additional Information

  • The ID is a unique request ID from the Gateway logs. Look for the requested ID in vizqlserver log, you may find the error "org.postgresql.util.PSQLException: ERROR: cannot execute UPDATE in a read-only transaction" like follows:
// vizqlserver_node3-0.log
2021-03-29 09:34:29.351 +0900 (,,-,YGEglXdXY-UU88oBd1v7rgAAA6M) catalina-exec-86 : WARN  wgsessionId=mMVKWIloTBi7EO3rgXO8yg org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 0, SQLState: 25006
...
Caused by: org.postgresql.util.PSQLException: ERROR: cannot execute UPDATE in a read-only transaction
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) ~[postgresql-42.2.5.jar:42.2.5]
 
  • For more information about improving the performance of the Tableau Server, see Performance Tuning.
Did this article resolve the issue?