Error message – Arithmetic overflow error converting IDENTITY to data type int.

Modified on Fri, 18 Oct, 2024 at 11:25 AM

Error message – Arithmetic overflow error converting IDENTITY to data type int.




Error is seen while running a data transfer from the Direct Connect “Trigger Tool.”


Root Cause: One of the table columns in the RDM/ReportFYI database is restricted to a maximum of 256 columns. If a customer runs a transfer more than that max count, then there will be an issue with the insert.


Issue is resolved by Truncating the JHDTV4 table.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article