locked
"No key matching the described characteristics could be found within the current range." Error RRS feed

  • Question

  • I am using the SqlSyncProvider and SqlCeSyncProvider providers to synchronise a SQL Server 2008 and a SQL Server Compact 3.5 database. I have two tables with a foreign key constraint between them. The following error is being reported in the ApplyChangeFailed event on the SqlCeSyncProvider.

    "No key matching the described characteristics could be found within the current range."

    I found this hotfix which looked very promising.

    http://support.microsoft.com/kb/974068

    When I tried to install it though, the following message was displayed and the installation process ended.

    "A later version of Microsoft SQL Server Compact is already installed."

    I used the instructions here and found that the version that I have installed is 3.5.5692.0.

    http://support.microsoft.com/kb/950550

    The hotfix should be installing version 3.5.5692.14 which is greater. Why am I not able to install the hotfix?

    Is there anything else that I can try to prevent the error in the title of this question from occurring?

    Many thanks,

    Scott
    MCSD.Net
    • Moved by Max Wang_1983 Thursday, April 21, 2011 10:25 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Sunday, December 6, 2009 12:11 PM

Answers

  • Hi Scott,

    As you noted, this is a known issue which the Hotfix fixes.
    I am not sure why the upgrade is not working.
    However as a workaround, you could try the following:

    1. Uninstall the current 5692 bits on your machine.
    2. Install the Hotfix build 5692.14

    Hope that helps.
    This posting is provided AS IS with no warranties, and confers no rights
    • Marked as answer by Scott Munro Sunday, December 6, 2009 9:54 PM
    Sunday, December 6, 2009 6:30 PM

All replies

  • Hi Scott,

    As you noted, this is a known issue which the Hotfix fixes.
    I am not sure why the upgrade is not working.
    However as a workaround, you could try the following:

    1. Uninstall the current 5692 bits on your machine.
    2. Install the Hotfix build 5692.14

    Hope that helps.
    This posting is provided AS IS with no warranties, and confers no rights
    • Marked as answer by Scott Munro Sunday, December 6, 2009 9:54 PM
    Sunday, December 6, 2009 6:30 PM
  • Thanks Mahesh!

    I uninstalled the 5692 (and a number of older versions) and was then able to install the hotfix without any problems.

    I have not had a chance to confirm that the hotfix stops the error that I was getting... but I am pretty confident.

    Update: This solved the problem.

    Cheers,

    Scott
    MCSD.Net
    Sunday, December 6, 2009 9:57 PM