MS SQL Server OLAP - Inconsistency Error

Author

Inconsistency Error

Ron

2006-01-26, 4:58 pm

Hello,

We use AS 2005. We have a fairly simple cube with 6-7 dimentions. One of the
dimentions is very large (10,000,000) members.
When processing the cube we get this error:

OLE DB error: OLE DB or ODBC error: An inconsistency was detected during an
internal operation in database 'tempdb'(ID:2) on page (1:28904). Please
contact technical support. Reference number 4.; HY000.

Sometimes the error will be something about a key that wasnt found..

So the error messages themselves are inconsistent as well and say very
little about what the problem is. The errors will happen also when the that
specific dimension has 9,000,000 members. These errors seem to come up only
when the dimension is around those sizes but not always.

Please advise,
Yoni.

Peter Yang [MSFT]

2006-01-26, 4:58 pm

Hello Ron,

Based on my research, I didn't find any known issue about this error. Since
the issue only appears after members getting to some specific numbers, I
suspect it is related to size of tempdb. You may want to increse the size
of tempdb to test the situation.

To find out the root cause of this issue we may need to analyze memory
dumps, this work has to be done by contacting Microsoft Product Support
Services. Therefore, we probably will not be able to resolve the issue
through the newsgroups. If the issue persists, I recommend that you open a
Support incident with Microsoft Product Support Services so that a
dedicated Support Professional can assist with this case. If you need any
help in this regard, please let me know.

For a complete list of Microsoft Product Support Services phone numbers,
please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

====================
====================
=============

Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:

BCPS:
https://partner.microsoft.com/US/te...erview/40010469

Others: https://partner.microsoft.com/US/te...upportoverview/

If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/defaul...a
l.aspx.

====================
====================
=============

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
>From: "Ron" <ron@newsgroups.nospam>
>Subject: Inconsistency Error
>Date: Wed, 25 Jan 2006 12:14:57 -0800
>Lines: 21
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <#VmHEweIGHA.3700@TK2MSFTNGP15.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.olap
>NNTP-Posting-Host: 209-77-216-34.utopy.com 209.77.216.34
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.olap:66580
>X-Tomcat-NG: microsoft.public.sqlserver.olap
>
>Hello,
>
>We use AS 2005. We have a fairly simple cube with 6-7 dimentions. One of
the
>dimentions is very large (10,000,000) members.
>When processing the cube we get this error:
>
>OLE DB error: OLE DB or ODBC error: An inconsistency was detected during
an
>internal operation in database 'tempdb'(ID:2) on page (1:28904). Please
>contact technical support. Reference number 4.; HY000.
>
>Sometimes the error will be something about a key that wasnt found..
>
>So the error messages themselves are inconsistent as well and say very
>little about what the problem is. The errors will happen also when the
that
>specific dimension has 9,000,000 members. These errors seem to come up
only
>when the dimension is around those sizes but not always.
>
>Please advise,
> Yoni.
>
>
>

Sponsored Links