Consequences of Error 644?

My customer has encountered Error 644 (Could not find the index entry for RI
D
'%.*hs' in index page %S_PGID, index ID %d, database '%.*ls'.). I have
looked at the following KB entries:
PRB: Additional SQL Server Diagnostics Added to Detect Unreported I/O Proble
ms
http://support.microsoft.com/defaul...kb;en-us;826433
FIX: You receive a 644 error message when you run an UPDATE statement and
the isolation level is set to READ UNCOMMITTED
http://support.microsoft.com/?kbid=834290
I need help in interpreting this error for my customer. What they want to
know is:
1) Is this indicative of a larger problem?
2) Is it likely to happen repeatedly?
3) Is there a solution besides the available hotfix (since a hotfix is
always a scary thing to apply to a production system)?
Is there anything beyond what is offered in the above KB articles that can
help my customer?
Thanks,
RonYou'd do best to call CSS to get the exact answer.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"RonTop" <RonTop@.discussions.microsoft.com> wrote in message
news:DC27912A-11CA-4084-959B-2F414F7DD27E@.microsoft.com...
> My customer has encountered Error 644 (Could not find the index entry for
RID
> '%.*hs' in index page %S_PGID, index ID %d, database '%.*ls'.). I have
> looked at the following KB entries:
> PRB: Additional SQL Server Diagnostics Added to Detect Unreported I/O
Problems
> http://support.microsoft.com/defaul...kb;en-us;826433
> FIX: You receive a 644 error message when you run an UPDATE statement and
> the isolation level is set to READ UNCOMMITTED
> http://support.microsoft.com/?kbid=834290
> I need help in interpreting this error for my customer. What they want to
> know is:
> 1) Is this indicative of a larger problem?
> 2) Is it likely to happen repeatedly?
> 3) Is there a solution besides the available hotfix (since a hotfix is
> always a scary thing to apply to a production system)?
> Is there anything beyond what is offered in the above KB articles that can
> help my customer?
> Thanks,
> Ron|||If you get the errr while running DBCC - The error is telling you that a row
exists in a table, but the index entry for some index is missing... This
could be a transient problem, - one that occurs because you are running
DBCCs while users are making changes.. re-run DBCC on the table. If the
error moves to a different row or a different table, it is just a transient
error due to timing... However if the same error shows up in the same
location - it is a hard error and must be addressed.
You can drop and re-create the index, since the index is created from the
table.
If you get the error while running and UPdate statement, the KB article you
mention provideds the details. It says that the problem is a SQL Server
software problem, and will not lead to corruption. If it is this case, it
will happen repeatedly when the customer does the same work which caused the
issue originally... I would apply the hotfix - but I would first open a
call to PSS ($249) - to get their advice.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"RonTop" <RonTop@.discussions.microsoft.com> wrote in message
news:DC27912A-11CA-4084-959B-2F414F7DD27E@.microsoft.com...
> My customer has encountered Error 644 (Could not find the index entry for
RID
> '%.*hs' in index page %S_PGID, index ID %d, database '%.*ls'.). I have
> looked at the following KB entries:
> PRB: Additional SQL Server Diagnostics Added to Detect Unreported I/O
Problems
> http://support.microsoft.com/defaul...kb;en-us;826433
> FIX: You receive a 644 error message when you run an UPDATE statement and
> the isolation level is set to READ UNCOMMITTED
> http://support.microsoft.com/?kbid=834290
> I need help in interpreting this error for my customer. What they want to
> know is:
> 1) Is this indicative of a larger problem?
> 2) Is it likely to happen repeatedly?
> 3) Is there a solution besides the available hotfix (since a hotfix is
> always a scary thing to apply to a production system)?
> Is there anything beyond what is offered in the above KB articles that can
> help my customer?
> Thanks,
> Ron

Consequences of Error 644?

