Forum Discussion

Jacky_Phan's avatar
Jacky_Phan
Ideator I
6 years ago
Solved

Error while doing mass promotion

I'm trying to do mass promotion but got following error after executed:

String or binary data would be truncated.
The statement has been terminated. in SQL: INSERT INTO [MPO_MASSPROMOTIONRECORD] ( [BEFORE_PROMOTE_ITEM_ID],[BEHAVIOR],[CONFIG_ID],[CREATED_BY_ID],[CREATED_ON],[CURRENT_STATE],[GENERATION],[GOT_COMMENT],[ID],[IS_CURRENT],[IS_PROMOTED],[IS_RELEASED],[ITEM_CONFIG_ID],[ITEM_KEYED_NAME],[KEYED_NAME],[LOCKED_BY_ID],[MAJOR_REV],[MANAGED_BY_ID],[MODIFIED_BY_ID],[MODIFIED_ON],[NEW_VERSION],[NOT_LOCKABLE],[OWNED_BY_ID],[PERMISSION_ID],[RELATED_ID],[SORT_ORDER],[SOURCE_ID],[STATE],[STATE_BEFORE],[STATUS_ERROR],[TEAM_ID] ) 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 )

Anyone know how to fix it? Thanks.

Promote
  • Jacky_Phan's avatar
    Jacky_Phan
    6 years ago

    I finally fixed the error, length of keyed_name of promoted Item exceeds allowed length in promotion table field. I increased the length then it worked. Thanks.

3 Replies

  • Gopikrishnan's avatar
    Gopikrishnan
    Ideator I
    6 years ago

    Are you providing any inputs during the promotion?

    This error is because the input character length is more than the allowed character length.

    • Jacky_Phan's avatar
      Jacky_Phan
      Ideator I
      6 years ago

      I finally fixed the error, length of keyed_name of promoted Item exceeds allowed length in promotion table field. I increased the length then it worked. Thanks.

      • Barnali's avatar
        Barnali
        Ideator I
        6 years ago

        Is it the keyed_name or Item_keyed_name? What goes into each of the columns? I mean does the Item Name gets inserted into the Keyed_Name column of the promotion table?