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.
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.