search

sandeepmohan23 / yfai_data_migration

YFAI Data Migration
0 stars 0 forks source link

"The Input String is Too Long" Error #7

Open bzentgraf opened 7 years ago

bzentgraf commented 7 years ago

Getting "String is Too Long" errors for yf5_CustomerPartName:

Example Error: 32 characters maximum allowed for A9_PartCustomerInfoStorage:yf5_CustomerPartName

Occurs in these files located at /app/sitcons_testrun2/test_import/part_transfer ALL_PIECE_ITEMS_PART_10 ALL_PIECE_ITEMS_PART_100 ALL_PIECE_ITEMS_PART_101 ALL_PIECE_ITEMS_PART_102 ALL_PIECE_ITEMS_PART_103 ALL_PIECE_ITEMS_PART_104 ALL_PIECE_ITEMS_PART_105 ALL_PIECE_ITEMS_PART_106 ALL_PIECE_ITEMS_PART_107 ALL_PIECE_ITEMS_PART_108 ALL_PIECE_ITEMS_PART_109 ALL_PIECE_ITEMS_PART_11 ALL_PIECE_ITEMS_PART_110 ALL_PIECE_ITEMS_PART_111 ALL_PIECE_ITEMS_PART_113 ALL_PIECE_ITEMS_PART_114 ALL_PIECE_ITEMS_PART_115 ALL_PIECE_ITEMS_PART_116 ALL_PIECE_ITEMS_PART_117 ALL_PIECE_ITEMS_PART_119 ALL_PIECE_ITEMS_PART_12 ALL_PIECE_ITEMS_PART_120 ALL_PIECE_ITEMS_PART_121 ALL_PIECE_ITEMS_PART_193 ALL_PIECE_ITEMS_PART_194 ALL_PIECE_ITEMS_PART_195 ALL_PIECE_ITEMS_PART_196 ALL_PIECE_ITEMS_PART_197 ALL_PIECE_ITEMS_PART_198 ALL_PIECE_ITEMS_PART_199 ALL_PIECE_ITEMS_PART_2 ALL_PIECE_ITEMS_PART_20 ALL_PIECE_ITEMS_PART_200 ALL_PIECE_ITEMS_PART_201 ALL_PIECE_ITEMS_PART_202 ALL_PIECE_ITEMS_PART_203 ALL_PIECE_ITEMS_PART_204 ALL_PIECE_ITEMS_PART_205 ALL_PIECE_ITEMS_PART_206 ALL_PIECE_ITEMS_PART_207 ALL_PIECE_ITEMS_PART_208 ALL_PIECE_ITEMS_PART_209 ALL_PIECE_ITEMS_PART_21 ALL_PIECE_ITEMS_PART_210 ALL_PIECE_ITEMS_PART_211 ALL_PIECE_ITEMS_PART_212 ALL_PIECE_ITEMS_PART_213 ALL_PIECE_ITEMS_PART_214 ALL_PIECE_ITEMS_PART_215 ALL_PIECE_ITEMS_PART_216 ALL_PIECE_ITEMS_PART_217 ALL_PIECE_ITEMS_PART_218 ALL_PIECE_ITEMS_PART_219 ALL_PIECE_ITEMS_PART_22 ALL_PIECE_ITEMS_PART_220 ALL_PIECE_ITEMS_PART_221 ALL_PIECE_ITEMS_PART_222 ALL_PIECE_ITEMS_PART_223 ALL_PIECE_ITEMS_PART_224 ALL_PIECE_ITEMS_PART_225 ALL_PIECE_ITEMS_PART_226 ALL_PIECE_ITEMS_PART_227 ALL_PIECE_ITEMS_PART_228 ALL_PIECE_ITEMS_PART_229 ALL_PIECE_ITEMS_PART_23 ALL_PIECE_ITEMS_PART_230 ALL_PIECE_ITEMS_PART_231 ALL_PIECE_ITEMS_PART_232 ALL_PIECE_ITEMS_PART_233 ALL_PIECE_ITEMS_PART_31 ALL_PIECE_ITEMS_PART_311

rajender2k commented 7 years ago

@prem.shankar @sandeep.mohan ... Truncate yf5_CustomerPartName to 32 chars ..We should avoid these types of mapping misses in future...in assy_transfer folder .. its impacted to nearly 400 files out of 500

So now we end up re transforming and re importing again :-(

sandeepmohan23 commented 7 years ago

@premshankar1 assigning this to you.

Would you be able to come up with a perl script or some other method in order to determine all attribute mappings for which source attribute is shorter than target?

we would like to come up with a full list to pass onto YFAI so that they can determine if they should simply increase the target attribute size or if some other action is needed.

Could you have this report done by Thursday morning (6/22/2017) US time?

premshankar1 commented 7 years ago

Per Sarma's email dated 6/30, the target schema is updated to accommodate the string from source. Removed the truncate statement from Conversion.xml last week.