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

Published: 28 Dec 2016
Last Modified Date: 23 Jan 2020


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.


Tableau Server


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.


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 ( - 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"

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