I have a workbook connected to oracle data source - live connection. When I connect to Oracle test database and publish the workbook to tableau server it works perfectly fine but when I change the Oracle connection to point to production database the data is refreshed in Tableau desktop but while trying to publish it to the server I get the following error.
'SESSION ENDED BY SERVER'
"Tableau Exception:Oracle database error 942: ORA-00942:
table or view does not exist Unable to connect to the server "Prod".
Check the server is running and that you have access privileges to the
The Workbook is using custom SQL and I also ran the query against the Oracle production database and it retrieved the results perfectly. The issue occurs only while publishing it to the server.
Has anyone come across this error?
I've seen errors similar to this, although I don't work in Oracle at all. Every time I've reported an issue like this, Support has told me to restart the server as a solution. Magically, it has worked for me the majority of the time, although I'd rather know WHY an issue is occurring and that has been more difficult to discover.