Problemas de replica

Hola Grupo, en una maquina con Win 2003 y SQL 2000 configuro:

Se configura una replica transaccional con un subscriptor que se actualiza
por push.
Se replica un solo artículo: una tabla idéntica (estructura y datos) en
ambas bases.

Transactional publication of Molino database from Publisher

Create a transactional publication from database 'Molino'.

The following types of Subscribers may subscribe to this publication:
Servers running SQL Server 2000

Publish the following tables as articles:
'M0_Clering' as 'M0_Clering'

The name of this publication is 'Clearing'. The description is
'Transactional publication of Molino database from Publisher
SMARTSOF-4OXMQ5.'.

Do not filter data in this publication.

Do not allow anonymous subscriptions to this publication.

Run the Snapshot Agent at the following scheduled times:
Occurs every 1 day(s), at 11:01:00 p.m.., ending 14/07/2005
Run the Snapshot Agent as scheduled.

Se crea correctamente.
SQL Server Enterprise Manager successfully created publication 'Clearing'
from database 'Molino'.

Se crea el subscritor (push)

Create a subscription to publication 'Clearing' from
Publisher 'SMARTSOF-4OXMQ5'.

Create a subscription at the following Subscriber(s):
SMARTSOF-4OXMQ5

Create each subscription in a database named 'Cereales'.

Run the Distribution Agent(s) continuously.

Do not initialize the subscription(s) with a snapshot; the
Subscriber(s) already has the data and schema.

Verify that the following services are started:
SQLServerAgent (on SMARTSOF-4OXMQ5)

Se crea correctamente.
Subscriptions were created successfully at the following Subscribers:
SMARTSOF-4OXMQ5

Al realizar una modificación en un registro en la base publicadora arroja:

Could not find stored procedure 'sp_MSupd_M0_Clering'.
(Source: SMARTSOF-4OXMQ5 (Data source); Error number: 2812)

Alguna idea .Gracias
Luis Bacigalupo

Hola Grupo, en una maquina con Win 2003 y SQL 2000 configuro:

Se configura una replica transaccional con un subscriptor que se actualiza
por push.
Se replica un solo artículo: una tabla idéntica (estructura y datos) en
ambas bases.

Transactional publication of Molino database from Publisher
SMARTSOF-4OXMQ5.

Create a transactional publication from database 'Molino'.

The following types of Subscribers may subscribe to this publication:
Servers running SQL Server 2000

Publish the following tables as articles:
'M0_Clering' as 'M0_Clering'

The name of this publication is 'Clearing'. The description is
'Transactional publication of Molino database from Publisher
SMARTSOF-4OXMQ5.'.

Do not filter data in this publication.

Do not allow anonymous subscriptions to this publication.

Run the Snapshot Agent at the following scheduled times:
Occurs every 1 day(s), at 11:01:00 p.m.., ending 14/07/2005
Run the Snapshot Agent as scheduled.

Se crea correctamente.
SQL Server Enterprise Manager successfully created publication 'Clearing'
from database 'Molino'.

Se crea el subscritor (push)

Create a subscription to publication 'Clearing' from
Publisher 'SMARTSOF-4OXMQ5'.

Create a subscription at the following Subscriber(s):
SMARTSOF-4OXMQ5

Create each subscription in a database named 'Cereales'.

Run the Distribution Agent(s) continuously.

Do not initialize the subscription(s) with a snapshot; the
Subscriber(s) already has the data and schema.

Verify that the following services are started:
SQLServerAgent (on SMARTSOF-4OXMQ5)

Se crea correctamente.
Subscriptions were created successfully at the following Subscribers:
SMARTSOF-4OXMQ5

Al realizar una modificación en un registro en la base publicadora arroja:

Could not find stored procedure 'sp_MSupd_M0_Clering'.
(Source: SMARTSOF-4OXMQ5 (Data source); Error number: 2812)

Alguna idea .Gracias
Luis Bacigalupo

> Do not initialize the subscription(s) with a snapshot; the
> Subscriber(s) already has the data and schema.

reconoces el nombre del SP o es uno de los que crea la replica?, por
que transfieres la estructura?
"lmb" wrote in message
news:OFq6i%
> Hola Grupo, en una maquina con Win 2003 y SQL 2000 configuro:
>
> Se configura una replica transaccional con un subscriptor que se

