bug Report - Recreating an reserved property
In short... If you delete a pre-defined item property, in this case - item number, and then later recreate it, it will throw a String or Binary truncation error exception when trying to save an instan...
Forum Discussion
Chris,
Was just working in my "Models" item, plugging along like expected. Went into my Item definition and switched versioning from Automatic to Manul. Now throwing
String or binary data would be truncated. The statement has been terminated. in SQL: INSERT INTO [MODEL] ( [AM_PART],[ANIMAL],[ANTENNA],[ATTACHMENT],[BATTERY_MAH],[BATTERY_SELECT],[CONFIG_ID],[CONTROLLER_BOARD],[CREATED_BY_ID],[CREATED_DATE],[CREATED_ON],[CRUSH_DEPTH],[CURRENT_STATE],[DANGEROUS_GOODS],[EFFECTIVE_DATE],[ENGINEERING_DRAWING],[GENERATION],[HEIGHT],[ID],[IS_CURRENT],[IS_RELEASED],[KEYED_NAME],[LENGTH],[LOCKED_BY_ID],[MAJOR_REV],[MANAGED_BY_ID],[MODIFIED_BY_ID],[MODIFIED_ON],[NEW_VERSION],[NOT_LOCKABLE],[OWNED_BY_ID],[PDF_3D],[PERMISSION_ID],[PHOTO],[PRODUCT_LINE],[RATED_DEPTH],[RELEASE_DATE],[SALES_DRAWING],[SALES_PRICE],[STATE],[SUPERSEDED_DATE],[TAG_TYPE],[TEAM_ID],[THUMBNAIL],,[WEIGHT],[WIDTH],[MODEL_NUMBER] ) VALUES ( @p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10,@p11,@p12,@p13,@p14,@p15,@p16,@p17,@p18,@p19,@p20,@p21,@p22,@p23,@p24,@p25,@p26,@p27,@p28,@p29,@p30,@p31,@p32,@p33,@p34,@p35,@p36,@p37,@p38,@p39,@p40,@p41,@p42,@p43,@p44,@p45,@p46,@p47 )Will try and get into debugging mode to see what I can dig out of this.
