Last Modified Date: 01 Jun 2017
- Tableau Desktop 10.2.0
- SharePoint Lists
ResolutionMake sure that none of the table names in the SharePoint are greater than 127 characters.
CauseThis is a limitation of the CData SharePoint driver. It will not provide the list of tables if any of them have a name that is longer than 127 characters.
Additional InformationTo find the table name that is preventing the list of tables from loading use a TDC file with these contents:
<connection-customization class='sharepoint' enabled='true' version='10.0'> <vendor name='sharepoint' /> <driver name='sharepoint' /> <customizations> <customization name='odbc-connect-string-extras' value='Verbosity=5;Logfile=/Users/YourUserName/cdata.log' /> </customizations> </connection-customization>
This will create a log file from the CData driver itself. Open the CData log in a text editor and search for "SQL_ERROR[HY000]: SQLTables The length of tablename". This will show the name of the table that caused the issue. There may be more than one table with too long of a name, but only the first one that triggers this error will be shown in the log.