I use Oracle with 9.1.2 (I have used it with all versions since v8).
A few questions -
Do you have other reports running which work? Or is it everything which doesn't work?
Do you run Desktop on the same machine as Server or different machines?
Have you upgraded the drivers? Drivers & Activation | Tableau Software
In addition to Emma's questions from here > Workbook displays blank in Tableau Server after upgrade
Moving to Server Admin.
Thanks for the help, there are other reports running that use custom sql and work fine.
desktop is running on different machines to server
drivers are all updated
in response to Emma's questions, they all work fine in desktop, as soon as they go to server they stop, no tns errors, no errors at all from the server on refresh just no data returned.