> por push.
> Se replica un solo artículo: una tabla idéntica (estructura y datos)
> en ambas bases.
>
> Transactional publication of Molino database from Publisher
SMARTSOF-4OXMQ5.
>
> Create a transactional publication from database 'Molino'.
>
> The following types of Subscribers may subscribe to this publication:
> Servers running SQL Server 2000
>
> Publish the following tables as articles:
> 'M0_Clering' as 'M0_Clering'
>
> The name of this publication is 'Clearing'. The description is
> 'Transactional publication of Molino database from Publisher
> SMARTSOF-4OXMQ5.'.
>
> Do not filter data in this publication.
>
> Do not allow anonymous subscriptions to this publication.
>
> Run the Snapshot Agent at the following scheduled times:
> Occurs every 1 day(s), at 11:01:00 p.m.., ending 14/07/2005 Run the
> Snapshot Agent as scheduled.
>
> Se crea correctamente.
> SQL Server Enterprise Manager successfully created publication

> from database 'Molino'.
>
> Se crea el subscritor (push)
>
> Create a subscription to publication 'Clearing' from Publisher
> 'SMARTSOF-4OXMQ5'.
>
> Create a subscription at the following Subscriber(s):
> SMARTSOF-4OXMQ5
>
> Create each subscription in a database named 'Cereales'.
>
> Run the Distribution Agent(s) continuously.
>
> Do not initialize the subscription(s) with a snapshot; the
> Subscriber(s) already has the data and schema.
>
> Verify that the following services are started:
> SQLServerAgent (on SMARTSOF-4OXMQ5)
>
> Se crea correctamente.
> Subscriptions were created successfully at the following Subscribers:
> SMARTSOF-4OXMQ5
>
> Al realizar una modificación en un registro en la base publicadora

>
> Could not find stored procedure 'sp_MSupd_M0_Clering'.
> (Source: SMARTSOF-4OXMQ5 (Data source); Error number: 2812)
>
> Alguna idea .Gracias
> Luis Bacigalupo
>
>
>
>
>

Hola.

Revisa la configuración de la publicación. Has de tener marcado que se use
un procedimiento almacenado específico (y no el genérico) para enviar los
updates. Sin embargo, no se ha creado el procedimiento almacenado al crear
la publicación (que sería lo suyo). Desconozco el motivo, pero a veces me

pasado. Tampoco lo has creado tú, aunque creo que no es lo que necesitas.

La forma de resolver el problema requiere que elimines la suscripción, ya
que si no no podrás modificar el artículo.

qwalgrande

"De lo que ves créete la mitad, de lo que no ves no te creas nada"
V. del V.


"lmb" escribió en el mensaje
news:OFq6i%
> Hola Grupo, en una maquina con Win 2003 y SQL 2000 configuro:
>
> Se configura una replica transaccional con un subscriptor que se

> por push.
> Se replica un solo artículo: una tabla idéntica (estructura y datos) en
> ambas bases.
>
> Transactional publication of Molino database from Publisher
> SMARTSOF-4OXMQ5.
>
> Create a transactional publication from database 'Molino'.
>
> The following types of Subscribers may subscribe to this publication:
> Servers running SQL Server 2000
>
> Publish the following tables as articles:
> 'M0_Clering' as 'M0_Clering'
>
> The name of this publication is 'Clearing'. The description is
> 'Transactional publication of Molino database from Publisher
> SMARTSOF-4OXMQ5.'.
>
> Do not filter data in this publication.
>
> Do not allow anonymous subscriptions to this publication.
>
> Run the Snapshot Agent at the following scheduled times:
> Occurs every 1 day(s), at 11:01:00 p.m.., ending 14/07/2005
> Run the Snapshot Agent as scheduled.
>
> Se crea correctamente.
> SQL Server Enterprise Manager successfully created publication

> from database 'Molino'.
>
> Se crea el subscritor (push)
>
> Create a subscription to publication 'Clearing' from
> Publisher 'SMARTSOF-4OXMQ5'.
>
> Create a subscription at the following Subscriber(s):
> SMARTSOF-4OXMQ5
>
> Create each subscription in a database named 'Cereales'.
>
> Run the Distribution Agent(s) continuously.
>
> Do not initialize the subscription(s) with a snapshot; the
> Subscriber(s) already has the data and schema.
>
> Verify that the following services are started:
> SQLServerAgent (on SMARTSOF-4OXMQ5)
>
> Se crea correctamente.
> Subscriptions were created successfully at the following Subscribers:
> SMARTSOF-4OXMQ5
>
> Al realizar una modificación en un registro en la base publicadora

>
> Could not find stored procedure 'sp_MSupd_M0_Clering'.
> (Source: SMARTSOF-4OXMQ5 (Data source); Error number: 2812)
>
> Alguna idea .Gracias
> Luis Bacigalupo
>
>
>
>
>