June 17, 2005 at 6:57 am
Hello Everyone, I seem to be in a bit of a jam here.
I have 4 sql servers 2000 SP3 running on windows 2000 sp4
3 of them are in 3 differents phisical location they are linked using a ADSL connection trough a VPN
These server replicate a database using a combination of merge and transactional publications.
Lets call these server 1, 2, 3.
Server 1 is the publisher
The fourth server acts only as a distributer for the other 3 and is in the same location as server 1
The subscribers use pull subscription to connect to the publications
Now with the problem... A few days ago some of my pull subscriptions to 2 merge publications started to not replicating anymore, returning with the message "The Process could not deliver dummy update at the Publisher" The error number supplied is -2147200993.
I stated preparing a plan to delete the subscriptions and recreate them (I needed to prepare a few sql scripts to reupdate the data manually in all 3 locations) when some other Subscriptions started acting the same way.
I checked database space and log space on all 4 servers and they all have plenty
Anyone ever experienced something like this before. Im at a lost here.
Thanks in advanc e for any input
Alain
June 17, 2005 at 8:01 am
This is the original message from the Merge agent error window.
LAST COMMAND IS:
{call sp_MSdummyupdate (?,?,?,?,0)}
ERROR MESSAGE IS:
The process could not deliver dummy update at the 'Publisher'.
ERROR DETAIL IS:
The process could not deliver dummy update at the 'Publisher'.
(Source: Merge Replication Provider (Agent); Error number: -2147200993)
---------------------------------------------------------------------------------------------------------------
Must declare the variable '@encolv'.
(Source: STDENIS (Data source); Error number: 137)
---------------------------------------------------------------------------------------------------------------
Incorrect syntax near the keyword 'else'.
(Source: STDENIS (Data source); Error number: 156)
---------------------------------------------------------------------------------------------------------------
Line 121: Incorrect syntax near 'se'.
(Source: STDENIS (Data source); Error number: 170)
---------------------------------------------------------------------------------------------------------------
June 17, 2005 at 8:26 am
I did a bit more research and I found this in the MSDN Library
The error detail for -2147200993 is:
SPERR_RULE_NOT_DYNAMIC : An attempt was made to modify a non-dynamic rule.
Hex number of the error is: 0x8004501f
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply