1 Reply Latest reply on Nov 11, 2013 12:57 PM by Matt Lutton

    Publishing issues with live connection to database

    Banusaranya Duraisamy


      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

      requested database"

       

      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?