My customer has encountered Error 644 (Could not find the index entry for RID
'%.*hs' in index page %S_PGID, index ID %d, database '%.*ls'.). I have
looked at the following KB entries:
PRB: Additional SQL Server Diagnostics Added to Detect Unreported I/O Problems
http://support.microsoft.com/default.aspx?scid=kb;en-us;826433
FIX: You receive a 644 error message when you run an UPDATE statement and
the isolation level is set to READ UNCOMMITTED
http://support.microsoft.com/?kbid=834290
I need help in interpreting this error for my customer. What they want to
know is:
1) Is this indicative of a larger problem?
2) Is it likely to happen repeatedly?
3) Is there a solution besides the available hotfix (since a hotfix is
always a scary thing to apply to a production system)?
Is there anything beyond what is offered in the above KB articles that can
help my customer?
Thanks,
RonYou'd do best to call CSS to get the exact answer.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"RonTop" <RonTop@.discussions.microsoft.com> wrote in message
news:DC27912A-11CA-4084-959B-2F414F7DD27E@.microsoft.com...
> My customer has encountered Error 644 (Could not find the index entry for
RID
> '%.*hs' in index page %S_PGID, index ID %d, database '%.*ls'.). I have
> looked at the following KB entries:
> PRB: Additional SQL Server Diagnostics Added to Detect Unreported I/O
Problems
> http://support.microsoft.com/default.aspx?scid=kb;en-us;826433
> FIX: You receive a 644 error message when you run an UPDATE statement and
> the isolation level is set to READ UNCOMMITTED
> http://support.microsoft.com/?kbid=834290
> I need help in interpreting this error for my customer. What they want to
> know is:
> 1) Is this indicative of a larger problem?
> 2) Is it likely to happen repeatedly?
> 3) Is there a solution besides the available hotfix (since a hotfix is
> always a scary thing to apply to a production system)?
> Is there anything beyond what is offered in the above KB articles that can
> help my customer?
> Thanks,
> Ron|||If you get the errr while running DBCC - The error is telling you that a row
exists in a table, but the index entry for some index is missing... This
could be a transient problem, - one that occurs because you are running
DBCCs while users are making changes.. re-run DBCC on the table. If the
error moves to a different row or a different table, it is just a transient
error due to timing... However if the same error shows up in the same
location - it is a hard error and must be addressed.
You can drop and re-create the index, since the index is created from the
table.
If you get the error while running and UPdate statement, the KB article you
mention provideds the details. It says that the problem is a SQL Server
software problem, and will not lead to corruption. If it is this case, it
will happen repeatedly when the customer does the same work which caused the
issue originally... I would apply the hotfix - but I would first open a
call to PSS ($249) - to get their advice.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"RonTop" <RonTop@.discussions.microsoft.com> wrote in message
news:DC27912A-11CA-4084-959B-2F414F7DD27E@.microsoft.com...
> My customer has encountered Error 644 (Could not find the index entry for
RID
> '%.*hs' in index page %S_PGID, index ID %d, database '%.*ls'.). I have
> looked at the following KB entries:
> PRB: Additional SQL Server Diagnostics Added to Detect Unreported I/O
Problems
> http://support.microsoft.com/default.aspx?scid=kb;en-us;826433
> FIX: You receive a 644 error message when you run an UPDATE statement and
> the isolation level is set to READ UNCOMMITTED
> http://support.microsoft.com/?kbid=834290
> I need help in interpreting this error for my customer. What they want to
> know is:
> 1) Is this indicative of a larger problem?
> 2) Is it likely to happen repeatedly?
> 3) Is there a solution besides the available hotfix (since a hotfix is
> always a scary thing to apply to a production system)?
> Is there anything beyond what is offered in the above KB articles that can
> help my customer?
> Thanks,
> Ron

Consequences of Error 644?

My customer has encountered Error 644 (Could not find the index entry for RID
'%.*hs' in index page %S_PGID, index ID %d, database '%.*ls'.). I have
looked at the following KB entries:
PRB: Additional SQL Server Diagnostics Added to Detect Unreported I/O Problems
http://support.microsoft.com/default...b;en-us;826433
FIX: You receive a 644 error message when you run an UPDATE statement and
the isolation level is set to READ UNCOMMITTED
http://support.microsoft.com/?kbid=834290
I need help in interpreting this error for my customer. What they want to
know is:
1) Is this indicative of a larger problem?
2) Is it likely to happen repeatedly?
3) Is there a solution besides the available hotfix (since a hotfix is
always a scary thing to apply to a production system)?
Is there anything beyond what is offered in the above KB articles that can
help my customer?
Thanks,
Ron
You'd do best to call CSS to get the exact answer.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"RonTop" <RonTop@.discussions.microsoft.com> wrote in message
news:DC27912A-11CA-4084-959B-2F414F7DD27E@.microsoft.com...
> My customer has encountered Error 644 (Could not find the index entry for
RID
> '%.*hs' in index page %S_PGID, index ID %d, database '%.*ls'.). I have
> looked at the following KB entries:
> PRB: Additional SQL Server Diagnostics Added to Detect Unreported I/O
Problems
> http://support.microsoft.com/default...b;en-us;826433
> FIX: You receive a 644 error message when you run an UPDATE statement and
> the isolation level is set to READ UNCOMMITTED
> http://support.microsoft.com/?kbid=834290
> I need help in interpreting this error for my customer. What they want to
> know is:
> 1) Is this indicative of a larger problem?
> 2) Is it likely to happen repeatedly?
> 3) Is there a solution besides the available hotfix (since a hotfix is
> always a scary thing to apply to a production system)?
> Is there anything beyond what is offered in the above KB articles that can
> help my customer?
> Thanks,
> Ron
|||If you get the errr while running DBCC - The error is telling you that a row
exists in a table, but the index entry for some index is missing... This
could be a transient problem, - one that occurs because you are running
DBCCs while users are making changes.. re-run DBCC on the table. If the
error moves to a different row or a different table, it is just a transient
error due to timing... However if the same error shows up in the same
location - it is a hard error and must be addressed.
You can drop and re-create the index, since the index is created from the
table.
If you get the error while running and UPdate statement, the KB article you
mention provideds the details. It says that the problem is a SQL Server
software problem, and will not lead to corruption. If it is this case, it
will happen repeatedly when the customer does the same work which caused the
issue originally... I would apply the hotfix - but I would first open a
call to PSS ($249) - to get their advice.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"RonTop" <RonTop@.discussions.microsoft.com> wrote in message
news:DC27912A-11CA-4084-959B-2F414F7DD27E@.microsoft.com...
> My customer has encountered Error 644 (Could not find the index entry for
RID
> '%.*hs' in index page %S_PGID, index ID %d, database '%.*ls'.). I have
> looked at the following KB entries:
> PRB: Additional SQL Server Diagnostics Added to Detect Unreported I/O
Problems
> http://support.microsoft.com/default...b;en-us;826433
> FIX: You receive a 644 error message when you run an UPDATE statement and
> the isolation level is set to READ UNCOMMITTED
> http://support.microsoft.com/?kbid=834290
> I need help in interpreting this error for my customer. What they want to
> know is:
> 1) Is this indicative of a larger problem?
> 2) Is it likely to happen repeatedly?
> 3) Is there a solution besides the available hotfix (since a hotfix is
> always a scary thing to apply to a production system)?
> Is there anything beyond what is offered in the above KB articles that can
> help my customer?
> Thanks,
> Ron
sqlsql

Connection to Oracle sometimes hangs

Hi,

For a customer we have implemented a datawarehouse with a connection to
Oracle. From the beginning of the project the connection to Oracle
gives troubles. The next morning is the connection still active and
when the customer looks in the processes of SQL Server a " Wait type,
RESOURCE_SEMAPHORE." is shown. For what i know. SQL Server is waiting
for a resource, in this case Oracle but doesn't tell me anything about
what could be the problem.

The customer uses the Oracle driver instead of a microsft oracle
driver.

What could it be? and how can we tackle this problem? Are there ways to
look from Oracle point of view? Can we monitor something?

Greetz,
HennieHi

I am not sure if this will be any help, but may be worth a read!
http://support.microsoft.com/kb/280106/

John

"Hennie7863" <hdenooijer@.hotmail.com> wrote in message
news:1136279581.264058.154520@.g14g2000cwa.googlegr oups.com...
> Hi,
> For a customer we have implemented a datawarehouse with a connection to
> Oracle. From the beginning of the project the connection to Oracle
> gives troubles. The next morning is the connection still active and
> when the customer looks in the processes of SQL Server a " Wait type,
> RESOURCE_SEMAPHORE." is shown. For what i know. SQL Server is waiting
> for a resource, in this case Oracle but doesn't tell me anything about
> what could be the problem.
> The customer uses the Oracle driver instead of a microsft oracle
> driver.
> What could it be? and how can we tackle this problem? Are there ways to
> look from Oracle point of view? Can we monitor something?
> Greetz,
> Hennie|||Hi john, Thanx for your answer, but we dont use linked server. Just an
OLEDB connection (via UDL's) with Oracle. Well the customer has
investigated a bit further and told me that a value of 70 characters
is written into a field of 40 characters. When he executes the packages
by hand it will throw an error. When executed with aid of a job it will
continue running. So I think it could be a JOB problem in SQL Server
2000. Any one ideas?