Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
selectedRow Exception - using Sync Framework with 2 Oracle DB RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi.

    I am starting to explore Microsoft Sync Framework to use it to synchronize Oracle Dbs.

    So, I have downloaded the sample for Oracle and SQL CE

     http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=3761

     and changed it to sync 2 Oracle databases.

    When I am making insert-insert conflict, by inserting items with identical Ids, and then sychronize, I receive exception:

    Microsoft.Synchronization.Data.DbSyncException: Cannot find a value to set for command parameter 'selectedRow'. Ensure that the schemas of the tables being synchronized are consistent, and that the configuration for this scope is correct.

    Also, this acception appears on delete-delete conflict, I don't know, maybe anywhere else.

    ApplyChangeFailed event of the Provider is not triggered, programm throws this exception when Synchronize method of the Orchestrator is called.

    Also, original sample project (for SQL CE and Oracle) is also throwing that exception on insert-insert conflict.

    I think there is problem with SelectRowCommand of the adapter, but just can't figure it out. Provider just refuses to solve conflicts.

    Any help on the issue?

    Wednesday, October 6, 2010 6:51 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    The SelectRowCommand is fired before raising the ApplyChangeFailed event. It's used to retrieve the conflicting row on the destination so it can be accessed in the ApplyChangeFailed event together with the source row.

    have you tried manually running the query in sp_xxx_selectrow if its returning a value?

     

    Wednesday, October 6, 2010 3:12 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi OzzyK,

    You said that you have changed the sample for Oracle and SQL CE --> to sync 2 Oracle DB

    Can you please share how did you do that.

    Hoping for a positive response.

    Thanks and Regards.

    Tuesday, March 26, 2013 4:36 AM