6 Replies Latest reply on Oct 5, 2014 9:37 PM by Stuart Norton

    Data connection error only on Tableau Server?

    Stuart Norton

      Hi All,

       

      I am experiencing a strange issue where workbooks that work in Desktop will not work with Server.

       

      I have been changing the data connection user to a read-only user (Oracle 11gR2). They have sufficient access to the necessary tables to be able to run the relevant queries in SQL Developer and work fine in Desktop.

       

      I can publish the workbook ok but it gets an error when it does the preview at the end.

       

      An unexpected error occurred on the server. If you continue to receive this error please contact your Tableau Server Administrator.

      TableauException: Oracle database error 942: ORA-00942: table or view does not exist Unable to connect to the server "EAIP-ORA2". Check that the server is running and that you have access privileges to the requested database.
      2014-08-07 01:38:40.944 (U@LYoArw8hEAABOcNl4AAADG,0,1)

      Would you like to reset the view?

       

       

      In addition, when you attempt to connect through Server to the workbook, it stays in an endless cycle of connecting/waiting/reading/transferring (it's quick, so guessing the order) and won't load the report.

       

      Looking in tabprotosrv4.txt, it shows the query then the ORA-00942.

      That query works in Desktop.

      The log does not show the user it's trying to run as, but surely it's the one that was configured in the data connection.

       

      New workbooks all experience this error.

       

      Attempts to re-publish existing workbooks using the original user also fail with the same error.

      The only workbook I have been able to re-publish successfully since I started getting this issue is one that had the user updated a few days ago.

       

      Does anyone know what I might have done wrong?

        • 1. Re: Data connection error only on Tableau Server?
          Shawn Wallwork

          I have the geography errors show up on a client's remote system. I thought it was because I had been given very limited permissions. But now that I see this exact same error when I open your workbook on my local machine, I'm starting to think it's some sort of bug. You should send this workbook to support, and see if they get the same error. Maybe then can let us know what it is, and either fix it or at least tell us why it is happening.

           

          FYI: On my local machine I have full admin permissions, and I hadn't seen this error on my machine until I opened your workbook.

           

          --Shawn

          • 2. Re: Data connection error only on Tableau Server?
            Eric Chen

            Hello Stuart,

             

            As an ORA-00942 error typically indicates that a table or view does not exist, my first guess would be that it is a permissions issue as you have mentioned that the Oracle data connection user being used by Tableau Server is read-only and has limited permissions. Additional info regarding the ORA-00942 error code can be found here: http://ora-00942.ora-code.com/

             

            As an initial troubleshooting step, I would try giving the Oracle data connection user full permissions to the database. This way, you can identify whether or not permissions are the culprit for the current issue. If giving the Oracle data connection user full permissions to the database still does not resolve the issue, I would open up a case with Tableau Support (support@tableausoftware.com), as they would be better geared towards getting this issue resolved. When opening a support case, please be sure to include screenshots, as much information as possible, a packaged workbook that is affected by the issue and a full set of Tableau Server log files, as this will expedite the support process greatly.

             

            Hope this helps!

            Eric

            • 3. Re: Data connection error only on Tableau Server?
              Stuart Norton

              Hey guys,

               

              I restarted the server (which I can do without too much trouble luckily) seemed to resolve the issue. Maybe it was referring to some stale data connection info; I'm not sure.

               

              I also noticed that doing a table load caused the same error (worked fine on desktop but no permissions from server), but changing it to custom SQL "select * from..." worked. Go figure.

              • 4. Re: Data connection error only on Tableau Server?
                Eric Chen

                Hey Stuart,

                 

                Glad to hear that you were able to resolve the issue! When in doubt, restart!

                • 5. Re: Data connection error only on Tableau Server?
                  Stuart Norton

                  Ah, if only it were that simple.

                   

                  I have the same issue again with another workbook.

                   

                  Custom SQL, works fine in Tableau Desktop (which is on the same machine as the Server), but won't load from Tableau Server, giving the same ORA-00942 as per my original post.

                   

                  Have restarted the machine a couple of times, to no avail.

                  • 6. Re: Data connection error only on Tableau Server?
                    Stuart Norton

                    Got it to work (again) by embedding the password when I published.

                    More witchcraft than art (than science) to this...