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] (...
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.

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?