Error: 29045--
Error: 0--The validity period of subscription went out. It is necessary to
re-initialize.
Error: 0--Subscription for 'SanyoMB_CE’publication is invalid.
Context:
Firstly, when I synchronized the above mentioned error occurs.
Although we carry out synchronization again, the same error occurs.
However, after 10 minutes, we carry out synchronization the third time, that
error does not occur, it runs normally.
What is the reason which make this error occur?
The reason you get this error is that your subscriber is off line for a
longer period than what you specified in the retention period or your
history retention period. Make sure both these values match and are set to a
reasonable level.
The reason you got the "Subscription for 'SanyoMB_CE'publication is invalid"
message is because your snapshot had not been created or had not finished
creation yet.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Mai Thoa" <MaiThoa@.discussions.microsoft.com> wrote in message
news:9708BCE3-39F6-4F85-92D4-58A1E41E69B4@.microsoft.com...
> Error: 29045--
> Error: 0--The validity period of subscription went out. It is necessary
to
> re-initialize.
> Error: 0--Subscription for 'SanyoMB_CE'publication is invalid.
> Context:
> Firstly, when I synchronized the above mentioned error occurs.
> Although we carry out synchronization again, the same error occurs.
> However, after 10 minutes, we carry out synchronization the third time,
that
> error does not occur, it runs normally.
> What is the reason which make this error occur?
>
|||Thanks for your quick respone.
Can I ask you why after the error "Error: 0--The validity period of
subscription went out. It is necessary tore-initialize." occurred 10 minutes
, and I carried out the third synchorization, it run normally?
I did not restart the agent, neither reinitialized the subscription.
"Hilary Cotter" wrote:
> The reason you get this error is that your subscriber is off line for a
> longer period than what you specified in the retention period or your
> history retention period. Make sure both these values match and are set to a
> reasonable level.
> The reason you got the "Subscription for 'SanyoMB_CE'publication is invalid"
> message is because your snapshot had not been created or had not finished
> creation yet.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "Mai Thoa" <MaiThoa@.discussions.microsoft.com> wrote in message
> news:9708BCE3-39F6-4F85-92D4-58A1E41E69B4@.microsoft.com...
> to
> that
>
>
|||I am not sure why this is? Is this for anonymous subscribers?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Mai Thoa" <MaiThoa@.discussions.microsoft.com> wrote in message
news:7A33F4E1-B57D-4F53-9B9F-3E0AF5BFC60C@.microsoft.com...
> Thanks for your quick respone.
> Can I ask you why after the error "Error: 0--The validity period of
> subscription went out. It is necessary tore-initialize." occurred 10
minutes[vbcol=seagreen]
> , and I carried out the third synchorization, it run normally?
> I did not restart the agent, neither reinitialized the subscription.
> "Hilary Cotter" wrote:
to a[vbcol=seagreen]
invalid"[vbcol=seagreen]
finished[vbcol=seagreen]
It is necessary[vbcol=seagreen]
time,[vbcol=seagreen]
|||Yes, that's right, It is subscription of anonymous subscriber.
Can you help me?
"Hilary Cotter" wrote:
> I am not sure why this is? Is this for anonymous subscribers?
> --
Friday, March 9, 2012
Merge replication error??
Labels:
0-subscription,
0-the,
29045-error,
database,
error,
merge,
microsoft,
mysql,
necessary,
oracle,
period,
replication,
server,
sql,
subscription,
tore-initialize,
validity
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment