Could not process 'sp_replcmds' LogReader

I received the following error message after fours days of
SQL Server 2000 transactional replication.
Output Error from LogReader:
The process could not process 'sp_replcmds' command.
What would cause this error and stop the LogReader?
Thank You,
Dan
do logging as detailed in
http://support.microsoft.com/default...b;EN-US;312292
Post the log back here when you are done. This should give you more details
as to what the exact problem is.
"Dan" <anonymous@.discussions.microsoft.com> wrote in message
news:1c67501c42221$165bda00$a401280a@.phx.gbl...
> I received the following error message after fours days of
> SQL Server 2000 transactional replication.
> Output Error from LogReader:
> The process could not process 'sp_replcmds' command.
> What would cause this error and stop the LogReader?
> Thank You,
> Dan
>
>

Could not find stored procedure 'sp_MSin_<TableName>'

Hi,
Just completed the transactional replication and when tried to test the
changes made in the publisher data it (Distribution Agent) failed with the
following error:
Could not find stored procedure 'sp_MSupd_ACCOUNT'.
(Source: PARISDB2 (Data source); Error number: 2812)
Checked the sysobjects and all these procedures (sp_MSins, sp_MSupd etc) are
present in the database.
Current Configuration is: 1 Publisher, 1 Subscriber, Distributor database is
on the Publisher server, SQLServer 2000 (SP4), Windows 2003)
Please help me out....need to know the reason and the solution
Thanks & Regards
Sangra
Hi Sangra
This problem will happen when the snapshot schema is not applied on the
subscriber.
You can generate the scripts manually using the following procedure
exec sp_scriptinsproc 'articleid'
exec sp_scriptdelproc 'articleid'
exec sp_scriptmappedupdproc 'articleid'
Apply this script on the subscriber.
For getting the articleid check sysarticles table.
P. Srinivasan MCDBA
Consultant
C-13/1,GF,Tulip Garden, Ardee City,
Sector-52,
Gurgaon-122003
India
Mobile:+91-9810321551
"Sangra" <Sangra@.discussions.microsoft.com> wrote in message
news:1A700079-F991-4D00-82A6-756AF23CC16E@.microsoft.com...
> Hi,
> Just completed the transactional replication and when tried to test the
> changes made in the publisher data it (Distribution Agent) failed with the
> following error:
> Could not find stored procedure 'sp_MSupd_ACCOUNT'.
> (Source: PARISDB2 (Data source); Error number: 2812)
> Checked the sysobjects and all these procedures (sp_MSins, sp_MSupd etc)
> are
> present in the database.
> Current Configuration is: 1 Publisher, 1 Subscriber, Distributor database
> is
> on the Publisher server, SQLServer 2000 (SP4), Windows 2003)
> Please help me out....need to know the reason and the solution
> Thanks & Regards
> Sangra

could not find stored procedure 'dbo.sp_MSdropfkreferencingarticle'

Hi, I'm trying to generate a snapshot of a database (running on SQL 2005 SP1) prior to starting transactional replication to an SQL 7.0 server. After generating the snapshot, the agent fails with the error message 'could not find stored procedure 'dbo.sp_MSdropfkreferencingarticle' and suggests lookin at error number 2812 (which offers no help).

I was convinced this worked prior to installing SP1, but that testing was done some time ago....

Andy, this is a bug we need to fix (I am guessing you are using "truncate" as the pre-creation command). To workaround for now, you can:

1) Use drop as the pre-creation command

2) Create a dummy procedure "sp_MSdropfkreferencingarticle" at your 70 subscriber

-Raymond

|||Thanks Raymond, creating the dummy stored procedure worked OK without changing the pre-creation command from truncate to drop.

Could not find server 'x.x.x.x' in sysservers

I am trying to set up transactional replication between two SQL Server 2000
machines and when the synchronization starts (I'm pushing from the publisher
to the subscriber), I get the following error:
Could not find server 'x.x.x.x' in sysservers. Execute sp_addlinkedserver to
add the server to sysservers.
(Source: OLISSQLSERVER1 (Data source); Error number: 7202)
Any suggestions? Thanks in advance!
Use client network utility to mask the ip address with a host name.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tayo" <Tayo@.discussions.microsoft.com> wrote in message
news:AE594037-A5A0-4FB7-B237-76BA39F53BFB@.microsoft.com...
>I am trying to set up transactional replication between two SQL Server 2000
> machines and when the synchronization starts (I'm pushing from the
> publisher
> to the subscriber), I get the following error:
> Could not find server 'x.x.x.x' in sysservers. Execute sp_addlinkedserver
> to
> add the server to sysservers.
> (Source: OLISSQLSERVER1 (Data source); Error number: 7202)
> Any suggestions? Thanks in advance!
|||Could you explain to me where and how to do this? I did some looking online
but wasn't sure what to do. Thanks for your help!
"Hilary Cotter" wrote:

> Use client network utility to mask the ip address with a host name.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Tayo" <Tayo@.discussions.microsoft.com> wrote in message
> news:AE594037-A5A0-4FB7-B237-76BA39F53BFB@.microsoft.com...
>
>

Could not bulk insert. Bulk data stream was incorrectly specified as sorted.

hi, i am Oscar from Spain
I have a mistake in Transactional publication. The Error message is
"Could not bulk insert. Bulk data stream was incorrectly specified as
sorted"
I have checked in publisher and subscriber the command sp_helpsort and the
result is equal in both of them.
Can you help me? i can not to follow with replication configuration.
Thanks in advance
Best Regards,
Oscar Cano.
Message posted via http://www.sqlmonster.com
hi Paul
Thank you for answer so quickly.
How Could i check the collation in one table?
i do not know to do it this operation.
Can you help me?
Thanks and advance
Best Regards,
Oscar
Message posted via http://www.sqlmonster.com
|||Oscar,
unfortunately we don't know which table is causing the
problem, but possibly it is all of the tables with text
data if they have inherited the default database
collation. Anyway, right-click on a table in Enterprise
Manager and select to generate the script. Have a look
for the COLLATE part eg COLLATE COLLATE
SQL_Latin1_General_CP1_CI_AS and see if this is the
database collation on the subscriber. If not, then change
the database collation at the subscriber is the easiest
option, or alternatively on the article properties select
to take the article's collation.
HTH,
Paul Ibison, SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||hi Paul,
Well, i think that this property is not defined in this table.
please have a look at the following script:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].
[FK_CLIENTE_CONTRAT]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[CONTRAT_GENRAL] DROP CONSTRAINT FK_CLIENTE_CONTRAT
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].
[FK_CLIENTE_CONTRAT_SEDE]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[CONTRAT_SEDE] DROP CONSTRAINT FK_CLIENTE_CONTRAT_SEDE
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].
[CLIENTES_COD]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CLIENTES_COD]
GO
CREATE TABLE [dbo].[CLIENTES_COD] (
[Codigo] [numeric](7, 0) NOT NULL ,
[CIF] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AI NULL ,
[Nombre] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL ,
[rowguid] uniqueidentifier ROWGUIDCOL NOT NULL
) ON [PRIMARY]
GO
This is the script in Publisher Database.
Best Regards,
Oscar
Message posted via http://www.sqlmonster.com
|||Ocano,
you have the setting here:
[CIF] [nvarchar] (16) COLLATE
SQL_Latin1_General_CP1_CI_AI NULL ,
[Nombre] [nvarchar] (50) COLLATE
SQL_Latin1_General_CP1_CI_AI NOT NULL ,
Please check the subscriber to see if the database
setting is the same or different. If it says server
default, please check the server setting.
HTH,
Paul Ibison, SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||hi Paul,
In the subscribe, I have dropped this table and then I have to execute the
same creation table script than publisher server.
Then I have tried to execute the Push subscription and it is failed in the
same table clientes_cod.
Thanks
Best Regards,
Oscar
Message posted via http://www.sqlmonster.com
|||No this won't work as the initial script on
initialization will drop the table you have created.
Please check my previous post.
Rgds,
Paul Ibison, SQL Server MVP