Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2012
    Posts
    1

    Unanswered: value is out of range for data type "numeric". Update column to a legal value.

    Hi.,

    I have executed DBCC CHECKDB WITH
    NO_INFOMSGS. in my database (SQL server 2005)The following is the reult
    Msg 2570, Level 16, State 3, Line 1
    Page (1:391373), slot 2 in object ID 1879520508, index ID 1, partition ID
    72057596734472192, alloc unit ID 72057599004704768 (type "In-row
    data"). Column "TotalSumSy" value is out of range for data type "numeric".
    Update column to a legal value.
    CHECKDB found 0 allocation errors and 1 consistency errors in table 'IGE1'
    (object ID 1879520508).
    CHECKDB found 0 allocation errors and 1 consistency errors in
    database 'SKS'.

    Can ayn one help me in solving the issue?

  2. #2
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    Determine if the row is completely corrupt or if there is just one invalid value.

    Delete or change the row as needed.

    Did any rules change after the data was entered into the system? Knowing what caused this row to be as it is should be investigated.

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    If you were to query this table (run the following to see which table)
    Code:
    select object_name(1879520508)
    , do you get all valid TotalSumSy values? Does the query end abnormally at that value?

    A "total sum" sounds like it is generated from a different source. If that is the case, you can just try to re-update this summary value from the original source, and not lose anything.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •