Replication Expired subscription clean up job failed

Don't know why this job failed since I deleted and rebuilt the subscriber and
publisher last week. Can someone help?
Error detail says: 'Executed as user: FOSTER\sqlservice. Could not find
stored procedure ''. [SQLSTATE 42000] (Error 2812) Associated statement is
not prepared [SQLSTATE HY007] (Error 0). The step failed.'
Appreciate your time.
Tsuey
Tsuey,
please take a look at this to see if it applies:
http://support.microsoft.com/kb/884854
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi Paul,
Thanks for the quick reply. I read this article and don't think it apply.
I don't think I created the replication as transactional replication with
queued updating. If I did, SQL Server will add a new column in each
replicated table, right? How can I sure that the replication is not
configured as queued update?
Tsuey
"Paul Ibison" wrote:

> Tsuey,
> please take a look at this to see if it applies:
> http://support.microsoft.com/kb/884854
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||Tsuey,
what is the 'update mode' if you run sp_helpsubscription?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi Paul, I tried to execute sp_helpsubscription in Query analyzer (hope this
is the right tool to run it) but how do I display the result set? I set the
result in grid or text or file, but can not get the result set to display.
It just simply tells me 'The command(s) completed successfully'. What did I
do wrong? The syntax I use is as below:
exec sp_helpsubscription
GO
"Paul Ibison" wrote:

> Tsuey,
> what is the 'update mode' if you run sp_helpsubscription?
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
|||You'll need to execute this at the publisher on the publication database and
provide the subscriber name.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi Paul, I got the sp_helpsubscription ran successfully!! The update mode
for all rows are 0's. It means 'read-only'. What does this tell me? FYI,
we configure the replication as a push replication.
Thanks for your time,
Tsuey
"Paul Ibison" wrote:

> You'll need to execute this at the publisher on the publication database and
> provide the subscriber name.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||OK - then the article definitely doesn't apply. I'd be tempted to reapply
your latest service pack on the distributor, publisher then subscriber. If
that doesn't resolve this issue they I'd raise a support case.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi Paul,
Thanks very much for your reply. I'll try appying the SP4 to see if it helps.
Tsuey
"Paul Ibison" wrote:

> OK - then the article definitely doesn't apply. I'd be tempted to reapply
> your latest service pack on the distributor, publisher then subscriber. If
> that doesn't resolve this issue they I'd raise a support case.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>

Replication does not work properly

Hi,
I have a problem with rows deleted at subscriber could not get deleted at
publisher in particular case where article published say table1 has row
filter like
"SELECT <published_columns> FROM [dbo].[TABLE1]
WHERE ([FILED1]='XYZ ' OR [FIELD4]= 'XYZ ') and FIELD3 in(select
[FIELD3] from [TABLE2] A where A.[FIELD1]=[FIELD1] and A.[FIELD2]=[FIELD2] )"
Rest of the Articles published with simpler row filter works perfectly.
Please Reply,
Thanking You
fatiya
are both Table1 and Table2 published? are there any constraints between teh
two tables? Are you enforcing these constraints for replication? Cascading
Updates/Deletes?
Have you used the conflict viewer to see if there are any conflicts?
Hilary Cotter
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
"Fatiya" <Fatiya@.discussions.microsoft.com> wrote in message
news:6A20CE4B-7D05-4202-BCEE-79AC26E28326@.microsoft.com...
> Hi,
> I have a problem with rows deleted at subscriber could not get deleted
at
> publisher in particular case where article published say table1 has row
> filter like
> "SELECT <published_columns> FROM [dbo].[TABLE1]
> WHERE ([FILED1]='XYZ ' OR [FIELD4]= 'XYZ ') and FIELD3 in(select
> [FIELD3] from [TABLE2] A where A.[FIELD1]=[FIELD1] and
A.[FIELD2]=[FIELD2] )"
> Rest of the Articles published with simpler row filter works perfectly.
> Please Reply,
> Thanking You
> fatiya
>
>
|||Dear Hilary
Thanks for reply
Yes both table 1 and table2 are published No there are no contrainst between
them
we have not used any cascading
We are getting replicaion conflicts that the row was inserted at subscriber
but
at publisher we are getting primary key constrains.
Please advice
Fatiya
"Hilary Cotter" wrote:

> are both Table1 and Table2 published? are there any constraints between teh
> two tables? Are you enforcing these constraints for replication? Cascading
> Updates/Deletes?
> Have you used the conflict viewer to see if there are any conflicts?
> --
> Hilary Cotter
> 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
> "Fatiya" <Fatiya@.discussions.microsoft.com> wrote in message
> news:6A20CE4B-7D05-4202-BCEE-79AC26E28326@.microsoft.com...
> at
> A.[FIELD2]=[FIELD2] )"
>
>
sql

Replication does not work after deleting the LDF file manually.

