April 16, 2009 at 2:27 pm
Version 9.00.3068.00SP2Standard Edition (64-bit)
Hello, maybe somebody has any ideas why the below error is occuring and how to fix it.
When I run sp_updatestats or update statistics [TableName] on a large table (~50 million rows) I get the following error causing the job to fail.
Msg 8134, Sev 16, State 1, Line 1 : Divide by zero error encountered
If I manually update statistic on each index it works ok i.e update statistics [TableName] [IndexName]
but when I run the sp_updatestats or update statistics it fails.
Not quite sure if this is a table error or sql bug!!
Thanks
April 16, 2009 at 2:57 pm
That sounds like a bug to me. I'd definitely contact Microsoft about it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 16, 2009 at 9:04 pm
I guess it is a built-in data type issue (bug). After running update statistics against each table, did it happen again if you try to run sp_updatestats?
April 16, 2009 at 9:49 pm
I did try that and it still failed with the same error.
So individually running updates stats on explicitly declared indexes worked fine but update stats on the entire table or sp_updatestats failed.
Is there any possibility computed columns on the table could be causing issues?
There are no indexes on these columns.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply