locked
"Table name 'sometable' is not valid" RRS feed

  • Question

  • This journey has taken too long.

    Big picture: trying to set up a sync between a local sqlexpress  and a remote sql2005 box.  For dev, I'm running 2 sqlexpress instances locally.  All errors refer to the dev situation - as I can't get any further.

    After a series of trials, tribulations, and errors described in varying detail by those who've gone before me, I've come upon one I can find no references on.  When I Synchronize() I get:

    "Table name 'tblSWVendor' is not valid. This might be caused by one or more of the following issues:  unable to find a SyncAdapter for the specified SyncTable; the table name is null or empty; or the table name contains the keywords SET, FMTONLY, and OFF."

    Stack trace:
       at Microsoft.Synchronization.Data.Server.DbServerSyncProvider.PrepareForApplyingToTable(ApplyChangeType act, DataSet dataSet, SyncTableMetadata tableMetadata, IDbTransaction transaction, SyncAdapter& adapter, IDbCommand& cmd, DataTable& dataTable, DataColumnCollection& columns, SyncTableProgress& tableProgress)
       at Microsoft.Synchronization.Data.Server.DbServerSyncProvider.ApplyChangesInternal(SyncGroupMetadata groupMetadata, DataSet dataSet, SyncSession syncSession, IDbTransaction transaction, ApplyChangeType changeType)
       at Microsoft.Synchronization.Data.Server.DbServerSyncProvider.ApplyChanges(SyncGroupMetadata groupMetadata, DataSet dataSet, SyncSession syncSession)
       at Microsoft.Samples.Synchronization.Data.SqlExpress.SqlExpressClientSyncProvider.ApplyChanges(SyncGroupMetadata groupMetadata, DataSet dataSet, SyncSession syncSession) in C:\SourceCode\OSRSync\Synchronizer\SqlExpressClientSyncProvider.cs:line 393
       at Microsoft.Synchronization.SyncAgent.DownloadChanges(SyncGroupMetadata groupMetadata)
       at Microsoft.Synchronization.SyncAgent.DataSynchronize()
       at Microsoft.Synchronization.SyncAgent.Synchronize()
       at PrudentRX.OSR.Synchronizer..ctor() in C:\SourceCode\OSRSync\Synchronizer\Synchronizer.cs:line 112
       at PrudentRX.Sync.OSR.OSRSyncUI.button1_Click(Object sender, EventArgs e) in C:\SourceCode\OSRSync\OSRSyncUI\OSRSyncUI.cs:line 26
       at System.Windows.Forms.Control.OnClick(EventArgs e)
       at System.Windows.Forms.Button.OnClick(EventArgs e)
       at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
       at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
       at System.Windows.Forms.Control.WndProc(Message& m)
       at System.Windows.Forms.ButtonBase.WndProc(Message& m)
       at System.Windows.Forms.Button.WndProc(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
       at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
       at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
       at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
       at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
       at System.Windows.Forms.Application.Run(Form mainForm)
       at PrudentRX.OSR.SyncUI.Program.Main() in C:\SourceCode\OSRSync\OSRSyncUI\Program.cs:line 18
       at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)
       at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
       at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
       at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       at System.Threading.ThreadHelper.ThreadStart()

    tblSWVendor exists in both the local and remote db.  The table name obviously does not contain SET, FMTONLY, or OFF (or does it?  going nuts....).  

    The error is thrown at this line in the SqlExpressClientSyncProvider that's been appropriately hacked up based on some MSFT and independent suggestions pointed out elsewhere on these boards:

    SyncContext syncContext = _dbSyncProvider.ApplyChanges(groupMetadata, dataSet, syncSession);

    Using DBServerSyncProvider for the server.  (is there an issue with it working with sqlexpress?)  Adapter is built using SqlSyncAdapterBuilder.  I'm only trying to sync ONE STINKIN' TABLE for dev purposes.

    Help!
    • Moved by Max Wang_1983 Thursday, April 21, 2011 10:58 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Tuesday, September 29, 2009 1:08 AM

Answers

  • There's something wrong with my IDE.  One other project has been behaving strangely.  Basically, changes appear to get undone, files or projects get dropped from a solution, etc.  Bad Keyboard?  Faulty IDE (unlikely)?

    Time for a reinstall.

    PS - It works after I started over on it.....
    • Marked as answer by SaroDude Thursday, October 22, 2009 10:29 PM
    Thursday, October 22, 2009 10:28 PM

