Share via

SQL error of -8115 Arithmetic overflow error converting IDENTITY to data type decimal

Anonymous
2024-01-11T06:39:11+00:00

A column(USER_MSG_SEQ_NUM) is declared with the property IDENTITY with the datatype as DECIMAL (05,00) for one of the table. When the maximum value for this field reaches 99999, MS-Sql doesn’t have an option(automatic) to reset the value to 1 and so it abends with the error message as "Arithmetic overflow error converting IDENTITY to data type decimal ". Below are field declaration.

SEQ_NUM      DECIMAL (05, 00) NOT NULL IDENTITY (1, 1).

Need inputs to fix this issue by resetting the value to 1 similar to the option we have with DB2 database

MS-SQL version we use in the application is 5.16.3

Microsoft 365 and Office | Access | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-01-11T07:55:24+00:00

    Thanks Ryan for your help in sharing the correct link.

    I have raised my query in the link you provided.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-01-11T07:44:13+00:00

    Hi Priya Nambi_1305,

    It seems you looking for the solution for solving issue on Microsoft SQL Server. Please note that the topic here is specifically for Office application - Microsoft Access.

    If you need help for Microsoft SQL Server, SQL Server - Microsoft Q&A is recommended place for seeking assistance for the product.

    If I misunderstand the question, feel free to post back.

    Regards,

    Ryan | Microsoft Community Moderator

    Was this answer helpful?

    0 comments