An import that does not complete, is missing data or data is truncated
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-23-2015 09:39 AM
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.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-12-2016 08:22 AM
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