Merge Replication with Dynamic Filter and Row Filter failure on two Deletes 
Author Message
 Merge Replication with Dynamic Filter and Row Filter failure on two Deletes

SQL 2k, SP2, Developer Edition, on Distributor
SQL 2k, SP2, Standard Edition, on Subscriber

Well, I'm trying Merge Replication, with 4 Tables and 4 Articles on these Tables

T1
   (LAPTOPID, TYPE, CODE)
T2
   (REP, NAME)
T3
   (CUSTID, REP , STREET)
T4
   (CUSTID, NAME , SURNAME)

bold : PK

Dynamic Filter :
   T1.LAPTOPID = HOST_NAME()

Row Filters :
   T1.CODE = T2.REP (many to one)
   T2.REP = T3.REP (one to many)
   T3.CUSTID = T4.CUSTID (many to one)

When I delete one row from T3, then Replication remove's (delete's) from subscriber the row of CUSTID.
When I delete two rows from T3,
if Synchronize is within Enterprise manager, I have a timeout from the Distributor or if I use
the Synchronize manager , it will fail with an error report :
Error signature

AppName: mobsync.exe  AppVer: 5.1.2600.0  ModName: replprov.dll
ModVer: 2000.80.194.0  Offset: 00025537

<?xml version="1.0" encoding="UTF-16"?>
<DATABASE>
<EXE NAME="SYSTEM INFO" FILTER="GRABMI_FILTER_SYSTEM">
    <MATCHING_FILE NAME="advapi32.dll" SIZE="549888" CHECKSUM="0x4F484D70" BIN_FILE_VERSION="5.1.2600.0" BIN_PRODUCT_VERSION="5.1.2600.0" PRODUCT_VERSION="5.1.2600.0" FILE_DESCRIPTION="Advanced Windows 32 Base API" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="MicrosoftR WindowsR Operating System" FILE_VERSION="5.1.2600.0 (XPClient.010817-1148)" ORIGINAL_FILENAME="advapi32.dll" INTERNAL_NAME="advapi32.dll" LEGAL_COPYRIGHT="? Microsoft Corporation. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0x8F9C5" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="5.1.2600.0" UPTO_BIN_PRODUCT_VERSION="5.1.2600.0" LINK_DATE="08/18/2001 05:33:02" UPTO_LINK_DATE="08/18/2001 05:33:02" VER_LANGUAGE="English (United States) [0x409]" />
    <MATCHING_FILE NAME="gdi32.dll" SIZE="250880" CHECKSUM="0xB2219B08" BIN_FILE_VERSION="5.1.2600.0" BIN_PRODUCT_VERSION="5.1.2600.0" PRODUCT_VERSION="5.1.2600.0" FILE_DESCRIPTION="GDI Client DLL" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="MicrosoftR WindowsR Operating System" FILE_VERSION="5.1.2600.0 (xpclient.010817-1148)" ORIGINAL_FILENAME="gdi32" INTERNAL_NAME="gdi32" LEGAL_COPYRIGHT="? Microsoft Corporation. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0x46F5D" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="5.1.2600.0" UPTO_BIN_PRODUCT_VERSION="5.1.2600.0" LINK_DATE="08/18/2001 05:33:02" UPTO_LINK_DATE="08/18/2001 05:33:02" VER_LANGUAGE="English (United States) [0x409]" />
    <MATCHING_FILE NAME="kernel32.dll" SIZE="926720" CHECKSUM="0x6262EEA5" BIN_FILE_VERSION="5.1.2600.0" BIN_PRODUCT_VERSION="5.1.2600.0" PRODUCT_VERSION="5.1.2600.0" FILE_DESCRIPTION="Windows NT BASE API Client DLL" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="MicrosoftR WindowsR Operating System" FILE_VERSION="5.1.2600.0 (xpclient.010817-1148)" ORIGINAL_FILENAME="kernel32" INTERNAL_NAME="kernel32" LEGAL_COPYRIGHT="? Microsoft Corporation. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0xE8792" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="5.1.2600.0" UPTO_BIN_PRODUCT_VERSION="5.1.2600.0" LINK_DATE="08/18/2001 05:33:02" UPTO_LINK_DATE="08/18/2001 05:33:02" VER_LANGUAGE="English (United States) [0x409]" />
    <MATCHING_FILE NAME="ntdll.dll" SIZE="674304" CHECKSUM="0x7BB0D38F" BIN_FILE_VERSION="5.1.2600.0" BIN_PRODUCT_VERSION="5.1.2600.0" PRODUCT_VERSION="5.1.2600.0" FILE_DESCRIPTION="NT Layer DLL" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="MicrosoftR WindowsR Operating System" FILE_VERSION="5.1.2600.0 (xpclient.010817-1148)" ORIGINAL_FILENAME="ntdll.dll" INTERNAL_NAME="ntdll.dll" LEGAL_COPYRIGHT="? Microsoft Corporation. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0xA8C88" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="5.1.2600.0" UPTO_BIN_PRODUCT_VERSION="5.1.2600.0" LINK_DATE="08/18/2001 03:25:18" UPTO_LINK_DATE="08/18/2001 03:25:18" VER_LANGUAGE="English (United States) [0x409]" />
    <MATCHING_FILE NAME="ole32.dll" SIZE="1141248" CHECKSUM="0xCD298B1B" BIN_FILE_VERSION="5.1.2600.0" BIN_PRODUCT_VERSION="5.1.2600.0" PRODUCT_VERSION="5.1.2600.0" FILE_DESCRIPTION="Microsoft OLE for Windows" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="MicrosoftR WindowsR Operating System" FILE_VERSION="5.1.2600.0 (XPClient.010817-1148)" ORIGINAL_FILENAME="OLE32.DLL" INTERNAL_NAME="OLE32.DLL" LEGAL_COPYRIGHT="? Microsoft Corporation. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0x119CA3" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="5.1.2600.0" UPTO_BIN_PRODUCT_VERSION="5.1.2600.0" LINK_DATE="08/18/2001 05:33:04" UPTO_LINK_DATE="08/18/2001 05:33:04" VER_LANGUAGE="English (United States) [0x409]" />
    <MATCHING_FILE NAME="oleaut32.dll" SIZE="569344" CHECKSUM="0x33FCD4B1" BIN_FILE_VERSION="3.50.5014.0" BIN_PRODUCT_VERSION="3.50.5014.0" PRODUCT_VERSION="3.50.5014.0" FILE_DESCRIPTION="Microsoft OLE 3.50  for Windows NT(TM) and Windows 95(TM) Operating Systems" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="Microsoft OLE 3.50  for Windows NT(TM) and Windows 95(TM) Operating Systems" FILE_VERSION="3.50.5014.0" INTERNAL_NAME="OLEAUT32.DLL" LEGAL_COPYRIGHT="Copyright ? Microsoft Corp. 1993-1999." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0x9AC05" LINKER_VERSION="0x0" UPTO_BIN_FILE_VERSION="3.50.5014.0" UPTO_BIN_PRODUCT_VERSION="3.50.5014.0" LINK_DATE="08/18/2001 05:33:04" UPTO_LINK_DATE="08/18/2001 05:33:04" VER_LANGUAGE="English (United States) [0x409]" />
    <MATCHING_FILE NAME="shell32.dll" SIZE="8322560" CHECKSUM="0xF1BE79DC" BIN_FILE_VERSION="6.0.2600.0" BIN_PRODUCT_VERSION="6.0.2600.0" PRODUCT_VERSION="6.00.2600.0000" FILE_DESCRIPTION="Windows Shell Common Dll" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="MicrosoftR WindowsR Operating System" FILE_VERSION="6.00.2600.0000 (xpclient.010817-1148)" ORIGINAL_FILENAME="SHELL32.DLL" INTERNAL_NAME="SHELL32" LEGAL_COPYRIGHT="? Microsoft Corporation. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0x7F1F00" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="6.0.2600.0" UPTO_BIN_PRODUCT_VERSION="6.0.2600.0" LINK_DATE="08/18/2001 05:33:03" UPTO_LINK_DATE="08/18/2001 05:33:03" VER_LANGUAGE="English (United States) [0x409]" />
    <MATCHING_FILE NAME="user32.dll" SIZE="561152" CHECKSUM="0xD8F46CFA" BIN_FILE_VERSION="5.1.2600.0" BIN_PRODUCT_VERSION="5.1.2600.0" PRODUCT_VERSION="5.1.2600.0" FILE_DESCRIPTION="Windows XP USER API Client DLL" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="MicrosoftR WindowsR Operating System" FILE_VERSION="5.1.2600.0 (xpclient.010817-1148)" ORIGINAL_FILENAME="user32" INTERNAL_NAME="user32" LEGAL_COPYRIGHT="? Microsoft Corporation. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0x93F1D" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="5.1.2600.0" UPTO_BIN_PRODUCT_VERSION="5.1.2600.0" LINK_DATE="08/18/2001 05:33:02" UPTO_LINK_DATE="08/18/2001 05:33:02" VER_LANGUAGE="English (United States) [0x409]" />
    <MATCHING_FILE NAME="wininet.dll" SIZE="582656" CHECKSUM="0x877785C2" BIN_FILE_VERSION="6.0.2715.400" BIN_PRODUCT_VERSION="6.0.2715.400" PRODUCT_VERSION="6.00.2715.400" FILE_DESCRIPTION="Internet Extensions for Win32" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="MicrosoftR WindowsR Operating System" FILE_VERSION="6.00.2715.400" ORIGINAL_FILENAME="wininet.dll" INTERNAL_NAME="wininet.dll" LEGAL_COPYRIGHT="? Microsoft Corporation. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0x90C84" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="6.0.2715.400" UPTO_BIN_PRODUCT_VERSION="6.0.2715.400" LINK_DATE="03/05/2002 16:56:26" UPTO_LINK_DATE="03/05/2002 16:56:26" VER_LANGUAGE="English (United States) [0x409]" />
    <MATCHING_FILE NAME="winsock.dll" SIZE="2864" CHECKSUM="0x73AE8088" BIN_FILE_VERSION="3.10.0.103" BIN_PRODUCT_VERSION="3.10.0.103" PRODUCT_VERSION="3.10" FILE_DESCRIPTION="Windows Socket 16-Bit DLL" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="MicrosoftR Windows(TM) Operating System" FILE_VERSION="3.10" ORIGINAL_FILENAME="WINSOCK.DLL" INTERNAL_NAME="WINSOCK" LEGAL_COPYRIGHT="Copyright ? Microsoft Corp. 1981-1996" VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x10001" VERFILETYPE="0x2" MODULE_TYPE="WIN16" S16BIT_DESCRIPTION="BSD Socket API for Windows" S16BIT_MODULE_NAME="WINSOCK" UPTO_BIN_FILE_VERSION="3.10.0.103" UPTO_BIN_PRODUCT_VERSION="3.10.0.103" VER_LANGUAGE="English (United States) [0x409]" />
