Loading

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

Publiseringsdato: May 2, 2025
Beskrivelse
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.

Cause

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

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.
 
Flere ressurser
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"


Knowledge-artikkelnummer

001498343

 
Laster
Salesforce Help | Article