All replies

  • Hi SaroDude,

    are you using your own client side sync provider ?

    the exception indicates the tables specified in the syncAdapter and in the syncAgent do not match, can you check them ?

    thanks
    Yunwen


    This posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, September 29, 2009 4:10 AM
    Moderator
  • Yunwen-

    Can you elaborate on what you mean by "do not match"?  The table names are the same (tblSWVendor).  The columns spec'd for IDs and tracking all exist.

    I'm using the SqlExpressClientSyncProvider with the modifications that have been posted elsewhere on these boards.

    Just to get this thing rolling, I started with one table.  Bidirectional.  I'm not sure if this might be an issue but I've only added 2 columns using DataColumns.Add - the PK and a varchar column.

    -Saro
    Tuesday, September 29, 2009 2:44 PM
  • sorry if I didn't make it very clear. internally there is a string comparision with the tableName on the syncAdapter for the table and the tableName with the syncAgent.syncConfigration.SyncTables. can you check for sure the name ( case sensitive ) matches ?

    if they do, a couple more things can be done to nail this one down:
    1. are there any table mapping or 2 or 3 part table name involved here
    2. enable profiler on both sql servers to see what exactly are being executed

    thanks
    Yunwen


    This posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, September 30, 2009 11:38 AM
    Moderator
  • ssabServer.TableName = "tblSWVendor"   <- is a SqlSyncAdapterBuilder
    osrSyncAgent.Configuration.SyncTables[0].TableName = "tblSWVendor"

    They appear to be the same.

    1)  I'm lame.  You'll have to elaborate further!  :^)  If you mean "dbname.schema.tablename" - no.  Just a simple tablename.  
    Table Mapping?  The tables are IDENTICAL.  The client table is created by exporting the server table's script.  I haven't applied any mapping anyplace that I'm aware of - but if you could be more specific, I'll check!

    2)  Sorry 'bout the xml but the other exports were leaving things out.  You'll notice that there's a time gap starting at 12:23:39.  That was intentional on my part.  Everything up until that point is before the Synchronize() call.

    Server:
    <?xml version="1.0" encoding="utf-16"?>
    <TraceData xmlns="http://tempuri.org/TracePersistence.xsd">
      <Header>
        <TraceProvider name="Microsoft SQL Server" MajorVersion="9" MinorVersion="0" BuildNumber="4035" />
        <ServerInformation name="mybox\SQLEXPRESS" />
        <ProfilerUI>
          <OrderedColumns>
            <ID>27</ID>
            <ID>1</ID>
            <ID>10</ID>
            <ID>6</ID>
            <ID>11</ID>
            <ID>18</ID>
            <ID>16</ID>
            <ID>17</ID>
            <ID>13</ID>
            <ID>9</ID>
            <ID>12</ID>
            <ID>14</ID>
            <ID>15</ID>
            <ID>2</ID>
          </OrderedColumns>
          <TracedEvents>
            <Event id="14">
              <EventColumn id="1" />
              <EventColumn id="9" />
              <EventColumn id="6" />
              <EventColumn id="10" />
              <EventColumn id="14" />
              <EventColumn id="11" />
              <EventColumn id="12" />
            </Event>
            <Event id="15">
              <EventColumn id="15" />
              <EventColumn id="16" />
              <EventColumn id="9" />
              <EventColumn id="13" />
              <EventColumn id="17" />
              <EventColumn id="6" />
              <EventColumn id="10" />
              <EventColumn id="14" />
              <EventColumn id="18" />
              <EventColumn id="11" />
              <EventColumn id="12" />
            </Event>
            <Event id="17">
              <EventColumn id="12" />
              <EventColumn id="1" />
              <EventColumn id="9" />
              <EventColumn id="6" />
              <EventColumn id="10" />
              <EventColumn id="14" />
              <EventColumn id="11" />
            </Event>
            <Event id="10">
              <EventColumn id="15" />
              <EventColumn id="16" />
              <EventColumn id="9" />
              <EventColumn id="17" />
              <EventColumn id="2" />
              <EventColumn id="10" />
              <EventColumn id="18" />
              <EventColumn id="11" />
              <EventColumn id="12" />
              <EventColumn id="13" />
              <EventColumn id="6" />
              <EventColumn id="14" />
            </Event>
            <Event id="12">
              <EventColumn id="15" />
              <EventColumn id="16" />
              <EventColumn id="1" />
              <EventColumn id="9" />
              <EventColumn id="17" />
              <EventColumn id="6" />
              <EventColumn id="10" />
              <EventColumn id="14" />
              <EventColumn id="18" />
              <EventColumn id="11" />
              <EventColumn id="12" />
              <EventColumn id="13" />
            </Event>
            <Event id="13">
              <EventColumn id="12" />
              <EventColumn id="1" />
              <EventColumn id="9" />
              <EventColumn id="6" />
              <EventColumn id="10" />
              <EventColumn id="14" />
              <EventColumn id="11" />
            </Event>
          </TracedEvents>
        </ProfilerUI>
      </Header>
      <Events>
        <Event id="14" name="Audit Login">
          <Column id="1" name="TextData">-- network protocol: TCP/IP
    set quoted_identifier on
    set arithabort off
    set numeric_roundabort off
    set ansi_warnings on
    set ansi_padding on
    set ansi_nulls on
    set concat_null_yields_null on
    set cursor_close_on_commit off
    set implicit_transactions off
    set language us_english
    set dateformat mdy
    set datefirst 7
    set transaction isolation level read committed
    </Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="12" name="SPID">51</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:39.78-07:00</Column>
        </Event>
        <Event id="13" name="SQL:BatchStarting">
          <Column id="1" name="TextData"> SET FMTONLY OFF; SET NO_BROWSETABLE ON; SET FMTONLY ON;SELECT * FROM [tblSWVendor] SET FMTONLY OFF; SET NO_BROWSETABLE OFF;</Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="12" name="SPID">51</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:39.803-07:00</Column>
        </Event>
        <Event id="12" name="SQL:BatchCompleted">
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="15" name="EndTime">2009-09-30T12:23:39.807-07:00</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="12" name="SPID">51</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:39.803-07:00</Column>
          <Column id="16" name="Reads">0</Column>
          <Column id="18" name="CPU">0</Column>
          <Column id="1" name="TextData"> SET FMTONLY OFF; SET NO_BROWSETABLE ON; SET FMTONLY ON;SELECT * FROM [tblSWVendor] SET FMTONLY OFF; SET NO_BROWSETABLE OFF;</Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="13" name="Duration">1953</Column>
          <Column id="17" name="Writes">0</Column>
        </Event>
        <Event id="15" name="Audit Logout">
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="15" name="EndTime">2009-09-30T12:23:39.83-07:00</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="12" name="SPID">51</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:39.78-07:00</Column>
          <Column id="16" name="Reads">0</Column>
          <Column id="18" name="CPU">0</Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="13" name="Duration">50000</Column>
          <Column id="17" name="Writes">0</Column>
        </Event>
        <Event id="10" name="RPC:Completed">
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="15" name="EndTime">2009-09-30T12:23:39.83-07:00</Column>
          <Column id="12" name="SPID">51</Column>
          <Column id="16" name="Reads">0</Column>
          <Column id="1" name="TextData">exec sp_reset_connection </Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="13" name="Duration">0</Column>
          <Column id="17" name="Writes">0</Column>
          <Column id="2" name="BinaryData">00000000000000002600730070005F00720065007300650074005F0063006F006E006E0065006300740069006F006E00</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:39.83-07:00</Column>
          <Column id="18" name="CPU">0</Column>
        </Event>
        <Event id="14" name="Audit Login">
          <Column id="1" name="TextData">-- network protocol: TCP/IP
    set quoted_identifier on
    set arithabort off
    set numeric_roundabort off
    set ansi_warnings on
    set ansi_padding on
    set ansi_nulls on
    set concat_null_yields_null on
    set cursor_close_on_commit off
    set implicit_transactions off
    set language us_english
    set dateformat mdy
    set datefirst 7
    set transaction isolation level read committed
    </Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="12" name="SPID">51</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:39.83-07:00</Column>
        </Event>
        <Event id="13" name="SQL:BatchStarting">
          <Column id="1" name="TextData"> SET FMTONLY OFF; SET NO_BROWSETABLE ON; SET FMTONLY ON;SELECT * FROM [tblSWVendor_tombstone] SET FMTONLY OFF; SET NO_BROWSETABLE OFF;</Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="12" name="SPID">51</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:39.83-07:00</Column>
        </Event>
        <Event id="12" name="SQL:BatchCompleted">
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="15" name="EndTime">2009-09-30T12:23:39.83-07:00</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="12" name="SPID">51</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:39.83-07:00</Column>
          <Column id="16" name="Reads">0</Column>
          <Column id="18" name="CPU">0</Column>
          <Column id="1" name="TextData"> SET FMTONLY OFF; SET NO_BROWSETABLE ON; SET FMTONLY ON;SELECT * FROM [tblSWVendor_tombstone] SET FMTONLY OFF; SET NO_BROWSETABLE OFF;</Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="13" name="Duration">1953</Column>
          <Column id="17" name="Writes">0</Column>
        </Event>
        <Event id="15" name="Audit Logout">
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="15" name="EndTime">2009-09-30T12:23:59.72-07:00</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="12" name="SPID">51</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:39.83-07:00</Column>
          <Column id="16" name="Reads">0</Column>
          <Column id="18" name="CPU">0</Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="13" name="Duration">19890000</Column>
          <Column id="17" name="Writes">0</Column>
        </Event>
        <Event id="10" name="RPC:Completed">
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="15" name="EndTime">2009-09-30T12:23:59.72-07:00</Column>
          <Column id="12" name="SPID">51</Column>
          <Column id="16" name="Reads">0</Column>
          <Column id="1" name="TextData">exec sp_reset_connection </Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="13" name="Duration">0</Column>
          <Column id="17" name="Writes">0</Column>
          <Column id="2" name="BinaryData">00000000000000002600730070005F00720065007300650074005F0063006F006E006E0065006300740069006F006E00</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:59.72-07:00</Column>
          <Column id="18" name="CPU">0</Column>
        </Event>
        <Event id="14" name="Audit Login">
          <Column id="1" name="TextData">-- network protocol: TCP/IP
    set quoted_identifier on
    set arithabort off
    set numeric_roundabort off
    set ansi_warnings on
    set ansi_padding on
    set ansi_nulls on
    set concat_null_yields_null on
    set cursor_close_on_commit off
    set implicit_transactions off
    set language us_english
    set dateformat mdy
    set datefirst 7
    set transaction isolation level read committed
    </Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="12" name="SPID">51</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:59.72-07:00</Column>
        </Event>
        <Event id="10" name="RPC:Completed">
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="15" name="EndTime">2009-09-30T12:23:59.72-07:00</Column>
          <Column id="12" name="SPID">51</Column>
          <Column id="16" name="Reads">0</Column>
          <Column id="1" name="TextData">declare @p3 binary(8)
    set @p3=0x0000000000005DC0
    exec sp_executesql N'SELECT @sync_new_received_anchor = @@DBTS',N'@sync_new_received_anchor binary(8) output',@sync_new_received_anchor=@p3 output
    select @p3</Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="13" name="Duration">0</Column>
          <Column id="17" name="Writes">0</Column>
          <Column id="2" name="BinaryData">00000000040000001A00730070005F006500780065006300750074006500730071006C007800000082001800E7206E007600610072006300680061007200280034003100290052000000530045004C0045004300540020004000730079006E0063005F006E00650077005F00720065006300650069007600650064005F0061006E00630068006F00720020003D0020004000400044004200540053007A00000082001800E7206E0076006100720063006800610072002800340032002900540000004000730079006E0063005F006E00650077005F00720065006300650069007600650064005F0061006E00630068006F0072002000620069006E0061007200790028003800290020006F00750074007000750074005C00000080001200AD31620069006E0061007200790028003800290032004000730079006E0063005F006E00650077005F00720065006300650069007600650064005F0061006E00630068006F007200080000000000000000005DC01400000003000600380469006E00740000000000</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:59.72-07:00</Column>
          <Column id="18" name="CPU">0</Column>
        </Event>
        <Event id="10" name="RPC:Completed">
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="15" name="EndTime">2009-09-30T12:23:59.733-07:00</Column>
          <Column id="12" name="SPID">51</Column>
          <Column id="16" name="Reads">8</Column>
          <Column id="1" name="TextData">exec sp_executesql N'SELECT [ID], [strSWVendorName] FROM [tblSWVendor] WHERE (sync_CreationTracker &gt; @sync_last_received_anchor AND sync_CreationTracker &lt;= @sync_new_received_anchor AND sync_CreatorID &lt;&gt; @sync_originator_id)',N'@sync_last_received_anchor binary(8),@sync_new_received_anchor binary(8),@sync_originator_id int',@sync_last_received_anchor=0x0000000000000000,@sync_new_received_anchor=0x0000000000005DC0,@sync_originator_id=0</Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="13" name="Duration">1953</Column>
          <Column id="17" name="Writes">0</Column>
          <Column id="2" name="BinaryData">00000000060000001A00730070005F006500780065006300750074006500730071006C00BE01000082001A00E7206E0076006100720063006800610072002800320030003300290096010000530045004C0045004300540020005B00490044005D002C0020005B0073007400720053005700560065006E0064006F0072004E0061006D0065005D002000460052004F004D0020005B00740062006C0053005700560065006E0064006F0072005D0020005700480045005200450020002800730079006E0063005F004300720065006100740069006F006E0054007200610063006B006500720020003E0020004000730079006E0063005F006C006100730074005F00720065006300650069007600650064005F0061006E00630068006F007200200041004E0044002000730079006E0063005F004300720065006100740069006F006E0054007200610063006B006500720020003C003D0020004000730079006E0063005F006E00650077005F00720065006300650069007600650064005F0061006E00630068006F007200200041004E0044002000730079006E0063005F00430072006500610074006F0072004900440020003C003E0020004000730079006E0063005F006F0072006900670069006E00610074006F0072005F00690064002900E600000082001800E7206E0076006100720063006800610072002800390036002900C00000004000730079006E0063005F006C006100730074005F00720065006300650069007600650064005F0061006E00630068006F0072002000620069006E006100720079002800380029002C004000730079006E0063005F006E00650077005F00720065006300650069007600650064005F0061006E00630068006F0072002000620069006E006100720079002800380029002C004000730079006E0063005F006F0072006900670069006E00610074006F0072005F0069006400200069006E0074005E00000080001200AD30620069006E0061007200790028003800290034004000730079006E0063005F006C006100730074005F00720065006300650069007600650064005F0061006E00630068006F0072000800000000000000000000005C00000080001200AD30620069006E0061007200790028003800290032004000730079006E0063005F006E00650077005F00720065006300650069007600650064005F0061006E00630068006F007200080000000000000000005DC03C00000003000600381069006E00740026004000730079006E0063005F006F0072006900670069006E00610074006F0072005F0069006400000000001400000003000600380469006E00740000000000</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:59.73-07:00</Column>
          <Column id="18" name="CPU">0</Column>
        </Event>
        <Event id="10" name="RPC:Completed">
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="15" name="EndTime">2009-09-30T12:23:59.74-07:00</Column>
          <Column id="12" name="SPID">51</Column>
          <Column id="16" name="Reads">12</Column>
          <Column id="1" name="TextData">exec sp_executesql N'SELECT [ID], [strSWVendorName] FROM [tblSWVendor] WHERE (UpdateDtTm &gt; @sync_last_received_anchor AND UpdateDtTm &lt;= @sync_new_received_anchor AND sync_UpdateOriginator &lt;&gt; @sync_client_id AND  NOT (sync_CreationTracker &gt; @sync_last_received_anchor AND sync_CreatorID &lt;&gt; @sync_originator_id))',N'@sync_last_received_anchor timestamp,@sync_new_received_anchor timestamp,@sync_client_id uniqueidentifier,@sync_originator_id int',@sync_last_received_anchor=0x0000000000000000,@sync_new_received_anchor=0x0000000000005DC0,@sync_client_id='00000000-0000-0000-1234-000000001234',@sync_originator_id=0</Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="13" name="Duration">3906</Column>
          <Column id="17" name="Writes">0</Column>
          <Column id="2" name="BinaryData">00000000070000001A00730070005F006500780065006300750074006500730071006C006A02000082001A00E7206E0076006100720063006800610072002800320038003900290042020000530045004C0045004300540020005B00490044005D002C0020005B0073007400720053005700560065006E0064006F0072004E0061006D0065005D002000460052004F004D0020005B00740062006C0053005700560065006E0064006F0072005D00200057004800450052004500200028005500700064006100740065004400740054006D0020003E0020004000730079006E0063005F006C006100730074005F00720065006300650069007600650064005F0061006E00630068006F007200200041004E00440020005500700064006100740065004400740054006D0020003C003D0020004000730079006E0063005F006E00650077005F00720065006300650069007600650064005F0061006E00630068006F007200200041004E0044002000730079006E0063005F005500700064006100740065004F0072006900670069006E00610074006F00720020003C003E0020004000730079006E0063005F0063006C00690065006E0074005F0069006400200041004E004400200020004E004F00540020002800730079006E0063005F004300720065006100740069006F006E0054007200610063006B006500720020003E0020004000730079006E0063005F006C006100730074005F00720065006300650069007600650064005F0061006E00630068006F007200200041004E0044002000730079006E0063005F00430072006500610074006F0072004900440020003C003E0020004000730079006E0063005F006F0072006900670069006E00610074006F0072005F0069006400290029002A01000082001A00E7206E00760061007200630068006100720028003100320039002900020100004000730079006E0063005F006C006100730074005F00720065006300650069007600650064005F0061006E00630068006F0072002000740069006D0065007300740061006D0070002C004000730079006E0063005F006E00650077005F00720065006300650069007600650064005F0061006E00630068006F0072002000740069006D0065007300740061006D0070002C004000730079006E0063005F0063006C00690065006E0074005F0069006400200075006E0069007100750065006900640065006E007400690066006900650072002C004000730079006E0063005F006F0072006900670069006E00610074006F0072005F0069006400200069006E0074005E00000080001200AD30620069006E0061007200790028003800290034004000730079006E0063005F006C006100730074005F00720065006300650069007600650064005F0061006E00630068006F0072000800000000000000000000005C00000080001200AD30620069006E0061007200790028003800290032004000730079006E0063005F006E00650077005F00720065006300650069007600650064005F0061006E00630068006F007200080000000000000000005DC05A00000048002000241075006E0069007100750065006900640065006E007400690066006900650072001E004000730079006E0063005F0063006C00690065006E0074005F0069006400000000000000000012340000000012343C00000003000600381069006E00740026004000730079006E0063005F006F0072006900670069006E00610074006F0072005F0069006400000000001400000003000600380469006E00740000000000</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:59.733-07:00</Column>
          <Column id="18" name="CPU">0</Column>
        </Event>
        <Event id="10" name="RPC:Completed">
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="15" name="EndTime">2009-09-30T12:23:59.74-07:00</Column>
          <Column id="12" name="SPID">51</Column>
          <Column id="16" name="Reads">0</Column>
          <Column id="1" name="TextData">exec sp_executesql N'SELECT [ID], [strSWVendorName], [sync_DeletorID] FROM [tblSWVendor_tombstone] WHERE (@sync_initialized = 1 AND sync_CreationTracker &gt; @sync_last_received_anchor AND sync_CreationTracker &lt;= @sync_new_received_anchor AND sync_CreatorID &lt;&gt; @sync_originator_id)',N'@sync_initialized bit,@sync_last_received_anchor binary(8),@sync_new_received_anchor binary(8),@sync_originator_id int',@sync_initialized=1,@sync_last_received_anchor=0x0000000000000000,@sync_new_received_anchor=0x0000000000005DC0,@sync_originator_id=0</Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="13" name="Duration">1953</Column>
          <Column id="17" name="Writes">0</Column>
          <Column id="2" name="BinaryData">00000000070000001A00730070005F006500780065006300750074006500730071006C002A02000082001A00E7206E0076006100720063006800610072002800320035003700290002020000530045004C0045004300540020005B00490044005D002C0020005B0073007400720053005700560065006E0064006F0072004E0061006D0065005D002C0020005B00730079006E0063005F00440065006C00650074006F007200490044005D002000460052004F004D0020005B00740062006C0053005700560065006E0064006F0072005F0074006F006D006200730074006F006E0065005D00200057004800450052004500200028004000730079006E0063005F0069006E0069007400690061006C0069007A006500640020003D0020003100200041004E0044002000730079006E0063005F004300720065006100740069006F006E0054007200610063006B006500720020003E0020004000730079006E0063005F006C006100730074005F00720065006300650069007600650064005F0061006E00630068006F007200200041004E0044002000730079006E0063005F004300720065006100740069006F006E0054007200610063006B006500720020003C003D0020004000730079006E0063005F006E00650077005F00720065006300650069007600650064005F0061006E00630068006F007200200041004E0044002000730079006E0063005F00430072006500610074006F0072004900440020003C003E0020004000730079006E0063005F006F0072006900670069006E00610074006F0072005F006900640029001401000082001A00E7206E00760061007200630068006100720028003100310038002900EC0000004000730079006E0063005F0069006E0069007400690061006C0069007A006500640020006200690074002C004000730079006E0063005F006C006100730074005F00720065006300650069007600650064005F0061006E00630068006F0072002000620069006E006100720079002800380029002C004000730079006E0063005F006E00650077005F00720065006300650069007600650064005F0061006E00630068006F0072002000620069006E006100720079002800380029002C004000730079006E0063005F006F0072006900670069006E00610074006F0072005F0069006400200069006E007400360000000B000600681062006900740022004000730079006E0063005F0069006E0069007400690061006C0069007A0065006400FFFF5E00000080001200AD30620069006E0061007200790028003800290034004000730079006E0063005F006C006100730074005F00720065006300650069007600650064005F0061006E00630068006F0072000800000000000000000000005C00000080001200AD30620069006E0061007200790028003800290032004000730079006E0063005F006E00650077005F00720065006300650069007600650064005F0061006E00630068006F007200080000000000000000005DC03C00000003000600381069006E00740026004000730079006E0063005F006F0072006900670069006E00610074006F0072005F0069006400000000001400000003000600380469006E00740000000000</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:59.74-07:00</Column>
          <Column id="18" name="CPU">0</Column>
        </Event>
        <Event id="65529" name="Trace Pause">
          <Column id="14" name="StartTime">2009-09-30T12:24:28.487-07:00</Column>
        </Event>
      </Events>
    </TraceData>



    Wednesday, September 30, 2009 8:35 PM
  • (continued)

    Client:
    <?xml version="1.0" encoding="utf-16"?>
    <TraceData xmlns="http://tempuri.org/TracePersistence.xsd">
      <Header>
        <TraceProvider name="Microsoft SQL Server" MajorVersion="9" MinorVersion="0" BuildNumber="4035" />
        <ServerInformation name="mybox\SQLEXPRESSB" />
        <ProfilerUI>
          <OrderedColumns>
            <ID>27</ID>
            <ID>1</ID>
            <ID>10</ID>
            <ID>6</ID>
            <ID>11</ID>
            <ID>18</ID>
            <ID>16</ID>
            <ID>17</ID>
            <ID>13</ID>
            <ID>9</ID>
            <ID>12</ID>
            <ID>14</ID>
            <ID>15</ID>
            <ID>2</ID>
          </OrderedColumns>
          <TracedEvents>
            <Event id="14">
              <EventColumn id="1" />
              <EventColumn id="9" />
              <EventColumn id="6" />
              <EventColumn id="10" />
              <EventColumn id="14" />
              <EventColumn id="11" />
              <EventColumn id="12" />
            </Event>
            <Event id="15">
              <EventColumn id="15" />
              <EventColumn id="16" />
              <EventColumn id="9" />
              <EventColumn id="13" />
              <EventColumn id="17" />
              <EventColumn id="6" />
              <EventColumn id="10" />
              <EventColumn id="14" />
              <EventColumn id="18" />
              <EventColumn id="11" />
              <EventColumn id="12" />
            </Event>
            <Event id="17">
              <EventColumn id="12" />
              <EventColumn id="1" />
              <EventColumn id="9" />
              <EventColumn id="6" />
              <EventColumn id="10" />
              <EventColumn id="14" />
              <EventColumn id="11" />
            </Event>
            <Event id="10">
              <EventColumn id="15" />
              <EventColumn id="16" />
              <EventColumn id="9" />
              <EventColumn id="17" />
              <EventColumn id="2" />
              <EventColumn id="10" />
              <EventColumn id="18" />
              <EventColumn id="11" />
              <EventColumn id="12" />
              <EventColumn id="13" />
              <EventColumn id="6" />
              <EventColumn id="14" />
            </Event>
            <Event id="12">
              <EventColumn id="15" />
              <EventColumn id="16" />
              <EventColumn id="1" />
              <EventColumn id="9" />
              <EventColumn id="17" />
              <EventColumn id="6" />
              <EventColumn id="10" />
              <EventColumn id="14" />
              <EventColumn id="18" />
              <EventColumn id="11" />
              <EventColumn id="12" />
              <EventColumn id="13" />
            </Event>
            <Event id="13">
              <EventColumn id="12" />
              <EventColumn id="1" />
              <EventColumn id="9" />
              <EventColumn id="6" />
              <EventColumn id="10" />
              <EventColumn id="14" />
              <EventColumn id="11" />
            </Event>
          </TracedEvents>
        </ProfilerUI>
      </Header>
      <Events>
        <Event id="14" name="Audit Login">
          <Column id="1" name="TextData">-- network protocol: LPC
    set quoted_identifier on
    set arithabort off
    set numeric_roundabort off
    set ansi_warnings on
    set ansi_padding on
    set ansi_nulls on
    set concat_null_yields_null on
    set cursor_close_on_commit off
    set implicit_transactions off
    set language us_english
    set dateformat mdy
    set datefirst 7
    set transaction isolation level read committed
    </Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="12" name="SPID">53</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:39.737-07:00</Column>
        </Event>
        <Event id="15" name="Audit Logout">
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="15" name="EndTime">2009-09-30T12:23:55.58-07:00</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="12" name="SPID">53</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:39.737-07:00</Column>
          <Column id="16" name="Reads">239</Column>
          <Column id="18" name="CPU">0</Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="13" name="Duration">15843000</Column>
          <Column id="17" name="Writes">2</Column>
        </Event>
        <Event id="10" name="RPC:Completed">
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="15" name="EndTime">2009-09-30T12:23:55.58-07:00</Column>
          <Column id="12" name="SPID">53</Column>
          <Column id="16" name="Reads">0</Column>
          <Column id="1" name="TextData">exec sp_reset_connection </Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="13" name="Duration">0</Column>
          <Column id="17" name="Writes">0</Column>
          <Column id="2" name="BinaryData">00000000000000002600730070005F00720065007300650074005F0063006F006E006E0065006300740069006F006E00</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:55.58-07:00</Column>
          <Column id="18" name="CPU">0</Column>
        </Event>
        <Event id="14" name="Audit Login">
          <Column id="1" name="TextData">-- network protocol: LPC
    set quoted_identifier on
    set arithabort off
    set numeric_roundabort off
    set ansi_warnings on
    set ansi_padding on
    set ansi_nulls on
    set concat_null_yields_null on
    set cursor_close_on_commit off
    set implicit_transactions off
    set language us_english
    set dateformat mdy
    set datefirst 7
    set transaction isolation level read committed
    </Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="12" name="SPID">53</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:55.58-07:00</Column>
        </Event>
        <Event id="13" name="SQL:BatchStarting">
          <Column id="1" name="TextData">SELECT Guid FROM guid</Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="12" name="SPID">53</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:55.58-07:00</Column>
        </Event>
        <Event id="12" name="SQL:BatchCompleted">
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="15" name="EndTime">2009-09-30T12:23:55.693-07:00</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="12" name="SPID">53</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:55.58-07:00</Column>
          <Column id="16" name="Reads">231</Column>
          <Column id="18" name="CPU">0</Column>
          <Column id="1" name="TextData">SELECT Guid FROM guid</Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="13" name="Duration">111328</Column>
          <Column id="17" name="Writes">0</Column>
        </Event>
        <Event id="13" name="SQL:BatchStarting">
          <Column id="1" name="TextData">SELECT ReceivedAnchor FROM anchor WHERE TableName = 'tblSWVendor'</Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="12" name="SPID">53</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:56.923-07:00</Column>
        </Event>
        <Event id="12" name="SQL:BatchCompleted">
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="15" name="EndTime">2009-09-30T12:23:56.97-07:00</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="12" name="SPID">53</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:56.923-07:00</Column>
          <Column id="16" name="Reads">108</Column>
          <Column id="18" name="CPU">15</Column>
          <Column id="1" name="TextData">SELECT ReceivedAnchor FROM anchor WHERE TableName = 'tblSWVendor'</Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="13" name="Duration">46875</Column>
          <Column id="17" name="Writes">4</Column>
        </Event>
        <Event id="13" name="SQL:BatchStarting">
          <Column id="1" name="TextData">SELECT SentAnchor FROM anchor WHERE TableName = 'tblSWVendor'</Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="12" name="SPID">53</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:57.53-07:00</Column>
        </Event>
        <Event id="12" name="SQL:BatchCompleted">
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="15" name="EndTime">2009-09-30T12:23:57.533-07:00</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="12" name="SPID">53</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:57.53-07:00</Column>
          <Column id="16" name="Reads">6</Column>
          <Column id="18" name="CPU">0</Column>
          <Column id="1" name="TextData">SELECT SentAnchor FROM anchor WHERE TableName = 'tblSWVendor'</Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="13" name="Duration">1953</Column>
          <Column id="17" name="Writes">0</Column>
        </Event>
        <Event id="13" name="SQL:BatchStarting">
          <Column id="1" name="TextData">SELECT ReceivedAnchor FROM anchor WHERE TableName = 'tblSWVendor'</Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="12" name="SPID">53</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:58.14-07:00</Column>
        </Event>
        <Event id="12" name="SQL:BatchCompleted">
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="15" name="EndTime">2009-09-30T12:23:58.14-07:00</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="12" name="SPID">53</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:58.14-07:00</Column>
          <Column id="16" name="Reads">4</Column>
          <Column id="18" name="CPU">0</Column>
          <Column id="1" name="TextData">SELECT ReceivedAnchor FROM anchor WHERE TableName = 'tblSWVendor'</Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="13" name="Duration">0</Column>
          <Column id="17" name="Writes">0</Column>
        </Event>
        <Event id="15" name="Audit Logout">
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="15" name="EndTime">2009-09-30T12:23:59.743-07:00</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="12" name="SPID">53</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:55.58-07:00</Column>
          <Column id="16" name="Reads">588</Column>
          <Column id="18" name="CPU">15</Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="13" name="Duration">4163000</Column>
          <Column id="17" name="Writes">6</Column>
        </Event>
        <Event id="10" name="RPC:Completed">
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="15" name="EndTime">2009-09-30T12:23:59.747-07:00</Column>
          <Column id="12" name="SPID">53</Column>
          <Column id="16" name="Reads">0</Column>
          <Column id="1" name="TextData">exec sp_reset_connection </Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="13" name="Duration">976</Column>
          <Column id="17" name="Writes">0</Column>
          <Column id="2" name="BinaryData">00000000000000002600730070005F00720065007300650074005F0063006F006E006E0065006300740069006F006E00</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:59.743-07:00</Column>
          <Column id="18" name="CPU">0</Column>
        </Event>
        <Event id="14" name="Audit Login">
          <Column id="1" name="TextData">-- network protocol: LPC
    set quoted_identifier on
    set arithabort off
    set numeric_roundabort off
    set ansi_warnings on
    set ansi_padding on
    set ansi_nulls on
    set concat_null_yields_null on
    set cursor_close_on_commit off
    set implicit_transactions off
    set language us_english
    set dateformat mdy
    set datefirst 7
    set transaction isolation level read committed
    </Column>
          <Column id="9" name="ClientProcessID">4048</Column>
          <Column id="11" name="LoginName">mycompany\me</Column>
          <Column id="6" name="NTUserName">me</Column>
          <Column id="10" name="ApplicationName">.Net SqlClient Data Provider</Column>
          <Column id="12" name="SPID">53</Column>
          <Column id="14" name="StartTime">2009-09-30T12:23:59.747-07:00</Column>
        </Event>
        <Event id="65529" name="Trace Pause">
          <Column id="14" name="StartTime">2009-09-30T12:24:21.097-07:00</Column>
        </Event>
      </Events>
    </TraceData>

    I reiterate:  HELP!!!!  

    Wednesday, September 30, 2009 8:35 PM
  • Been away for a couple of days.  More info:

    The ApplyChanges method of the SqlExpressClientSyncProvider is where the error is being thrown.  It's at the following statement:

    SyncContext syncContext = _dbSyncProvider.ApplyChanges(groupMetadata, dataSet, syncSession);

    Querying dataSet.Tables.Count returns 0.  Should this not be a 1 which would correspond to the number of tables I'm trying to sync?

    -Saro
    Monday, October 5, 2009 3:34 PM
  • Hi Saro,

    Thanks for the update. This is useful info.

    The exception
    ( at Microsoft.Synchronization.Data.Server.DbServerSyncProvider.PrepareForApplyingToTable(ApplyChangeType act, DataSet dataSet, SyncTableMetadata tableMetadata, IDbTransaction transaction, SyncAdapter& adapter, IDbCommand& cmd, DataTable& dataTable, DataColumnCollection& columns, SyncTableProgress& tableProgress)

       at Microsoft.Synchronization.Data.Server.DbServerSyncProvider.ApplyChangesInternal(SyncGroupMetadata groupMetadata, DataSet dataSet, SyncSession syncSession, IDbTransaction transaction, ApplyChangeType changeType)
       at Microsoft.Synchronization.Data.Server.DbServerSyncProvider.ApplyChanges(SyncGroupMetadata groupMetadata, DataSet dataSet, SyncSession syncSession)

    )
    is thrown from an internal methods where to check if there is a match syncAdapter for a partular table in the metadata. so in this case, can you check the groupMetadata to see what tables are there and check the sync adapters ( for tables ) on THE dbsyncProvider to see if they match ?

    thanks
    Yunwen


    This posting is provided "AS IS" with no warranties, and confers no rights.
    Friday, October 9, 2009 3:52 PM
    Moderator
  • how are we doing ? have we got the root cause yet ?

    thanks
    Yunwen
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, October 14, 2009 8:21 AM
    Moderator
  • My eyes must be crossed.  I rewrote my code and it appeared to start working.  Great!

    Then my machine crashed.  Now my code appears to not be working again.  I can rename the client side table and the sync framework doesn't even know the difference.  No errors.

    Good Times.
    Tuesday, October 20, 2009 11:15 PM
  • Ouch :( I would look for some bad dll's being loaded from unexpected places or point to wrong databases etc. This definitely sounds like a configuration issue at this point.

    Thanks
    Deepa
    Deepa ( Microsoft Sync Framework)
    Tuesday, October 20, 2009 11:44 PM
    Answerer
  • There's something wrong with my IDE.  One other project has been behaving strangely.  Basically, changes appear to get undone, files or projects get dropped from a solution, etc.  Bad Keyboard?  Faulty IDE (unlikely)?

    Time for a reinstall.

    PS - It works after I started over on it.....
    • Marked as answer by SaroDude Thursday, October 22, 2009 10:29 PM
    Thursday, October 22, 2009 10:28 PM