Hello Everyone, I seem to be in a bit of a jam her

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Hello Everyone, I seem to be in a bit of a jam her

Author

Topic

alaniel
Starting Member

3 Posts

Posted - 2005-06-17 : 09:33:26

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 advance for any input

Alain

alaniel
Starting Member

3 Posts

Posted - 2005-06-17 : 09:42:39

I have this information 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)
---------------------------------------------------------------------------------------------------------------

alaniel
Starting Member

3 Posts

Posted - 2005-06-17 : 10:14:09

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources