Skip to content

usp_AdaptiveIndexDefrag / Error converting data type bigint to numeric #312

@eliasbalasis

Description

@eliasbalasis

This seems to be happening during collection of statistics, leaving the defragmentation effort incomplete.

   Selecting a statistic to update...
   Getting information on selected statistic...
   Determining modification row counter for statistic [...] on table or view [...] of DB [...]...
     Using sys.dm_db_stats_properties DMF...
     Error 8114 has occurred while determining row modification counter. Message: Error converting data type bigint to numeric. (Line Number: 0)
     Found a row modification counter of 0.000 and 332 rows...
     No need to update statistic [...] on DB [...] and object [...]...

The relevant table has a field of type bigint which seems to be where the conflict is originating from.

Without a fix for this the tool cannot be used efficiently.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions