Prev: Creating parameterized query in SSIS package
Next: Check Reporting Services Installation Programmitcally
From: Marlacoba on 17 Jul 2008 15:08
I'm receiving a 8115 arithmetic overflow error on a DBCC CHECKTABLE.
The clustered index is on a datetime column.
There are 20 million rows.
Version 8.00.2039 - I'm about to patch to 2187.
The indexes were rebuilt without error.

Dan
From: TheSQLGuru on 17 Jul 2008 17:07
Can you post the exact message recieved please?

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"Marlacoba" <Marlacoba(a)discussions.microsoft.com> wrote in message
news:DF887DCC-8552-4E6C-A215-CDE618BD3BAA(a)microsoft.com...
> I'm receiving a 8115 arithmetic overflow error on a DBCC CHECKTABLE.
> The clustered index is on a datetime column.
> There are 20 million rows.
> Version 8.00.2039 - I'm about to patch to 2187.
> The indexes were rebuilt without error.
>
> Dan


From: Marlacoba on 17 Jul 2008 20:09
Msg 8115, Level 16, State 1, Line 2
Arithmetic overflow error converting numeric to data type numeric.

Dan

"TheSQLGuru" wrote:

> Can you post the exact message recieved please?
>
> --
> Kevin G. Boles
> Indicium Resources, Inc.
> SQL Server MVP
> kgboles a earthlink dt net
>
>
> "Marlacoba" <Marlacoba(a)discussions.microsoft.com> wrote in message
> news:DF887DCC-8552-4E6C-A215-CDE618BD3BAA(a)microsoft.com...
> > I'm receiving a 8115 arithmetic overflow error on a DBCC CHECKTABLE.
> > The clustered index is on a datetime column.
> > There are 20 million rows.
> > Version 8.00.2039 - I'm about to patch to 2187.
> > The indexes were rebuilt without error.
> >
> > Dan
>
>
>
From: Steve Kass on 21 Jul 2008 15:44
Dan,

Are there any columns of DECIMAL or NUMERIC type in the table?
If so, exactly what precision and scale? The error you get is one that
occurs with those types - maybe a value in that column is somehow
corrupted.

Steve Kass
Drew University
http://www.stevekass.com

Marlacoba wrote:

>I'm receiving a 8115 arithmetic overflow error on a DBCC CHECKTABLE.
>The clustered index is on a datetime column.
>There are 20 million rows.
>Version 8.00.2039 - I'm about to patch to 2187.
>The indexes were rebuilt without error.
>
>Dan
>
>
From: Steve Kass on 21 Jul 2008 17:56
One more suggestion, from fellow MVP Erland Sommarskog: if the problem
is with a bad DECIMAL/NUMERIC value, the SQL Server 2005 version of
DBCC CHECKTABLE has a WITH DATA_PURITY option that will check
for this.

If this looks possible and you can backup the database, it could be worth
restoring it on a 2005 instance to run this, if you have a 2005 installation
available. (Judging from the documentation for DATA_PURITY, which
mentions databases upgraded from pre-2005 versions, this sort of
problem can probably survive a backup and restore/upgrade.)

Don't forget that I'm still just speculating that bad numeric values
are in fact a possible cause of your problem.

SK


Marlacoba wrote:

>I'm receiving a 8115 arithmetic overflow error on a DBCC CHECKTABLE.
>The clustered index is on a datetime column.
>There are 20 million rows.
>Version 8.00.2039 - I'm about to patch to 2187.
>The indexes were rebuilt without error.
>
>Dan
>
>
 |  Next  |  Last
Pages: 1 2 3 4
Prev: Creating parameterized query in SSIS package
Next: Check Reporting Services Installation Programmitcally