When using Teradata connector in Qlik ODBC Connector Package to connect to a Teradata database, filed names which are longer than 30 characters will be shorten to 30 first characters. As a result, Data preview and reload fails with error
"Column <shortened name> not found".
This is a known limitation of Qlik ODBC Connector Package, which is currently investigated in bug QVXODBC-744
Consider the following work-around solutions:
- Modify filed names in the database to make sure imported field names are shorter than 30 chars
- Use SELECT * instead of SELECT <fields> in the reload script. Note: this will load all data from the table, which will increase traffic between QlikView/ Qlik Sense and Teradata. Unnecessary fields may need to be removed later by resident loading and dropping the temp table. This solution should only be applied for small data tables.
- Configure a generic ODBC connection using official Teradata ODBC driver instead of Qlik ODBC Connector package. Teradata ODBC driver can be downloaded at http://downloads.teradata.com/download/connectivity/odbc-driver/windows