Developer forum

Forum » Development » EcomAssortmentItems - Arithmetic overflow error converting IDENTITY to data type int.

EcomAssortmentItems - Arithmetic overflow error converting IDENTITY to data type int.

E-mail notifications
Anders Ebdrup
Anders Ebdrup
Reply
Posted on 08/04/2019 19:19:22

Hello DW,

 

We are working with an integrated solution where we have had some issues with the assortments. The issue was related to the rebuilding process where we got this error:

Arithmetic overflow error converting IDENTITY to data type int.

To solve this, we have changed the type for: AssortmentItemAutoID to a bigint. Maybe this should be considered in the general solution.

 

Best regards, Anders


Replies

 
Anders Ebdrup
Anders Ebdrup
Posted on 13/06/2019 13:34:41
Reply

Hi agian,

 

Any news here for a permanent solution?

 
Anders Ebdrup
Anders Ebdrup
Posted on 08/08/2019 16:53:06
Reply

Any thoughts on this one?

 
Anders Ebdrup
Anders Ebdrup
Posted on 01/10/2019 14:50:07
Reply

Dear Dynamicweb,

 

Did you have any chance to look into this issue as we see it in more and more solutions?

 
Kristian Kirkholt Dynamicweb Employee
Kristian Kirkholt
Posted on 27/11/2019 13:40:41
Reply

Hi Anders

Sorry for the late reply. In version 9.7.4 we have changed assortment auto-id to bigint

That version should solve the problem

Kind Regards
Dynamicweb Support
Kristian Kirkholt

 

You must be logged in to post in the forum