Hello Knox Hutchinson,
The data extract is too large and the refresh exhausts available system resources.
Here are what I would advise you to do:
- Verify that the machine hosting Tableau Server meets hardware requirements. For more information, see Before you install...
- Create a smaller extract or break large extract into subset extracts if needed.
Thanks for the tips! We have definitely thrown lots of resources at this server, and it runs on top of some very expensive hardware, so I know that is not the issue. I can't create an extract because I can't query the data in the first place to create the extract.
This question is confusing, so...
First, what version of Desktop and Server are you using?
Second, can you produce a working viz using Desktop?
Third, is the error coming from Desktop or Server or both?
Please don't skimp on details.
We are using version 10 of both Desktop and Server. We regularly use Desktop and Server to connect to Excel files, Access files, and SQL Server databases. The error is coming from Desktop. Desktop is able to connect to the ODBC database and list the available tables, but when I try to actually see the records in the tables either by Custom SQL Query or by just dragging the tables onto the Data preview pane, that is when it throws the error. Like I said, other tools like Access are able to query data in the ODBC database with no issue.
If you haven't already created a ticket with Tableau Support I'd recommend you do that as I think it's the most likely way to get this solved.
ODBC is rather limited with Tableau If you don't make progress you can try Tableau Support, however, they will make it clear that they do not support ODBC for data source connections.
Have you looked at the Desktop logs for clues? The folder is "Logs" and is a sub-folder in your Tableau Repository.
I have looked, but as I mentioned above, nothing really stands out to me. I'm not 100% sure what I should be looking for though. Worst case scenario is I end up creating an SSIS package to run nightly to re-import the data. I'll submit a ticket and see how that goes
Could you try change your custom SQL to select a different field and see if that works? I.e. SELECT [agents].[name] from [agents]
I did a quick google of the error you're getting (the lexical element) and it looks like it's caused by invalid SQL. So, it's either your custom sql which is causing a problem or, it's the SQL which is generated by Tableau. Tableau generates some SQL to prepare statements etc, it could be a problem with their syntax on your DB. You can view the underlying SQL being generated in the logs or like this Viewing Underlying SQL Queries | Tableau Software