KNOWLEDGE BASE

Error: "Session Ended by Server" When Viewing Workbook Connected to Live Oracle Datasource


Published: 28 Dec 2016
Last Modified Date: 11 Apr 2017

Issue

When viewing a published workbook that utilizes a live connection to an Oracle data source, the following error may be received:

Session Ended by Server: An unexpected error occurred. If you continue to receive this error, please contact your Tableau Server Administrator.

Environment

Tableau Server 9.1

Resolution

Option 1

Ensure that the Tableau Server Run As User account has sufficient privileges to create Temp Tables in the Oracle Database.

Option 2

Use an extract of the data source so that the permissions of the database are not impacting the Run As User account.
 

Cause

The Tableau Server's Run As User account has insufficient privileges to create temp tables which is necessary to perform some actions. 

Additional Information

The Tableau Server's VizQL logs will show several messages and errors:
  • ​Connection to database: "Connected to Oracle version (11.2.0.4.0 - Oracle Database 11g Enterprise Edition (64bit Production))"
  • Trying to create temp tables: {"query":"CREATE GLOBAL TEMPORARY TABLE \"#Tableau_0_sid:26758410_1\" ON COMMIT PRESERVE ROWS AS\nSELECT *\nFROM (SELECT *\nFROM (SELECT COUNT(*) AS COL FROM DUAL) CHECKTEMP)\nWHERE ROWNUM <= 1","protocol-id":2,"query-hash":1234568789}
  • Failure to create temp tables: "Server error (pid=1234): \n  " and then "DataSourceException (type=Unknown): Oracle database error 1031: ORA-01031: insufficient privileges\n"
  • Trying to use temp tables: {"query":"TRUNCATE TABLE \"#Tableau_0_sid:26758410_1\"","protocol-id":2,"query-hash":1234568789}
  • Failure to use temp tables: "Server error (pid=1234): \n  " and then "DataSourceException (type=Unknown): Oracle database error 942: ORA-00942: table or view does not exist\n"
Did this article resolve the issue?