|
|
You're in the
sql server replication
group:conflict viewer error in sync manager
sql server replication:
I've got a clean install (in the following order) on a brand new Tablet PC:
1) Windows XP Pro SP1 + latest security patches (Version 5.1 - Build 2600.xpsp2.030422-1633: Service Pack 1) 2) Office XP with SP3 (all components, including Access) 3) MSDE 2000 SP3a (clean install from latest kit) The MSDE is setup as a default instance with integrated security (i.e. installed using SETUP SAPWD="xxxx"). On our network, we have SQL Server 2000 Enterprise SP3. I setup a test publication of the Northwind database on this server using merge replication supporting pull subscriptions and allowing interactive conflict resolution. I then setup a pull subscription on the Tablet PC using the Windows Sync manager. The subscription shows up in the list and I can synchronize with the publisher successfully. I also setup the option to allow interactive conflict resolution. However, when I changed some data on the subscriber and publisher to instigate a conflict, I get the following error when I synchronize: "The process failed to get information about the Interactive Resolver Component from the registry." Some detailed information from the Replication Monitor on the publisher looks like this: "The process failed to get information about the Interactive Resolver Component from the registry. (Source: Merge Process (Agent); Error number: -2147198712)" On the Tablet PC (the subscriber), I found the replication conflict viewer at c:\Program files\common files\microsoft shared\database replication\wzcnflct.exe. If I run this manually, I can connect to the publisher and see the conflicts as well as resolve them. So, I know the tool works. The problem seems to lie in the windows sync manager being unable to find this file to run it. I can't figure out why. Can anyone please help? Thanks so much Jim
Paul,
The only file in that folder is wzcnflct.exe; There are no other files and I verified that I have windows explorer set to show all files (including system and hidden ones). In addition, I did a hard drive search for the .dll and did not find one. Perhaps this is the crux of the issue: does the windows sync mgr require this file? If so, why does either Office XP or MSDE 2000 SP3a not include it? Thanks, Jim [quoted text, click to view] "Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message news:OyY5KvmeEHA.2028@tk2msftngp13.phx.gbl... > Jim, > > can you try going to C:\Program files\Common Files\Microsoft shared\database > replication > and issue a regsvr32 wzcnf.dll ? > > HTH, > > Paul Ibison > > >
Hmmm...
The MSDE kit already included the SP3a bits and there were no errors in any logs (I did not have to install the SP separately). I'd be happy to try copying/installing the dll. Where would I get the .dll from if it's not included in the Office XP or MSDE kits? Thanks so much for your assistance, Jim [quoted text, click to view] "Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message news:O3%239tMneEHA.3984@TK2MSFTNGP10.phx.gbl... > Jim, > I have heard of SP3a creating two conflict viewers before but this is new. > Perhaps the sp3 nstall didn't complete? sqlsp.log usually gives such info. > You could try reapplying sp3a or perhaps just copy the dll to C:\Program > files\Common Files\Microsoft shared\database replication\Conflict Viewer (or > the directory wzcnflct.exe is in) and register it. > HTH, > Paul Ibison > >
Jim,
can you try going to C:\Program files\Common Files\Microsoft shared\database replication and issue a regsvr32 wzcnf.dll ? HTH, Paul Ibison
Jim,
I have heard of SP3a creating two conflict viewers before but this is new. Perhaps the sp3 nstall didn't complete? sqlsp.log usually gives such info. You could try reapplying sp3a or perhaps just copy the dll to C:\Program files\Common Files\Microsoft shared\database replication\Conflict Viewer (or the directory wzcnflct.exe is in) and register it. HTH, Paul Ibison
Ok, I'm getting closer. I copied/registered the dll and the resource file
and the conflict viewer now comes up during synchronization. However, there are two more issues I need to resolve: 1) There are two radio buttons in the upper right-hand corner of the conflict viewer which have a black background and I cannot see any text for the radio buttons (the controls/text in the remainder of the dialog all appear ok). When clicking these, it seems to show either a subset of columns from the conflicting row or all of the columns. But, you cannot read the labels on these controls. It's weird why these are the only two with black backgrounds. 2) The Help button does not work in the conflict viewer. Do you know where the help file is and where it should go? These points may seem nit picky, but I'm deploying this solution to end users and these items are important from a support standpoint. If Microsoft is listening in on this, they need to get this fixed! I wish they would acknowledge the problem. Thanks again! Jim [quoted text, click to view] "Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message news:%238KkznseEHA.3612@TK2MSFTNGP12.phx.gbl... > Jim, > I'd just take it from another box which has SQL Server installed (your SQL > Server 2000 Enterprise SP3 box?), or the SQL Server CD. > Regards, > Paul Ibison > >
the interactive resolver component is a com component which you or another
developer has written to handle conflicts. Can you run this proc in the master database on your publisher and tell me what it returns? sp_enumcustomresolvers -- Hilary Cotter Looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html [quoted text, click to view] "Jim~C" <jdchanATnovusint.com> wrote in message news:esE8CmmeEHA.644@tk2msftngp13.phx.gbl... > I've got a clean install (in the following order) on a brand new Tablet PC: > > 1) Windows XP Pro SP1 + latest security patches (Version 5.1 - Build > 2600.xpsp2.030422-1633: Service Pack 1) > 2) Office XP with SP3 (all components, including Access) > 3) MSDE 2000 SP3a (clean install from latest kit) > > The MSDE is setup as a default instance with integrated security (i.e. > installed using SETUP SAPWD="xxxx"). > > On our network, we have SQL Server 2000 Enterprise SP3. I setup a test > publication of the Northwind database on this server using merge replication > supporting pull subscriptions and allowing interactive conflict resolution. > > I then setup a pull subscription on the Tablet PC using the Windows Sync > manager. The subscription shows up in the list and I can synchronize with > the publisher successfully. > > I also setup the option to allow interactive conflict resolution. However, > when I changed some data on the subscriber and publisher to instigate a > conflict, I get the following error when I synchronize: > > "The process failed to get information about the Interactive Resolver > Component from the registry." > > Some detailed information from the Replication Monitor on the publisher > looks like this: > > "The process failed to get information about the Interactive Resolver > Component from the registry. > (Source: Merge Process (Agent); Error number: -2147198712)" > > On the Tablet PC (the subscriber), I found the replication conflict viewer > at c:\Program files\common files\microsoft shared\database > replication\wzcnflct.exe. > > If I run this manually, I can connect to the publisher and see the conflicts > as well as resolve them. So, I know the tool works. The problem seems to lie > in the windows sync manager being unable to find this file to run it. I > can't figure out why. > > Can anyone please help? > Thanks so much > Jim > >
Hilary,
Following are the results of executing sp_enumcustomresolvers: ----------------------- Microsoft SQLServer Stored Procedure Resolver {08B0B2D6-3FB3-11D3-A4DE-00C04F610189} Microsoft SQL Server Additive Conflict Resolver {08B0B2DB-3FB3-11D3-A4DE-00C04F610189} Microsoft SQL Server Averaging Conflict Resolver {08B0B2DC-3FB3-11D3-A4DE-00C04F610189} Microsoft SQL Server Maximum Conflict Resolver {08B0B2DE-3FB3-11D3-A4DE-00C04F610189} Microsoft SQL Server DATETIME (Later Wins) Conflict Resolver {08B0B2DE-3FB3-11D3-A4DE-00C04F610189} Microsoft SQL Server Priority Column Resolver {08B0B2DE-3FB3-11D3-A4DE-00C04F610189} Microsoft SQL Server Minimum Conflict Resolver {08B0B2DF-3FB3-11D3-A4DE-00C04F610189} Microsoft SQL Server DATETIME (Earlier Wins) Conflict Resolver {08B0B2DF-3FB3-11D3-A4DE-00C04F610189} Microsoft SQL Server Subscriber Always Wins Conflict Resolver {08B0B2E0-3FB3-11D3-A4DE-00C04F610189} Microsoft SQL Server Merge Text Columns Conflict Resolver {08B0B2E1-3FB3-11D3-A4DE-00C04F610189} Microsoft SQL Server Download Only Conflict Resolver {08B0B2DD-3FB3-11D3-A4DE-00C04F610189} Microsoft SQL Server Upload Only Conflict Resolver {08B0B2E2-3FB3-11D3-A4DE-00C04F610189} ----------------------- By the way, I did not specify a particular resolver when I created the publication, so it should be using the default. Thanks for your assistance! Jim [quoted text, click to view] "Hilary Cotter" <hilaryk@att.net> wrote in message news:uU%23SwlueEHA.636@TK2MSFTNGP12.phx.gbl... > the interactive resolver component is a com component which you or another > developer has written to handle conflicts. > > Can you run this proc in the master database on your publisher and tell me > what it returns? > > sp_enumcustomresolvers > > -- > Hilary Cotter > Looking for a book on SQL Server replication? > http://www.nwsu.com/0974973602.html > > > "Jim~C" <jdchanATnovusint.com> wrote in message > news:esE8CmmeEHA.644@tk2msftngp13.phx.gbl... > > I've got a clean install (in the following order) on a brand new Tablet > PC: > > > > 1) Windows XP Pro SP1 + latest security patches (Version 5.1 - Build > > 2600.xpsp2.030422-1633: Service Pack 1) > > 2) Office XP with SP3 (all components, including Access) > > 3) MSDE 2000 SP3a (clean install from latest kit) > > > > The MSDE is setup as a default instance with integrated security (i.e. > > installed using SETUP SAPWD="xxxx"). > > > > On our network, we have SQL Server 2000 Enterprise SP3. I setup a test > > publication of the Northwind database on this server using merge > replication > > supporting pull subscriptions and allowing interactive conflict > resolution. > > > > I then setup a pull subscription on the Tablet PC using the Windows Sync > > manager. The subscription shows up in the list and I can synchronize with > > the publisher successfully. > > > > I also setup the option to allow interactive conflict resolution. However, > > when I changed some data on the subscriber and publisher to instigate a > > conflict, I get the following error when I synchronize: > > > > "The process failed to get information about the Interactive Resolver > > Component from the registry." > > > > Some detailed information from the Replication Monitor on the publisher > > looks like this: > > > > "The process failed to get information about the Interactive Resolver > > Component from the registry. > > (Source: Merge Process (Agent); Error number: -2147198712)" > > > > On the Tablet PC (the subscriber), I found the replication conflict viewer > > at c:\Program files\common files\microsoft shared\database > > replication\wzcnflct.exe. > > > > If I run this manually, I can connect to the publisher and see the > conflicts > > as well as resolve them. So, I know the tool works. The problem seems to > lie > > in the windows sync manager being unable to find this file to run it. I > > can't figure out why. > > > > Can anyone please help? > > Thanks so much > > Jim > > > > > >
I already have done this. I know this because I didn't do it at first and I
got NO text on the controls anywhere. After copying the folders/file as you mention, the text showed up. However, the two radio buttons are still showing the behavior I describe and help does not work. This is beginning to scare me a bit. It feels like we're messing with incompatible versions of files now. Yuck. Once again, thanks for your helpful advice. Jim [quoted text, click to view] "Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message news:ugjNqIveEHA.2028@tk2msftngp13.phx.gbl... > Jim, > try adding the resources subdirectory under conflict viewer. In the > resources directory there is a 1033 subdirectory with a resource file in it: > wzcnfrc.rll. If you create exactly the same setup hopefully this'll sort out > the text issues. > HTH, > Paul Ibison > >
Jim,
I'd just take it from another box which has SQL Server installed (your SQL Server 2000 Enterprise SP3 box?), or the SQL Server CD. Regards, Paul Ibison
looks good.
I just want to clarify a few things. The way the interactive resolver is supposed to work is you get some conflict while using WSM. A dialog is generated telling you there was a conflict and to contact your sysadmin. You click on OK (there is no other option) and then it goes away Can you look in this registry key and post back what you see? HKLM\Software\Microsoft\Microsoft SQL Server\80\Replication\Subscriptions\ I am looking for the name of your publication and making sure it looks something like this: Publisher:PublicationDatabase:Publication:Subscriber:SubscriptionDatabase\Us eInteractiveResolver -- Hilary Cotter Looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html [quoted text, click to view] "Jim~C" <jdchanATnovusint.com> wrote in message news:e1rGKJveEHA.2044@TK2MSFTNGP10.phx.gbl... > Hilary, > > Following are the results of executing sp_enumcustomresolvers: > > ----------------------- > Microsoft SQLServer Stored Procedure Resolver > {08B0B2D6-3FB3-11D3-A4DE-00C04F610189} > Microsoft SQL Server Additive Conflict Resolver > {08B0B2DB-3FB3-11D3-A4DE-00C04F610189} > Microsoft SQL Server Averaging Conflict Resolver > {08B0B2DC-3FB3-11D3-A4DE-00C04F610189} > Microsoft SQL Server Maximum Conflict Resolver > {08B0B2DE-3FB3-11D3-A4DE-00C04F610189} > Microsoft SQL Server DATETIME (Later Wins) Conflict Resolver > {08B0B2DE-3FB3-11D3-A4DE-00C04F610189} > Microsoft SQL Server Priority Column Resolver > {08B0B2DE-3FB3-11D3-A4DE-00C04F610189} > Microsoft SQL Server Minimum Conflict Resolver > {08B0B2DF-3FB3-11D3-A4DE-00C04F610189} > Microsoft SQL Server DATETIME (Earlier Wins) Conflict Resolver > {08B0B2DF-3FB3-11D3-A4DE-00C04F610189} > Microsoft SQL Server Subscriber Always Wins Conflict Resolver > {08B0B2E0-3FB3-11D3-A4DE-00C04F610189} > Microsoft SQL Server Merge Text Columns Conflict Resolver > {08B0B2E1-3FB3-11D3-A4DE-00C04F610189} > Microsoft SQL Server Download Only Conflict Resolver > {08B0B2DD-3FB3-11D3-A4DE-00C04F610189} > Microsoft SQL Server Upload Only Conflict Resolver > {08B0B2E2-3FB3-11D3-A4DE-00C04F610189} > ----------------------- > > By the way, I did not specify a particular resolver when I created the > publication, so it should be using the default. > > Thanks for your assistance! > Jim > > "Hilary Cotter" <hilaryk@att.net> wrote in message > news:uU%23SwlueEHA.636@TK2MSFTNGP12.phx.gbl... > > the interactive resolver component is a com component which you or another > > developer has written to handle conflicts. > > > > Can you run this proc in the master database on your publisher and tell me > > what it returns? > > > > sp_enumcustomresolvers > > > > -- > > Hilary Cotter > > Looking for a book on SQL Server replication? > > http://www.nwsu.com/0974973602.html > > > > > > "Jim~C" <jdchanATnovusint.com> wrote in message > > news:esE8CmmeEHA.644@tk2msftngp13.phx.gbl... > > > I've got a clean install (in the following order) on a brand new Tablet > > PC: > > > > > > 1) Windows XP Pro SP1 + latest security patches (Version 5.1 - Build > > > 2600.xpsp2.030422-1633: Service Pack 1) > > > 2) Office XP with SP3 (all components, including Access) > > > 3) MSDE 2000 SP3a (clean install from latest kit) > > > > > > The MSDE is setup as a default instance with integrated security (i.e. > > > installed using SETUP SAPWD="xxxx"). > > > > > > On our network, we have SQL Server 2000 Enterprise SP3. I setup a test > > > publication of the Northwind database on this server using merge > > replication > > > supporting pull subscriptions and allowing interactive conflict > > resolution. > > > > > > I then setup a pull subscription on the Tablet PC using the Windows Sync > > > manager. The subscription shows up in the list and I can synchronize > with > > > the publisher successfully. > > > > > > I also setup the option to allow interactive conflict resolution. > However, > > > when I changed some data on the subscriber and publisher to instigate a > > > conflict, I get the following error when I synchronize: > > > > > > "The process failed to get information about the Interactive Resolver > > > Component from the registry." > > > > > > Some detailed information from the Replication Monitor on the publisher > > > looks like this: > > > > > > "The process failed to get information about the Interactive Resolver > > > Component from the registry. > > > (Source: Merge Process (Agent); Error number: -2147198712)" > > > > > > On the Tablet PC (the subscriber), I found the replication conflict > viewer > > > at c:\Program files\common files\microsoft shared\database > > > replication\wzcnflct.exe. > > > > > > If I run this manually, I can connect to the publisher and see the > > conflicts > > > as well as resolve them. So, I know the tool works. The problem seems to > > lie > > > in the windows sync manager being unable to find this file to run it. I > > > can't figure out why. > > > > > > Can anyone please help? > > > Thanks so much > > > Jim > > > > > > > > > > > >
Hilary,
The key you mention looks like this: ebizdb:NWRepl:NWRepl:stltough01:Northwind Which looks ok to me. There's a subkey (among others) with the name UseInteractiveResolver, REG_DWORD, with a value of 1 (which I assume means that interactive resolution is enabled). And, indeed the interactive resolver starts now, Cheers, Jim [quoted text, click to view] "Hilary Cotter" <hilaryk@att.net> wrote in message news:%23%23ft2jveEHA.3792@TK2MSFTNGP09.phx.gbl... > looks good. > > I just want to clarify a few things. The way the interactive resolver is > supposed to work is you get some conflict while using WSM. > > A dialog is generated telling you there was a conflict and to contact your > sysadmin. > > You click on OK (there is no other option) and then it goes away > > Can you look in this registry key and post back what you see? > > HKLM\Software\Microsoft\Microsoft SQL Server\80\Replication\Subscriptions\ > > I am looking for the name of your publication and making sure it looks > something like this: > > Publisher:PublicationDatabase:Publication:Subscriber:SubscriptionDatabase\Us > eInteractiveResolver > > -- > Hilary Cotter > Looking for a book on SQL Server replication? > http://www.nwsu.com/0974973602.html > > > "Jim~C" <jdchanATnovusint.com> wrote in message > news:e1rGKJveEHA.2044@TK2MSFTNGP10.phx.gbl... > > Hilary, > > > > Following are the results of executing sp_enumcustomresolvers: > > > > ----------------------- > > Microsoft SQLServer Stored Procedure Resolver > > {08B0B2D6-3FB3-11D3-A4DE-00C04F610189} > > Microsoft SQL Server Additive Conflict Resolver > > {08B0B2DB-3FB3-11D3-A4DE-00C04F610189} > > Microsoft SQL Server Averaging Conflict Resolver > > {08B0B2DC-3FB3-11D3-A4DE-00C04F610189} > > Microsoft SQL Server Maximum Conflict Resolver > > {08B0B2DE-3FB3-11D3-A4DE-00C04F610189} > > Microsoft SQL Server DATETIME (Later Wins) Conflict Resolver > > {08B0B2DE-3FB3-11D3-A4DE-00C04F610189} > > Microsoft SQL Server Priority Column Resolver > > {08B0B2DE-3FB3-11D3-A4DE-00C04F610189} > > Microsoft SQL Server Minimum Conflict Resolver > > {08B0B2DF-3FB3-11D3-A4DE-00C04F610189} > > Microsoft SQL Server DATETIME (Earlier Wins) Conflict Resolver > > {08B0B2DF-3FB3-11D3-A4DE-00C04F610189} > > Microsoft SQL Server Subscriber Always Wins Conflict Resolver > > {08B0B2E0-3FB3-11D3-A4DE-00C04F610189} > > Microsoft SQL Server Merge Text Columns Conflict Resolver > > {08B0B2E1-3FB3-11D3-A4DE-00C04F610189} > > Microsoft SQL Server Download Only Conflict Resolver > > {08B0B2DD-3FB3-11D3-A4DE-00C04F610189} > > Microsoft SQL Server Upload Only Conflict Resolver > > {08B0B2E2-3FB3-11D3-A4DE-00C04F610189} > > ----------------------- > > > > By the way, I did not specify a particular resolver when I created the > > publication, so it should be using the default. > > > > Thanks for your assistance! > > Jim > > > > "Hilary Cotter" <hilaryk@att.net> wrote in message > > news:uU%23SwlueEHA.636@TK2MSFTNGP12.phx.gbl... > > > the interactive resolver component is a com component which you or > another > > > developer has written to handle conflicts. > > > > > > Can you run this proc in the master database on your publisher and tell > me > > > what it returns? > > > > > > sp_enumcustomresolvers > > > > > > -- > > > Hilary Cotter > > > Looking for a book on SQL Server replication? > > > http://www.nwsu.com/0974973602.html > > > > > > > > > "Jim~C" <jdchanATnovusint.com> wrote in message > > > news:esE8CmmeEHA.644@tk2msftngp13.phx.gbl... > > > > I've got a clean install (in the following order) on a brand new > Tablet > > > PC: > > > > > > > > 1) Windows XP Pro SP1 + latest security patches (Version 5.1 - Build > > > > 2600.xpsp2.030422-1633: Service Pack 1) > > > > 2) Office XP with SP3 (all components, including Access) > > > > 3) MSDE 2000 SP3a (clean install from latest kit) > > > > > > > > The MSDE is setup as a default instance with integrated security (i.e. > > > > installed using SETUP SAPWD="xxxx"). > > > > > > > > On our network, we have SQL Server 2000 Enterprise SP3. I setup a test > > > > publication of the Northwind database on this server using merge > > > replication > > > > supporting pull subscriptions and allowing interactive conflict > > > resolution. > > > > > > > > I then setup a pull subscription on the Tablet PC using the Windows > Sync > > > > manager. The subscription shows up in the list and I can synchronize > > with > > > > the publisher successfully. > > > > > > > > I also setup the option to allow interactive conflict resolution. > > However, > > > > when I changed some data on the subscriber and publisher to instigate > a > > > > conflict, I get the following error when I synchronize: > > > > > > > > "The process failed to get information about the Interactive Resolver > > > > Component from the registry." > > > > > > > > Some detailed information from the Replication Monitor on the > publisher > > > > looks like this: > > > > > > > > "The process failed to get information about the Interactive Resolver > > > > Component from the registry. > > > > (Source: Merge Process (Agent); Error number: -2147198712)" > > > > > > > > On the Tablet PC (the subscriber), I found the replication conflict > > viewer > > > > at c:\Program files\common files\microsoft shared\database > > > > replication\wzcnflct.exe. > > > > > > > > If I run this manually, I can connect to the publisher and see the > > > conflicts > > > > as well as resolve them. So, I know the tool works. The problem seems > to > > > lie > > > > in the windows sync manager being unable to find this file to run it. > I > > > > can't figure out why. > > > > > > > > Can anyone please help? > > > > Thanks so much > > > > Jim > > > > > > > > > > > > > > > > > > > >
strange - i have a value of 0 for this key. Your value is 1, and it is
working now? -- Hilary Cotter Looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html [quoted text, click to view] "Jim~C" <jdchanATnovusint.com> wrote in message news:%239hDacweEHA.4068@TK2MSFTNGP11.phx.gbl... > Hilary, > > The key you mention looks like this: > > ebizdb:NWRepl:NWRepl:stltough01:Northwind > > Which looks ok to me. There's a subkey (among others) with the name > UseInteractiveResolver, REG_DWORD, with a value of 1 (which I assume means > that interactive resolution is enabled). And, indeed the interactive > resolver starts now, > > Cheers, > Jim > > "Hilary Cotter" <hilaryk@att.net> wrote in message > news:%23%23ft2jveEHA.3792@TK2MSFTNGP09.phx.gbl... > > looks good. > > > > I just want to clarify a few things. The way the interactive resolver is > > supposed to work is you get some conflict while using WSM. > > > > A dialog is generated telling you there was a conflict and to contact your > > sysadmin. > > > > You click on OK (there is no other option) and then it goes away > > > > Can you look in this registry key and post back what you see? > > > > HKLM\Software\Microsoft\Microsoft SQL Server\80\Replication\Subscriptions\ > > > > I am looking for the name of your publication and making sure it looks > > something like this: > > > > > Publisher:PublicationDatabase:Publication:Subscriber:SubscriptionDatabase\Us > > eInteractiveResolver > > > > -- > > Hilary Cotter > > Looking for a book on SQL Server replication? > > http://www.nwsu.com/0974973602.html > > > > > > "Jim~C" <jdchanATnovusint.com> wrote in message > > news:e1rGKJveEHA.2044@TK2MSFTNGP10.phx.gbl... > > > Hilary, > > > > > > Following are the results of executing sp_enumcustomresolvers: > > > > > > ----------------------- > > > Microsoft SQLServer Stored Procedure Resolver > > > {08B0B2D6-3FB3-11D3-A4DE-00C04F610189} > > > Microsoft SQL Server Additive Conflict Resolver > > > {08B0B2DB-3FB3-11D3-A4DE-00C04F610189} > > > Microsoft SQL Server Averaging Conflict Resolver > > > {08B0B2DC-3FB3-11D3-A4DE-00C04F610189} > > > Microsoft SQL Server Maximum Conflict Resolver > > > {08B0B2DE-3FB3-11D3-A4DE-00C04F610189} > > > Microsoft SQL Server DATETIME (Later Wins) Conflict Resolver > > > {08B0B2DE-3FB3-11D3-A4DE-00C04F610189} > > > Microsoft SQL Server Priority Column Resolver > > > {08B0B2DE-3FB3-11D3-A4DE-00C04F610189} > > > Microsoft SQL Server Minimum Conflict Resolver > > > {08B0B2DF-3FB3-11D3-A4DE-00C04F610189} > > > Microsoft SQL Server DATETIME (Earlier Wins) Conflict Resolver > > > {08B0B2DF-3FB3-11D3-A4DE-00C04F610189} > > > Microsoft SQL Server Subscriber Always Wins Conflict Resolver > > > {08B0B2E0-3FB3-11D3-A4DE-00C04F610189} > > > Microsoft SQL Server Merge Text Columns Conflict Resolver > > > {08B0B2E1-3FB3-11D3-A4DE-00C04F610189} > > > Microsoft SQL Server Download Only Conflict Resolver > > > {08B0B2DD-3FB3-11D3-A4DE-00C04F610189} > > > Microsoft SQL Server Upload Only Conflict Resolver > > > {08B0B2E2-3FB3-11D3-A4DE-00C04F610189} > > > ----------------------- > > > > > > By the way, I did not specify a particular resolver when I created the > > > publication, so it should be using the default. > > > > > > Thanks for your assistance! > > > Jim > > > > > > "Hilary Cotter" <hilaryk@att.net> wrote in message > > > news:uU%23SwlueEHA.636@TK2MSFTNGP12.phx.gbl... > > > > the interactive resolver component is a com component which you or > > another > > > > developer has written to handle conflicts. > > > > > > > > Can you run this proc in the master database on your publisher and > tell > > me > > > > what it returns? > > > > > > > > sp_enumcustomresolvers > > > > > > > > -- > > > > Hilary Cotter > > > > Looking for a book on SQL Server replication? > > > > http://www.nwsu.com/0974973602.html > > > > > > > > > > > > "Jim~C" <jdchanATnovusint.com> wrote in message > > > > news:esE8CmmeEHA.644@tk2msftngp13.phx.gbl... > > > > > I've got a clean install (in the following order) on a brand new > > Tablet > > > > PC: > > > > > > > > > > 1) Windows XP Pro SP1 + latest security patches (Version 5.1 - Build > > > > > 2600.xpsp2.030422-1633: Service Pack 1) > > > > > 2) Office XP with SP3 (all components, including Access) > > > > > 3) MSDE 2000 SP3a (clean install from latest kit) > > > > > > > > > > The MSDE is setup as a default instance with integrated security > (i.e. > > > > > installed using SETUP SAPWD="xxxx"). > > > > > > > > > > On our network, we have SQL Server 2000 Enterprise SP3. I setup a > test > > > > > publication of the Northwind database on this server using merge > > > > replication > > > > > supporting pull subscriptions and allowing interactive conflict > > > > resolution. > > > > > > > > > > I then setup a pull subscription on the Tablet PC using the Windows > > Sync > > > > > manager. The subscription shows up in the list and I can synchronize > > > with > > > > > the publisher successfully. > > > > > > > > > > I also setup the option to allow interactive conflict resolution. > > > However, > > > > > when I changed some data on the subscriber and publisher to > instigate > > a > > > > > conflict, I get the following error when I synchronize: > > > > > > > > > > "The process failed to get information about the Interactive > Resolver > > > > > Component from the registry." > > > > > > > > > > Some detailed information from the Replication Monitor on the > > publisher > > > > > looks like this: > > > > > > > > > > "The process failed to get information about the Interactive > Resolver > > > > > Component from the registry. > > > > > (Source: Merge Process (Agent); Error number: -2147198712)" > > > > > > > > > > On the Tablet PC (the subscriber), I found the replication conflict > > > viewer > > > > > at c:\Program files\common files\microsoft shared\database > > > > > replication\wzcnflct.exe. > > > > > > > > > > If I run this manually, I can connect to the publisher and see the > > > > conflicts > > > > > as well as resolve them. So, I know the tool works. The problem > seems > > to > > > > lie > > > > > in the windows sync manager being unable to find this file to run > it. > > I > > > > > can't figure out why. > > > > > > > > > > Can anyone please help? > > > > > Thanks so much > > > > > Jim > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
Jim,
try adding the resources subdirectory under conflict viewer. In the resources directory there is a 1033 subdirectory with a resource file in it: wzcnfrc.rll. If you create exactly the same setup hopefully this'll sort out the text issues. HTH, Paul Ibison
Do the dll, resource file and exe all have the same version numbers
(right-click, properties, version...)? If not, this could be the issue. If they do, then I'd consider reapplying SP3a. Regards, Paul Ibison
Yes, it is working - but, with the limitations I've mentioned in another
thread of this discussion. Specifically, even though the wzcnf.dll file can find the resource file wzcnf.rll, there are two radio buttons in the upper-right-hand corner of the window which simply show a black background (and, since the forecolor text is black, I can't see what these radio buttons are supposed to be used for). Also, when using the conflict viewer, the help button does not work (it does not find the help file). Thanks for your help, Jim [quoted text, click to view] "Hilary Cotter" <hilaryk@att.net> wrote in message
news:ehxRBRxeEHA.2908@TK2MSFTNGP10.phx.gbl... > strange - i have a value of 0 for this key. Your value is 1, and it is > working now? > > -- > Hilary Cotter > Looking for a book on SQL Server replication? > http://www.nwsu.com/0974973602.html > > > "Jim~C" <jdchanATnovusint.com> wrote in message > news:%239hDacweEHA.4068@TK2MSFTNGP11.phx.gbl... > > Hilary, > > > > The key you mention looks like this: > > > > ebizdb:NWRepl:NWRepl:stltough01:Northwind > > > > Which looks ok to me. There's a subkey (among others) with the name > > UseInteractiveResolver, REG_DWORD, with a value of 1 (which I assume > means > > that interactive resolution is enabled). And, indeed the interactive > > resolver starts now, > > > > Cheers, > > Jim > > > > "Hilary Cotter" <hilaryk@att.net> wrote in message > > news:%23%23ft2jveEHA.3792@TK2MSFTNGP09.phx.gbl... > > > looks good. > > > > > > I just want to clarify a few things. The way the interactive resolver is > > > supposed to work is you get some conflict while using WSM. > > > > > > A dialog is generated telling you there was a conflict and to contact > your > > > sysadmin. > > > > > > You click on OK (there is no other option) and then it goes away > > > > > > Can you look in this registry key and post back what you see? > > > > > > HKLM\Software\Microsoft\Microsoft SQL > Server\80\Replication\Subscriptions\ > > > > > > I am looking for the name of your publication and making sure it looks > > > something like this: > > > > > > > > > Publisher:PublicationDatabase:Publication:Subscriber:SubscriptionDatabase\Us > > > eInteractiveResolver > > > > > > -- > > > Hilary Cotter > > > Looking for a book on SQL Server replication? > > > http://www.nwsu.com/0974973602.html > > > > > > > > > "Jim~C" <jdchanATnovusint.com> wrote in message > > > news:e1rGKJveEHA.2044@TK2MSFTNGP10.phx.gbl... > > > > Hilary, > > > > > > > > Following are the results of executing sp_enumcustomresolvers: > > > > > > > > ----------------------- > > > > Microsoft SQLServer Stored Procedure Resolver > > > > {08B0B2D6-3FB3-11D3-A4DE-00C04F610189} > > > > Microsoft SQL Server Additive Conflict Resolver > > > > {08B0B2DB-3FB3-11D3-A4DE-00C04F610189} > > > > Microsoft SQL Server Averaging Conflict Resolver > > > > {08B0B2DC-3FB3-11D3-A4DE-00C04F610189} > > > > Microsoft SQL Server Maximum Conflict Resolver > > > > {08B0B2DE-3FB3-11D3-A4DE-00C04F610189} > > > > Microsoft SQL Server DATETIME (Later Wins) Conflict Resolver > > > > {08B0B2DE-3FB3-11D3-A4DE-00C04F610189} > > > > Microsoft SQL Server Priority Column Resolver > > > > {08B0B2DE-3FB3-11D3-A4DE-00C04F610189} > > > > Microsoft SQL Server Minimum Conflict Resolver > > > > {08B0B2DF-3FB3-11D3-A4DE-00C04F610189} > > > > Microsoft SQL Server DATETIME (Earlier Wins) Conflict Resolver > > > > {08B0B2DF-3FB3-11D3-A4DE-00C04F610189} > > > > Microsoft SQL Server Subscriber Always Wins Conflict Resolver > > > > {08B0B2E0-3FB3-11D3-A4DE-00C04F610189} > > > > Microsoft SQL Server Merge Text Columns Conflict Resolver > > > > {08B0B2E1-3FB3-11D3-A4DE-00C04F610189} > > > > Microsoft SQL Server Download Only Conflict Resolver > > > > {08B0B2DD-3FB3-11D3-A4DE-00C04F610189} > > > > Microsoft SQL Server Upload Only Conflict Resolver > > > > {08B0B2E2-3FB3-11D3-A4DE-00C04F610189} > > > > ----------------------- > > > > > > > > By the way, I did not specify a particular resolver when I created the > > > > publication, so it should be using the default. > > > > > > > > Thanks for your assistance! > > > > Jim > > > > > > > > "Hilary Cotter" <hilaryk@att.net> wrote in message > > > > news:uU%23SwlueEHA.636@TK2MSFTNGP12.phx.gbl... > > > > > the interactive resolver component is a com component which you or > > > another > > > > > developer has written to handle conflicts. > > > > > > > > > > Can you run this proc in the master database on your publisher and > > tell > > > me > > > > > what it returns? > > > > > > > > > > sp_enumcustomresolvers > > > > > > > > > > -- > > > > > Hilary Cotter > > > > > Looking for a book on SQL Server replication? > > > > > http://www.nwsu.com/0974973602.html > > > > > > > > > > > > > > > "Jim~C" <jdchanATnovusint.com> wrote in message > > > > > news:esE8CmmeEHA.644@tk2msftngp13.phx.gbl... > > > > > > I've got a clean install (in the following order) on a brand new > > > Tablet > > > > > PC: > > > > > > > > > > > > 1) Windows XP Pro SP1 + latest security patches (Version 5.1 - > Build > > > > > > 2600.xpsp2.030422-1633: Service Pack 1) > > > > > > 2) Office XP with SP3 (all components, including Access) > > > > > > 3) MSDE 2000 SP3a (clean install from latest kit) > > > > > > > > > > > > The MSDE is setup as a default instance with integrated security > > (i.e. > > > > > > installed using SETUP SAPWD="xxxx"). > > > > > > > > > > > > On our network, we have SQL Server 2000 Enterprise SP3. I setup a > > test > > > > > > publication of the Northwind database on this server using merge > > > > > replication > > > > > > supporting pull subscriptions and allowing interactive conflict > > > > > resolution. > > > > > > > > > > > > I then setup a pull subscription on the Tablet PC using the > Windows > > > Sync > > > > > > manager. The subscription shows up in the list and I can > synchronize > > > > with > > > > > > the publisher successfully. > > > > > > > > > > > > I also setup the option to allow interactive conflict resolution. > > > > However, > > > > > > when I changed some data on the subscriber and publisher to > > instigate > > > a > > > > > > conflict, I get the following error when I synchronize: > > > > > > > > > > > > "The process failed to get information about the Interactive > > Resolver > > > > > > Component from the registry." > > > > > > > > > > > > Some detailed information from the Replication Monitor on the > > > publisher > > > > > > looks like this: > > > > > > > > > > > > "The process failed to get information about the Interactive > > Resolver > > > > > > Component from the registry. > > > > > > (Source: Merge Process (Agent); Error number: -2147198712)" > > > > > > > > > > > > On the Tablet PC (the subscriber), I found the replication > conflict > > > > viewer > > > > > > at c:\Program files\common files\microsoft shared\database
as Paul has suggested you have some versioning problems. Did you register
your rll? ie C:\Program Files\Common Files\Microsoft Shared\Database Replication\Resources\1033\regsvr32 wzcnfrc.rll -- Hilary Cotter Looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html [quoted text, click to view] "Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message news:OAYapcveEHA.3376@TK2MSFTNGP10.phx.gbl... > Do the dll, resource file and exe all have the same version numbers > (right-click, properties, version...)? > If not, this could be the issue. > If they do, then I'd consider reapplying SP3a. > > Regards, > > Paul Ibison > > >
Don't see what you're looking for? Try a search.
|
April 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |