If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Using Turbointegrator to import data to TM1 dimension - string data truncation

Started by simeun, 26 Dec 2023 02:24:31 PM

Previous topic - Next topic

simeun

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?