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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • 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