tigertoolbox icon indicating copy to clipboard operation
tigertoolbox copied to clipboard

usp_AdaptiveIndexDefrag / Error converting data type bigint to numeric

Open eliasbalasis opened this issue 6 months ago • 0 comments

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.

eliasbalasis avatar Aug 19 '24 05:08 eliasbalasis