</EXE>
<EXE NAME="replprov.dll" FILTER="GRABMI_FILTER_THISFILEONLY">
    <MATCHING_FILE NAME="replprov.dll" SIZE="204873" CHECKSUM="0xBBC9B71" BIN_FILE_VERSION="2000.80.194.0" BIN_PRODUCT_VERSION="8.0.1.94" PRODUCT_VERSION="8.00.194" FILE_DESCRIPTION="SQL Server Replication Merge Provider" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="Microsoft SQL Server" FILE_VERSION="2000.080.0194.00" ORIGINAL_FILENAME="REPLPROV.DLL" INTERNAL_NAME="REPLPROV" LEGAL_COPYRIGHT="? 1988-2000 Microsoft Corp. All rights reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x1" VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0x39369" LINKER_VERSION="0x0" UPTO_BIN_FILE_VERSION="2000.80.194.0" UPTO_BIN_PRODUCT_VERSION="8.0.1.94" LINK_DATE="08/06/2000 08:50:27" UPTO_LINK_DATE="08/06/2000 08:50:27" VER_LANGUAGE="English (United States) [0x409]" />
</EXE>
</DATABASE>



Sun, 12 Dec 2004 19:03:11 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Problem with filters and join filters in merge replication

2. Merge replication with dynamic filters

3. merge replication and dynamic filter

4. Merge replication with dynamic filters question

5. problem with dynamic filters in merge replication

6. Dynamic filter for merge replication question ?

7. Dynamic Filters Merge replication

8. joined dynamic filters VS dynamic filters [mergerepl]

9. dynamic filter in merge replication

10. Dynamic filtering in merge replication

11. Dynamic Filter in Merge Replication

12. Initial sync using a dynamic filtered merge replication


 
Powered by phpBB® Forum Software