Post reply

Error updating database

  • October 22, 2018 at 6:51 am

    #416256

    Hi,

    we are receiving the below error.

    Error Updating database:
    Arithmetic overflow error converting the expression to data type int.
    The statement has been terminated.

    how to find which table\column\datatype has this issue .

    Please suggest. Thank you.

  • October 22, 2018 at 7:07 am

    #2010569

    how to find which table\column\datatype has this issue .

    Look at the query which is generating the error.
    Look at the columns whose target is an INT.
    Of these, work out which are doing datatype conversions (from something to an INT). Hopefully it's not a long list.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • October 22, 2018 at 7:16 am

    #2010571

    It doesn't have to be an explicit conversion - it could be an arithmetical operation that exceeds the maximum value for the int data type, for example:

    SELECT 1048576 * 1048576

    John

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply