"Keys out of order on page (1:10579653), slots 24 and 25..." error messages

Hi,
I have sql server 2000, sp3, and several production databases on this
server. From time to time, my integrity check jobs fail on some of databases
with the error message shown above (not always the same page/slot). This
errors occur on index pages, and I resolve them by rebuilding affected
indexes. Then everything works fine 1-2 weeks, and then again.
Hardware check didn't show anything wrong, but I'm still suspecting that
something is wrong with the disks (EMC, btw). It might be that some disk
block is corrupted. How can I check if it is always the same disk block
(from (1:10579653), slots 24 and 25)?
Interesting part is that I can use corrupted index by forcing the query
through hint, and it doesn't report any error.
Any help?
Thanks,
Peja
I'd run a DBCC CheckDB immediately.
"peja" <peja@.sympatico.ca> wrote in message
news:eJQ76UXrFHA.2072@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have sql server 2000, sp3, and several production databases on this
> server. From time to time, my integrity check jobs fail on some of
> databases
> with the error message shown above (not always the same page/slot). This
> errors occur on index pages, and I resolve them by rebuilding affected
> indexes. Then everything works fine 1-2 weeks, and then again.
> Hardware check didn't show anything wrong, but I'm still suspecting that
> something is wrong with the disks (EMC, btw). It might be that some disk
> block is corrupted. How can I check if it is always the same disk block
> (from (1:10579653), slots 24 and 25)?
> Interesting part is that I can use corrupted index by forcing the query
> through hint, and it doesn't report any error.
> Any help?
> Thanks,
> Peja
>

"Keys out of order on page (1:10579653), slots 24 and 25..." error messages

Hi,
I have sql server 2000, sp3, and several production databases on this
server. From time to time, my integrity check jobs fail on some of databases
with the error message shown above (not always the same page/slot). This
errors occur on index pages, and I resolve them by rebuilding affected
indexes. Then everything works fine 1-2 weeks, and then again.
Hardware check didn't show anything wrong, but I'm still suspecting that
something is wrong with the disks (EMC, btw). It might be that some disk
block is corrupted. How can I check if it is always the same disk block
(from (1:10579653), slots 24 and 25)?
Interesting part is that I can use corrupted index by forcing the query
through hint, and it doesn't report any error.
Any help?
Thanks,
PejaI'd run a DBCC CheckDB immediately.
"peja" <peja@.sympatico.ca> wrote in message
news:eJQ76UXrFHA.2072@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have sql server 2000, sp3, and several production databases on this
> server. From time to time, my integrity check jobs fail on some of
> databases
> with the error message shown above (not always the same page/slot). This
> errors occur on index pages, and I resolve them by rebuilding affected
> indexes. Then everything works fine 1-2 weeks, and then again.
> hardware check didn't show anything wrong, but I'm still suspecting that
> something is wrong with the disks (EMC, btw). It might be that some disk
> block is corrupted. How can I check if it is always the same disk block
> (from (1:10579653), slots 24 and 25)?
> Interesting part is that I can use corrupted index by forcing the query
> through hint, and it doesn't report any error.
> Any help?
> Thanks,
> Peja
>

"Keys out of order on page (1:10579653), slots 24 and 25..." error messages

Hi,
I have sql server 2000, sp3, and several production databases on this
server. From time to time, my integrity check jobs fail on some of databases
with the error message shown above (not always the same page/slot). This
errors occur on index pages, and I resolve them by rebuilding affected
indexes. Then everything works fine 1-2 weeks, and then again.
Hardware check didn't show anything wrong, but I'm still suspecting that
something is wrong with the disks (EMC, btw). It might be that some disk
block is corrupted. How can I check if it is always the same disk block
(from (1:10579653), slots 24 and 25)?
Interesting part is that I can use corrupted index by forcing the query
through hint, and it doesn't report any error.
Any help?
Thanks,
PejaI'd run a DBCC CheckDB immediately.
"peja" <peja@.sympatico.ca> wrote in message
news:eJQ76UXrFHA.2072@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have sql server 2000, sp3, and several production databases on this
> server. From time to time, my integrity check jobs fail on some of
> databases
> with the error message shown above (not always the same page/slot). This
> errors occur on index pages, and I resolve them by rebuilding affected
> indexes. Then everything works fine 1-2 weeks, and then again.
> Hardware check didn't show anything wrong, but I'm still suspecting that
> something is wrong with the disks (EMC, btw). It might be that some disk
> block is corrupted. How can I check if it is always the same disk block
> (from (1:10579653), slots 24 and 25)?
> Interesting part is that I can use corrupted index by forcing the query
> through hint, and it doesn't report any error.
> Any help?
> Thanks,
> Peja
>

"Invalid distribution command" in transaction replication

HI
I had a replication working nicely for long time. SQL 2k, SP3.
One day it stoped working with the error "Invalid distribution command." and
last action is: insert into "ponim" ("tz_pone.
Transaction sequence number and command ID of last execution batch are
0x0000829800000ABB000100000000 and 1.
I think maybe that day I added a new column using sp_repladdcolumn.
I want to say that the same script I run for that replication I ran for
another 3 similar replication and they all still work prefectly.
Any Ideas what I can do?
Please take in consider that I have lots of data in the publication that
couldn't be send to the subscriber becouse of the above error.
Thanks
use sp_browsereplcmds to identiy this command. Then apply this command
on the subcriber.
Then update msreplication_subscripions with the xaxct_seqno for this
command. This will cause it to skip this command.

"Invalid distribution command" in transaction replication

HI
I had a replication working nicely for long time. SQL 2k, SP3.
One day it stoped working with the error "Invalid distribution command." and
last action is: insert into "ponim" ("tz_pone.
Transaction sequence number and command ID of last execution batch are
0x0000829800000ABB000100000000 and 1.
I think maybe that day I added a new column using sp_repladdcolumn.
I want to say that the same script I run for that replication I ran for
another 3 similar replication and they all still work prefectly.
Any Ideas what I can do?
Please take in consider that I have lots of data in the publication that
couldn't be send to the subscriber becouse of the above error.
Thanksuse sp_browsereplcmds to identiy this command. Then apply this command
on the subcriber.
Then update msreplication_subscripions with the xaxct_seqno for this
command. This will cause it to skip this command.

"Invalid distribution command" in transaction replication

HI
I had a replication working nicely for long time. SQL 2k, SP3.
One day it stoped working with the error "Invalid distribution
command." and
last action is: insert into "ponim" ("tz_pone.
Transaction sequence number and command ID of last execution batch are
0x0000829800000ABB000100000000 and 1.
I think maybe that day I added a new column using sp_repladdcolumn.
I want to say that the same script I run for that replication I ran for
another 3 similar replication and they all still work prefectly.
Any Ideas what I can do?
Please take in consider that I have lots of data in the publication
that
couldn't be send to the subscriber becouse of the above error.
Thanks
Please enable logging as per this article:
http://support.microsoft.com/?id=312292 to get more details about the
failing command.
sp_browsereplcmds could also be used to find these details.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

"Invalid distribution command" in transaction replication

HI
I had a replication working nicely for long time. SQL 2k, SP3.
One day it stoped working with the error "Invalid distribution command." and
last action is: insert into "ponim" ("tz_pone.
Transaction sequence number and command ID of last execution batch are
0x0000829800000ABB000100000000 and 1.
I think maybe that day I added a new column using sp_repladdcolumn.
I want to say that the same script I run for that replication I ran for
another 3 similar replication and they all still work prefectly.
Any Ideas what I can do?
Please take in consider that I have lots of data in the publication that
couldn't be send to the subscriber becouse of the above error.
Thanks
use sp_browsereplcmds to identiy this command. Then apply this command
on the subcriber.
Then update msreplication_subscripions with the xaxct_seqno for this
command. This will cause it to skip this command.

"Invalid distribution command" in transaction replication

HI
I had a replication working nicely for long time. SQL 2k, SP3.
One day it stoped working with the error "Invalid distribution command." and
last action is: insert into "ponim" ("tz_pone.
Transaction sequence number and command ID of last execution batch are
0x0000829800000ABB000100000000 and 1.
I think maybe that day I added a new column using sp_repladdcolumn.
I want to say that the same script I run for that replication I ran for
another 3 similar replication and they all still work prefectly.
Any Ideas what I can do?
Please take in consider that I have lots of data in the publication that
couldn't be send to the subscriber becouse of the above error.
Thanksuse sp_browsereplcmds to identiy this command. Then apply this command
on the subcriber.
Then update msreplication_subscripions with the xaxct_seqno for this
command. This will cause it to skip this command.

"Invalid authorization specification"

Hello,

I have a web application (ISAPI) that accesses a SQL Server 2000 (sp3) database in the same machine as the Web Server (IIS 6). Windows 2003 Standard Edition is the operating System. So, when users access the aplication through the web it runs ok until display the error message "Invalid authorization specification" or, sometimes, another message about failure to inform ODBC DSN, although I dont use ODBC.

When the error occurs, the user press F5 in the browser and the operation goes ok. It's an intermitent and curious error.

Can somebody help me?

Thanks in advance.

Ado.I have no clue

http://www.easysoft.com/products/9999/faq_answer.phtml?ID=123&product=2002

ok, now with the pot shots...

"General network error. Check your network documentation."

I try to make a replication on my SQL Server2000 SP3 on Windows2000. I want to replicate 8 tables from Server1 to Server2. I found that 6 tables is work fine, however only 2 table that have an error that show below. How can I correct it?

The process could not deliver the snapshot to the Subscriber.

The process could not deliver the snapshot to the Subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
----------------------------------
The process could not bulk copy into table '"dbo"."Table1"'.
(Source: Server2 (Agent); Error number: 20037)
----------------------------------
General network error. Check your network documentation.
(Source: Server2 (Data source); Error number: 11)
----------------------------------Ok for the latest time I post my problem is only happen on Table1 but on Table2 is has something difference.

On Table1:
The process could not deliver the snapshot to the Subscriber.

The process could not deliver the snapshot to the Subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
----------------------------------
The process could not bulk copy into table '"dbo"."Table1"'.
(Source: Server2 (Agent); Error number: 20037)
----------------------------------
General network error. Check your network documentation.
(Source: Server2 (Data source); Error number: 11)
----------------------------------

On Table2:
The process could not query row metadata at the 'Subscriber'.

The process could not query row metadata at the 'Subscriber'.
(Source: Merge Replication Provider (Agent); Error number: -2147200996)
----------------------------------
Genetal network error. Check your network documentation.
(Source: Server2 (Data source); Error number: 11)
----------------------------------
The process was successfully stopped.
(Source: Merge Replication Provider (Agent); Error number: -2147199469)