I have maually deleted the Database.LDF file by stopping the SQL Server. When i start the SQL Server, merge replication which was configured for the database does not work. How do i fix this problem.
Thanks in advance.
Regards,
Venu.Reinitialize the replication. It should pick up a new starting LSN. But why did you ever delete the LDF anyway?

Replication : Deleted Records Keep Reapearing

Im currently having problems with merge replication.

Example:

When a customer record is deleted from tbl_customers its removed from the table, then its reappears about 30s - 1min later?

Im presuming the other server is restoring the record though replication.

Any Insight in to this would be most appreciated.

DanielI've found the error but still not to sure why its occuring?

Heres the errors
------

"The row was deleted at 'ENTERPRISE.PMSPS' but could not be deleted at 'VOYAGER.PMSPS'. Invalid object name 'tbl_contacts'."

[Conflict Winner]
The error described above occurred when trying to delete this row. If you ignore this conflict, you should resolve it through other means. Consider logging the details of this conflict, then sending the log entry to your system administrator. The value of the unique ID in column 'rowguid' is '{D2604393-EBB4-4CF7-97BC-562C28B6BD1B}'.

[Conflict Loser]
This row has been deleted. If you choose to ignore the conflict, Microsoft SQL Server will try to reinsert the deleted row, using data from the other server.

I have the option to Keep winning change which will just put the record back in or I can Resubmit the DELETE which just comes back with the same error.

:(

Replication

when using snapshots in replication, these files get copied to the hard drive. Can they be automatically deleted after the snapshot is posted?
Thanks
Niles,
if you have anonymous subscribers then they'll stay around until the publication's subscriber's timeout value. If you have standard subscribers, these files will be removed once they have all initialized. For transactional, this is when the distribution a
gent of each subscriber has run. The agent which removes the snapshot files is the distribution cleanup agent, which runs every 10 mins. You could run this immediately (manually) after your last initialization or you could schedule it to run more frequent
ly.
HTH,
Paul Ibison
|||What is the difference between anonymous subscriptions and standard and can it be switched easily
Thanks
|||An anonymous subscription is a type of pull subscription for which detailed
information about the subscription and the Subscriber is not stored. The
Subscriber is responsible for keeping an anonymous subscription
synchronized, and they are particularly used if Subscribers use the Internet
to access publications.
sp_helpsubscription will tell you if the subscription is anonymous or
http://msdn.microsoft.com/library/de...repl3_4dym.asp
Typically, the Subscriber is not explicitly named at the Publisher when
using anonymous subscriptions. So to change from a named subscription to an
anonymous one is not so simple and you'd drop and recreate the subscription.
To see if any of this is relevant to your case have a look at the
allow_anonymous value of sp_helppublication.
HTH,
Paul Ibison

Replication

when using snapshots in replication, these files get copied to the hard drive. Can they be automatically deleted after the snapshot is posted
ThanksAn anonymous subscription is a type of pull subscription for which detailed
information about the subscription and the Subscriber is not stored. The
Subscriber is responsible for keeping an anonymous subscription
synchronized, and they are particularly used if Subscribers use the Internet
to access publications.
sp_helpsubscription will tell you if the subscription is anonymous or
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_repl3_4dym.asp
Typically, the Subscriber is not explicitly named at the Publisher when
using anonymous subscriptions. So to change from a named subscription to an
anonymous one is not so simple and you'd drop and recreate the subscription.
To see if any of this is relevant to your case have a look at the
allow_anonymous value of sp_helppublication.
HTH,
Paul Ibison

Replication

when using snapshots in replication, these files get copied to the hard driv
e. Can they be automatically deleted after the snapshot is posted?
ThanksNiles,
if you have anonymous subscribers then they'll stay around until the publica
tion's subscriber's timeout value. If you have standard subscribers, these f
iles will be removed once they have all initialized. For transactional, this
is when the distribution a
gent of each subscriber has run. The agent which removes the snapshot files
is the distribution cleanup agent, which runs every 10 mins. You could run t
his immediately (manually) after your last initialization or you could sched
ule it to run more frequent
ly.
HTH,
Paul Ibison|||What is the difference between anonymous subscriptions and standard and can
it be switched easily
Thanks|||An anonymous subscription is a type of pull subscription for which detailed
information about the subscription and the Subscriber is not stored. The
Subscriber is responsible for keeping an anonymous subscription
synchronized, and they are particularly used if Subscribers use the Internet
to access publications.
sp_helpsubscription will tell you if the subscription is anonymous or
l3_4dym.asp" target="_blank">http://msdn.microsoft.com/library/d.../>
l3_4dym.asp
Typically, the Subscriber is not explicitly named at the Publisher when
using anonymous subscriptions. So to change from a named subscription to an
anonymous one is not so simple and you'd drop and recreate the subscription.
To see if any of this is relevant to your case have a look at the
allow_anonymous value of sp_helppublication.
HTH,
Paul Ibison