An import that does not complete, is missing data or data is truncated

me21
Kilo Contributor

I've worked in a table (u_dameon table) that is importing data from an Excel file and I'm using a transform map to add it to the sys_dictionary table. The table is working just fine but there is just one column (u_license_allowed_usage_scope) that is still not showing all the data that we required, it seems like it is locked at 40 chars, and the column max length was already set up for 300 values.

However, I was digging in for a solution in this community already and I found some really interesting files but none of them worked for this issue, in the beginning this column max length was set up for 40 chars value so I tried to change the value from source table to 256 saved and did a test running but for some reason it was doing the same then I changed to 300 but it didn't work either, here is a screenshot to have a better picture of what is happening.

Untitled.jpg

I'm new in service now so I don't have too much experience moving through it, but I will really appreciate if anybody can help me to find an answer for this  

Thanks in advance

Best regards

5 REPLIES 5

ludijormajor
Kilo Contributor

Hi Edmar,



Probably the field on your import set source table (staging table) does not have the desired length. Please checkout the length of the field in the staging table.



Best regards,


Ludijor