locked
MDS throwing arithmetic overflow error RRS feed

  • Question

  • We are using SQL server 2012 MDS - we have been getting arithmetic overflow error whenever someone tries to updae/add a new record to any entity. We use auto-generated code in most cases.

    This is the exact error message -

    Arithmetic overflow error converting IDENTITY to data type int.

    How do we resolve this error in MDS? We are using MDS in-built functionality, so wondering what went wrong.

    Thanks,

    Sonal

    Tuesday, September 4, 2018 6:09 PM

All replies

  • Have you checked Seed value and next value for entities? Not sure if it's still valid for MDS 2012, below code could help

    SELECT codeGen.*
    , ent.[Name]
    FROM mdm.tblCodeGenInfo As codeGen
    INNER JOIN mdm.tblEntity As ent ON
    codeGen.EntityId = ent.ID
    AND ent.Name = '<entityName>'
    AND ent.Model_ID = <modelID>

    You would need to run above code against database configure for MDS.

    - Harish

    Wednesday, September 5, 2018 5:06 AM
  • Thanks Harish

    I tried this and everything looks alright for all the tables - well within INT limits.

    It is the transaction table (tblTransaction) that might be creating the problem is what we are thinking. Do you know how to purge data in there?

    Thanks,

    Sonal

    Wednesday, September 5, 2018 2:16 PM