COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => TM1 => Topic started by: simeun on 26 Dec 2023 02:24:31 PM

Title: Using Turbointegrator to import data to TM1 dimension - string data truncation
Post by: simeun on 26 Dec 2023 02:24:31 PM
Hi,
I have a Turbointegrator (TI) process that is reading data from relational database via ODBC connection.
Data are retrieved via select * from database_view , written into TI variables and then used to create/update elements in TM1 dimension.
Most variables are strings, some are numeric. This process is in use couple of years.
However, it suddenly started reporting an error in log file that an element name is not unique.
When I looked into the issue, I could see that source string that is 300 characters long is truncated to 256 characters - I could see it when I included where clause into the query so to retrieve just one row.
In the sample data I could see the diference between original string and string shown as a sample.
Because it is truncated, it is not unique any more.
Does anyone have any ide what may be a cause of this?