none
Not able to update .sdf database. Windows Forms app thru internet calling WCF / IIS 7 / Windows 7 Home Premium. RRS feed

  • Question

  • Hi:

    I have a windows forms that uses ms sync services thru a WCF. It suppose to download data to several tables, and 1 table will upload only to the SQL Server 2008

    The WCF was installed in IIS 7.0 and is been call my the app thru internet.

    No security is active.

    The uploading to the server is working correctly. I am tracing the results and the download part is not working.

    Here is a copy of the trace. Please help, why is it not updating the  local .sdf database although I am receiving the changes??  Thank you

    -----------------------------------------

    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:335, Connecting to CE database: C:\Program Files (x86)\New Millennium Systems\MovilAvante\MovilAvante\MovilAvante.sdf
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:363, **** Client Provider Begin Transaction ****
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:464, Camiones: Read SentAnchor value: NULL
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:474, Camiones: Read ReceivedAnchor value: 711
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:480, CamionesSocios: Read SentAnchor value: NULL
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:487, CamionesSocios: Read ReceivedAnchor value: 711
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:493, Clientes: Read SentAnchor value: NULL
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:499, Clientes: Read ReceivedAnchor value: 711
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:505, ClientesTiposDeServicios: Read SentAnchor value: NULL
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:509, ClientesTiposDeServicios: Read ReceivedAnchor value: 711
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:513, Empleados: Read SentAnchor value: NULL
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:517, Empleados: Read ReceivedAnchor value: 711
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:521, Rastreo: Read SentAnchor value: 378
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:525, Rastreo: Read ReceivedAnchor value: 761
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:529, Socios: Read SentAnchor value: NULL
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:533, Socios: Read ReceivedAnchor value: 711
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:536, TiposDeServicios: Read SentAnchor value: NULL
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:540, TiposDeServicios: Read ReceivedAnchor value: 711
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:544, TiposDeViajes: Read SentAnchor value: NULL
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:548, TiposDeViajes: Read ReceivedAnchor value: 711
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:549, **** Client Provider Commit Transaction ****
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:562, Connecting to CE database: C:\Program Files (x86)\New Millennium Systems\MovilAvante\MovilAvante\MovilAvante.sdf
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:574, **** Client Provider Begin Transaction ****
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:576, **** Client Provider Commit Transaction ****
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:577, ----- Client Enumerating Changes to Server for Group "MovilAvanteCacheGlobalSyncGroup" -----
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:577, Connecting to CE database: C:\Program Files (x86)\New Millennium Systems\MovilAvante\MovilAvante\MovilAvante.sdf
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:589, **** Client Provider Begin Transaction ****
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:600,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:600,    ----- Enumerating Inserts for Table Rastreo -----
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:606, Using Command:  select ut.* from    (select ut0.* from [Rastreo] as ut0 where      (ut0.__sysTrackingContext <> @CNTX OR ut0.__sysTrackingContext IS NULL)      AND (ut0.__sysChangeTxBsn >= @LBSN)      AND (ut0.__sysInsertTxBsn NOT IN (SELECT SyncBsn FROM __syncTransactions))   ) as ut  LEFT OUTER JOIN    (select txcs0.* from __sysTxCommitSequence as txcs0) as txcs  ON (ut.__sysInsertTxBsn = txcs.__sysTxBsn) WHERE       COALESCE(txcs.__sysTxCsn, ut.__sysInsertTxBsn) > @LCSN AND COALESCE(txcs.__sysTxCsn, ut.__sysInsertTxBsn) <= @ECSN
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:608,    Parameter: @LCSN Value: 378
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:608,    Parameter: @LBSN Value: 378
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:608,    Parameter: @ECSN Value: 386
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:609,    Parameter: @CNTX Value: 1efe839d-b5ab-41af-b9cc-144b3608155e
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:609,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:646,       Changes Enumerated: 0
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:646,    --- End Enumerating Inserts for Table Rastreo ---
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:652,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:652,    ----- Enumerating Updates for Table Rastreo -----
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:653, Using Command:  SELECT ut.* FROM    (select ut0.* from [Rastreo] as ut0 where      (ut0.__sysTrackingContext <> @CNTX OR ut0.__sysTrackingContext IS NULL)      AND ut0.__sysChangeTxBsn >= @LBSN    ) as ut  LEFT OUTER JOIN   (select txcs0.* from __sysTxCommitSequence as txcs0) as txcsInsert  ON ut.__sysInsertTxBsn = txcsInsert.__sysTxBsn  LEFT OUTER JOIN   (select txcs0.* from __sysTxCommitSequence as txcs0) as txcsUpdate  ON ut.__sysChangeTxBsn = txcsUpdate.__sysTxBsn WHERE    COALESCE(txcsUpdate.__sysTxCsn, ut.__sysChangeTxBsn) > @LCSN AND COALESCE(txcsUpdate.__sysTxCsn, ut.__sysChangeTxBsn) <= @ECSN   AND   (COALESCE(txcsInsert.__sysTxCsn, ut.__sysInsertTxBsn) <= @LCSN OR    COALESCE(txcsInsert.__sysTxCsn, ut.__sysInsertTxBsn) IS NULL OR    ut.__sysInsertTxBsn IN (SELECT SyncBsn FROM __syncTransactions))
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:653,    Parameter: @LCSN Value: 378
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:653,    Parameter: @LBSN Value: 378
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:653,    Parameter: @ECSN Value: 386
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:653,    Parameter: @CNTX Value: 1efe839d-b5ab-41af-b9cc-144b3608155e
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:653,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:670,       Changes Enumerated: 0
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:670,    --- End Enumerating Updates for Table Rastreo ---
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:677,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:677,    ----- Enumerating Deletes for Table Rastreo -----
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:691, Using Command:  SELECT ut.__sysRK, ut.__sysInsertTxCsn FROM    (select ut0.* from __sysOcsDeletedRows as ut0 where      (ut0.__sysTrackingContext <> @CNTX OR ut0.__sysTrackingContext IS NULL) AND      (ut0.__sysInsertTxCsn IS NULL OR      (ut0.__sysInsertTxCsn > @LCSN AND ut0.__sysInsertTxCsn IN (SELECT COALESCE(__sysTxCsn, SyncBsn) FROM __syncTransactions st LEFT OUTER JOIN __sysTxCommitSequence ct ON st.SyncBsn = ct.__sysTxBsn))      OR ut0.__sysInsertTxCsn <= @LCSN) AND      ut0.__sysTName = 'Rastreo'   ) AS ut  LEFT OUTER JOIN     (select txcs0.* from __sysTxCommitSequence as txcs0) as txcs  ON ut.__sysDeleteTxBsn = txcs.__sysTxBsn WHERE    COALESCE(txcs.__sysTxCsn, ut.__sysDeleteTxBsn) > @LCSN AND COALESCE(txcs.__sysTxCsn, ut.__sysDeleteTxBsn) <= @ECSN
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:692,    Parameter: @LCSN Value: 378
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:692,    Parameter: @LBSN Value: 378
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:692,    Parameter: @ECSN Value: 386
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:692,    Parameter: @CNTX Value: 1efe839d-b5ab-41af-b9cc-144b3608155e
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:692,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:699,       Changes Enumerated: 0
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:699,    --- End Enumerating Deletes for Table Rastreo ---
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:699, **** Client Provider Commit Transaction ****
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:700, --- End Client Enumerating Changes to Server for Group "MovilAvanteCacheGlobalSyncGroup" ---
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:703, Connecting to CE database: C:\Program Files (x86)\New Millennium Systems\MovilAvante\MovilAvante\MovilAvante.sdf
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:712, **** Client Provider Begin Transaction ****
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:725, Rastreo: Set SentAnchor value: 386
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:779, **** Client Provider Commit Transaction ****
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:605, Connecting to CE database: C:\Program Files (x86)\New Millennium Systems\MovilAvante\MovilAvante\MovilAvante.sdf
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:625, **** Client Provider Begin Transaction ****
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:638, ----- Client Applying Changes from Server for Group "MovilAvanteCacheGlobalSyncGroup" -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:638,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:639,    ----- Applying Deletes for Table TiposDeViajes -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:678,       Deletes Applied: 0
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:678,    --- End Applying Deletes for Table TiposDeViajes -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:678,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:678,    ----- Applying Deletes for Table TiposDeServicios -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:703,       Deletes Applied: 0
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:704,    --- End Applying Deletes for Table TiposDeServicios -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:704,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:704,    ----- Applying Deletes for Table Socios -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:735,       Deletes Applied: 0
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:735,    --- End Applying Deletes for Table Socios -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:735,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:735,    ----- Applying Deletes for Table Empleados -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:761,       Deletes Applied: 0
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:761,    --- End Applying Deletes for Table Empleados -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:761,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:761,    ----- Applying Deletes for Table ClientesTiposDeServicios -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:776,       Deletes Applied: 0
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:776,    --- End Applying Deletes for Table ClientesTiposDeServicios -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:776,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:776,    ----- Applying Deletes for Table Clientes -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:791,       Deletes Applied: 0
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:791,    --- End Applying Deletes for Table Clientes -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:791,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:791,    ----- Applying Deletes for Table CamionesSocios -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:806,       Deletes Applied: 0
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:807,    --- End Applying Deletes for Table CamionesSocios -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:807,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:807,    ----- Applying Deletes for Table Camiones -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:829,       Deletes Applied: 0
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:829,    --- End Applying Deletes for Table Camiones -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:829,
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:829,    ----- Applying Upserts for Table Camiones -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:858,
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:858,    ----- Applying Inserts for Table Camiones -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:861,       Inserts Applied: 0
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:861,
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:861,    ----- Applying Updates for Table Camiones -----
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:865, Using Command:  UPDATE [Camiones] SET [Serie] = @P_530045005200490045000000, [Marca] = @P_4D0041005200430041000000, [Modelo] = @P_4D004F00440045004C004F000000, [Carroceria] = @P_43004100520052004F00430045005200490041000000, [Motor] = @P_4D004F0054004F0052000000, [Asientos] = @P_41005300490045004E0054004F0053000000, [CreationDate] = @P_4300520045004100540049004F004E0044004100540045000000, [LastEditDate] = @P_4C00410053005400450044004900540044004100540045000000 WHERE [UnidadID] = @P_55004E004900440041004400490044000000 AND (__sysTrackingContext = @CNTX OR __sysChangeTxBsn IS NULL        OR          (__sysChangeTxBsn in (select __sysTxBsn from __sysTxCommitSequence where __sysTxCsn <= @P_5F005F0053005900530041004E00430048004F0052000000                              )         )       OR          (__sysChangeTxBsn not in (select __sysTxBsn from __sysTxCommitSequence)               and           __sysChangeTxBsn <= @P_5F005F0053005900530041004E00430048004F0052000000         )     ) ;
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:866,    Parameter: @P_5F005F0053005900530041004E00430048004F0052000000 Value: 0
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:866,    Parameter: @CNTX Value: 1efe839d-b5ab-41af-b9cc-144b3608155e
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:866,    Parameter: @P_55004E004900440041004400490044000000 Len: 4 Value: 5187
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:866,    Parameter: @P_530045005200490045000000 Len: 17 Value: 1HVBDPLP5PH508467
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:866,    Parameter: @P_4D0041005200430041000000 Len: 13 Value: Internacional
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:866,    Parameter: @P_4D004F00440045004C004F000000 Value: 2011
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:866,    Parameter: @P_43004100520052004F00430045005200490041000000 Len: 20 Value: NULL
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:866,    Parameter: @P_4D004F0054004F0052000000 Value: 360
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:866,    Parameter: @P_41005300490045004E0054004F0053000000 Value: 47
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:878,    Parameter: @P_4300520045004100540049004F004E0044004100540045000000 Value: 3/8/2011 9:13:27 PM
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:879,    Parameter: @P_4C00410053005400450044004900540044004100540045000000 Value: 3/8/2011 9:13:27 PM
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:879,
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:889, Using Command:  UPDATE [Camiones] SET [Serie] = @P_530045005200490045000000, [Marca] = @P_4D0041005200430041000000, [Modelo] = @P_4D004F00440045004C004F000000, [Carroceria] = @P_43004100520052004F00430045005200490041000000, [Motor] = @P_4D004F0054004F0052000000, [Asientos] = @P_41005300490045004E0054004F0053000000, [CreationDate] = @P_4300520045004100540049004F004E0044004100540045000000, [LastEditDate] = @P_4C00410053005400450044004900540044004100540045000000 WHERE [UnidadID] = @P_55004E004900440041004400490044000000 AND (__sysTrackingContext = @CNTX OR __sysChangeTxBsn IS NULL        OR          (__sysChangeTxBsn in (select __sysTxBsn from __sysTxCommitSequence where __sysTxCsn <= @P_5F005F0053005900530041004E00430048004F0052000000                              )         )       OR          (__sysChangeTxBsn not in (select __sysTxBsn from __sysTxCommitSequence)               and           __sysChangeTxBsn <= @P_5F005F0053005900530041004E00430048004F0052000000         )     ) ;
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:890,    Parameter: @P_5F005F0053005900530041004E00430048004F0052000000 Value: 0
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:890,    Parameter: @CNTX Value: 1efe839d-b5ab-41af-b9cc-144b3608155e
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:890,    Parameter: @P_55004E004900440041004400490044000000 Len: 4 Value: 5195
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:890,    Parameter: @P_530045005200490045000000 Len: 17 Value: 1HVBAZRM8PH526429
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:890,    Parameter: @P_4D0041005200430041000000 Len: 13 Value: Internacional
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:890,    Parameter: @P_4D004F00440045004C004F000000 Value: 2011
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:890,    Parameter: @P_43004100520052004F00430045005200490041000000 Len: 20 Value: NULL
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:890,    Parameter: @P_4D004F0054004F0052000000 Value: 7.3
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:890,    Parameter: @P_41005300490045004E0054004F0053000000 Value: 28
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:890,    Parameter: @P_4300520045004100540049004F004E0044004100540045000000 Value: 3/8/2011 9:13:27 PM
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:890,    Parameter: @P_4C00410053005400450044004900540044004100540045000000 Value: 3/8/2011 9:13:27 PM
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:890,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:892,       Updates Applied: 0
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:892,       Updates  Failed: 2
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:894,    --- End Applying Upserts for Table Camiones ---
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:894,
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:894,    ----- Applying Upserts for Table CamionesSocios -----
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:894,    --- End Applying Upserts for Table CamionesSocios ---
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:894,
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:894,    ----- Applying Upserts for Table Clientes -----
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:894,    --- End Applying Upserts for Table Clientes ---
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:894,
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:894,    ----- Applying Upserts for Table ClientesTiposDeServicios -----
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:894,    --- End Applying Upserts for Table ClientesTiposDeServicios ---
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:894,
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:894,    ----- Applying Upserts for Table Empleados -----
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:894,    --- End Applying Upserts for Table Empleados ---
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:894,
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:894,    ----- Applying Upserts for Table Socios -----
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:894,    --- End Applying Upserts for Table Socios ---
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:895,
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:895,    ----- Applying Upserts for Table TiposDeServicios -----
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:895,    --- End Applying Upserts for Table TiposDeServicios ---
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:895,
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:895,    ----- Applying Upserts for Table TiposDeViajes -----
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:895,    --- End Applying Upserts for Table TiposDeViajes ---
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:899, Camiones: Set ReceivedAnchor value: 713
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:902, CamionesSocios: Set ReceivedAnchor value: 713
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:906, Clientes: Set ReceivedAnchor value: 713
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:909, ClientesTiposDeServicios: Set ReceivedAnchor value: 713
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:911, Empleados: Set ReceivedAnchor value: 713
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:914, Socios: Set ReceivedAnchor value: 713
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:917, TiposDeServicios: Set ReceivedAnchor value: 713
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:920, TiposDeViajes: Set ReceivedAnchor value: 713
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:921, --- End Client Applying Changes from Server for Group "MovilAvanteCacheGlobalSyncGroup" ---
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:979, **** Client Provider Commit Transaction ****


    JD
    Friday, April 22, 2011 2:11 AM

Answers

All replies

  • Hi:

    I have a windows forms that uses ms sync services. It suppose to download data to 5 tables, and 1 table will upload only to the SQL Server 2008

    The uploading to the server is working correctly. I am tracing the results and the download part is not working.

    Here is a copy of the trace. Please help, why is it not updating the .sdf database although I am receiving the changes??  Thank you

    -----------------------------------------

    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:335, Connecting to CE database: C:\Program Files (x86)\New Millennium Systems\MovilAvante\MovilAvante\MovilAvante.sdf
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:363, **** Client Provider Begin Transaction ****
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:464, Camiones: Read SentAnchor value: NULL
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:474, Camiones: Read ReceivedAnchor value: 711
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:480, CamionesSocios: Read SentAnchor value: NULL
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:487, CamionesSocios: Read ReceivedAnchor value: 711
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:493, Clientes: Read SentAnchor value: NULL
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:499, Clientes: Read ReceivedAnchor value: 711
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:505, ClientesTiposDeServicios: Read SentAnchor value: NULL
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:509, ClientesTiposDeServicios: Read ReceivedAnchor value: 711
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:513, Empleados: Read SentAnchor value: NULL
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:517, Empleados: Read ReceivedAnchor value: 711
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:521, Rastreo: Read SentAnchor value: 378
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:525, Rastreo: Read ReceivedAnchor value: 761
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:529, Socios: Read SentAnchor value: NULL
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:533, Socios: Read ReceivedAnchor value: 711
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:536, TiposDeServicios: Read SentAnchor value: NULL
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:540, TiposDeServicios: Read ReceivedAnchor value: 711
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:544, TiposDeViajes: Read SentAnchor value: NULL
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:548, TiposDeViajes: Read ReceivedAnchor value: 711
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:549, **** Client Provider Commit Transaction ****
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:562, Connecting to CE database: C:\Program Files (x86)\New Millennium Systems\MovilAvante\MovilAvante\MovilAvante.sdf
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:574, **** Client Provider Begin Transaction ****
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:576, **** Client Provider Commit Transaction ****
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:577, ----- Client Enumerating Changes to Server for Group "MovilAvanteCacheGlobalSyncGroup" -----
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:577, Connecting to CE database: C:\Program Files (x86)\New Millennium Systems\MovilAvante\MovilAvante\MovilAvante.sdf
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:589, **** Client Provider Begin Transaction ****
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:600,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:600,    ----- Enumerating Inserts for Table Rastreo -----
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:606, Using Command:  select ut.* from    (select ut0.* from [Rastreo] as ut0 where      (ut0.__sysTrackingContext <> @CNTX OR ut0.__sysTrackingContext IS NULL)      AND (ut0.__sysChangeTxBsn >= @LBSN)      AND (ut0.__sysInsertTxBsn NOT IN (SELECT SyncBsn FROM __syncTransactions))   ) as ut  LEFT OUTER JOIN    (select txcs0.* from __sysTxCommitSequence as txcs0) as txcs  ON (ut.__sysInsertTxBsn = txcs.__sysTxBsn) WHERE       COALESCE(txcs.__sysTxCsn, ut.__sysInsertTxBsn) > @LCSN AND COALESCE(txcs.__sysTxCsn, ut.__sysInsertTxBsn) <= @ECSN
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:608,    Parameter: @LCSN Value: 378
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:608,    Parameter: @LBSN Value: 378
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:608,    Parameter: @ECSN Value: 386
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:609,    Parameter: @CNTX Value: 1efe839d-b5ab-41af-b9cc-144b3608155e
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:609,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:646,       Changes Enumerated: 0
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:646,    --- End Enumerating Inserts for Table Rastreo ---
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:652,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:652,    ----- Enumerating Updates for Table Rastreo -----
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:653, Using Command:  SELECT ut.* FROM    (select ut0.* from [Rastreo] as ut0 where      (ut0.__sysTrackingContext <> @CNTX OR ut0.__sysTrackingContext IS NULL)      AND ut0.__sysChangeTxBsn >= @LBSN    ) as ut  LEFT OUTER JOIN   (select txcs0.* from __sysTxCommitSequence as txcs0) as txcsInsert  ON ut.__sysInsertTxBsn = txcsInsert.__sysTxBsn  LEFT OUTER JOIN   (select txcs0.* from __sysTxCommitSequence as txcs0) as txcsUpdate  ON ut.__sysChangeTxBsn = txcsUpdate.__sysTxBsn WHERE    COALESCE(txcsUpdate.__sysTxCsn, ut.__sysChangeTxBsn) > @LCSN AND COALESCE(txcsUpdate.__sysTxCsn, ut.__sysChangeTxBsn) <= @ECSN   AND   (COALESCE(txcsInsert.__sysTxCsn, ut.__sysInsertTxBsn) <= @LCSN OR    COALESCE(txcsInsert.__sysTxCsn, ut.__sysInsertTxBsn) IS NULL OR    ut.__sysInsertTxBsn IN (SELECT SyncBsn FROM __syncTransactions))
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:653,    Parameter: @LCSN Value: 378
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:653,    Parameter: @LBSN Value: 378
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:653,    Parameter: @ECSN Value: 386
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:653,    Parameter: @CNTX Value: 1efe839d-b5ab-41af-b9cc-144b3608155e
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:653,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:670,       Changes Enumerated: 0
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:670,    --- End Enumerating Updates for Table Rastreo ---
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:677,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:677,    ----- Enumerating Deletes for Table Rastreo -----
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:691, Using Command:  SELECT ut.__sysRK, ut.__sysInsertTxCsn FROM    (select ut0.* from __sysOcsDeletedRows as ut0 where      (ut0.__sysTrackingContext <> @CNTX OR ut0.__sysTrackingContext IS NULL) AND      (ut0.__sysInsertTxCsn IS NULL OR      (ut0.__sysInsertTxCsn > @LCSN AND ut0.__sysInsertTxCsn IN (SELECT COALESCE(__sysTxCsn, SyncBsn) FROM __syncTransactions st LEFT OUTER JOIN __sysTxCommitSequence ct ON st.SyncBsn = ct.__sysTxBsn))      OR ut0.__sysInsertTxCsn <= @LCSN) AND      ut0.__sysTName = 'Rastreo'   ) AS ut  LEFT OUTER JOIN     (select txcs0.* from __sysTxCommitSequence as txcs0) as txcs  ON ut.__sysDeleteTxBsn = txcs.__sysTxBsn WHERE    COALESCE(txcs.__sysTxCsn, ut.__sysDeleteTxBsn) > @LCSN AND COALESCE(txcs.__sysTxCsn, ut.__sysDeleteTxBsn) <= @ECSN
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:692,    Parameter: @LCSN Value: 378
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:692,    Parameter: @LBSN Value: 378
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:692,    Parameter: @ECSN Value: 386
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:692,    Parameter: @CNTX Value: 1efe839d-b5ab-41af-b9cc-144b3608155e
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:692,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:699,       Changes Enumerated: 0
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:699,    --- End Enumerating Deletes for Table Rastreo ---
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:699, **** Client Provider Commit Transaction ****
    INFO   , PresentationTier, 1, 04/21/2011 00:27:38:700, --- End Client Enumerating Changes to Server for Group "MovilAvanteCacheGlobalSyncGroup" ---
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:703, Connecting to CE database: C:\Program Files (x86)\New Millennium Systems\MovilAvante\MovilAvante\MovilAvante.sdf
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:712, **** Client Provider Begin Transaction ****
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:725, Rastreo: Set SentAnchor value: 386
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:38:779, **** Client Provider Commit Transaction ****
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:605, Connecting to CE database: C:\Program Files (x86)\New Millennium Systems\MovilAvante\MovilAvante\MovilAvante.sdf
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:625, **** Client Provider Begin Transaction ****
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:638, ----- Client Applying Changes from Server for Group "MovilAvanteCacheGlobalSyncGroup" -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:638,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:639,    ----- Applying Deletes for Table TiposDeViajes -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:678,       Deletes Applied: 0
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:678,    --- End Applying Deletes for Table TiposDeViajes -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:678,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:678,    ----- Applying Deletes for Table TiposDeServicios -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:703,       Deletes Applied: 0
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:704,    --- End Applying Deletes for Table TiposDeServicios -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:704,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:704,    ----- Applying Deletes for Table Socios -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:735,       Deletes Applied: 0
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:735,    --- End Applying Deletes for Table Socios -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:735,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:735,    ----- Applying Deletes for Table Empleados -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:761,       Deletes Applied: 0
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:761,    --- End Applying Deletes for Table Empleados -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:761,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:761,    ----- Applying Deletes for Table ClientesTiposDeServicios -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:776,       Deletes Applied: 0
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:776,    --- End Applying Deletes for Table ClientesTiposDeServicios -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:776,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:776,    ----- Applying Deletes for Table Clientes -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:791,       Deletes Applied: 0
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:791,    --- End Applying Deletes for Table Clientes -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:791,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:791,    ----- Applying Deletes for Table CamionesSocios -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:806,       Deletes Applied: 0
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:807,    --- End Applying Deletes for Table CamionesSocios -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:807,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:807,    ----- Applying Deletes for Table Camiones -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:829,       Deletes Applied: 0
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:829,    --- End Applying Deletes for Table Camiones -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:829,
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:829,    ----- Applying Upserts for Table Camiones -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:858,
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:858,    ----- Applying Inserts for Table Camiones -----
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:861,       Inserts Applied: 0
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:861,
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:861,    ----- Applying Updates for Table Camiones -----
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:865, Using Command:  UPDATE [Camiones] SET [Serie] = @P_530045005200490045000000, [Marca] = @P_4D0041005200430041000000, [Modelo] = @P_4D004F00440045004C004F000000, [Carroceria] = @P_43004100520052004F00430045005200490041000000, [Motor] = @P_4D004F0054004F0052000000, [Asientos] = @P_41005300490045004E0054004F0053000000, [CreationDate] = @P_4300520045004100540049004F004E0044004100540045000000, [LastEditDate] = @P_4C00410053005400450044004900540044004100540045000000 WHERE [UnidadID] = @P_55004E004900440041004400490044000000 AND (__sysTrackingContext = @CNTX OR __sysChangeTxBsn IS NULL        OR          (__sysChangeTxBsn in (select __sysTxBsn from __sysTxCommitSequence where __sysTxCsn <= @P_5F005F0053005900530041004E00430048004F0052000000                              )         )       OR          (__sysChangeTxBsn not in (select __sysTxBsn from __sysTxCommitSequence)               and           __sysChangeTxBsn <= @P_5F005F0053005900530041004E00430048004F0052000000         )     ) ;
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:866,    Parameter: @P_5F005F0053005900530041004E00430048004F0052000000 Value: 0
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:866,    Parameter: @CNTX Value: 1efe839d-b5ab-41af-b9cc-144b3608155e
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:866,    Parameter: @P_55004E004900440041004400490044000000 Len: 4 Value: 5187
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:866,    Parameter: @P_530045005200490045000000 Len: 17 Value: 1HVBDPLP5PH508467
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:866,    Parameter: @P_4D0041005200430041000000 Len: 13 Value: Internacional
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:866,    Parameter: @P_4D004F00440045004C004F000000 Value: 2011
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:866,    Parameter: @P_43004100520052004F00430045005200490041000000 Len: 20 Value: NULL
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:866,    Parameter: @P_4D004F0054004F0052000000 Value: 360
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:866,    Parameter: @P_41005300490045004E0054004F0053000000 Value: 47
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:878,    Parameter: @P_4300520045004100540049004F004E0044004100540045000000 Value: 3/8/2011 9:13:27 PM
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:879,    Parameter: @P_4C00410053005400450044004900540044004100540045000000 Value: 3/8/2011 9:13:27 PM
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:879,
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:889, Using Command:  UPDATE [Camiones] SET [Serie] = @P_530045005200490045000000, [Marca] = @P_4D0041005200430041000000, [Modelo] = @P_4D004F00440045004C004F000000, [Carroceria] = @P_43004100520052004F00430045005200490041000000, [Motor] = @P_4D004F0054004F0052000000, [Asientos] = @P_41005300490045004E0054004F0053000000, [CreationDate] = @P_4300520045004100540049004F004E0044004100540045000000, [LastEditDate] = @P_4C00410053005400450044004900540044004100540045000000 WHERE [UnidadID] = @P_55004E004900440041004400490044000000 AND (__sysTrackingContext = @CNTX OR __sysChangeTxBsn IS NULL        OR          (__sysChangeTxBsn in (select __sysTxBsn from __sysTxCommitSequence where __sysTxCsn <= @P_5F005F0053005900530041004E00430048004F0052000000                              )         )       OR          (__sysChangeTxBsn not in (select __sysTxBsn from __sysTxCommitSequence)               and           __sysChangeTxBsn <= @P_5F005F0053005900530041004E00430048004F0052000000         )     ) ;
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:890,    Parameter: @P_5F005F0053005900530041004E00430048004F0052000000 Value: 0
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:890,    Parameter: @CNTX Value: 1efe839d-b5ab-41af-b9cc-144b3608155e
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:890,    Parameter: @P_55004E004900440041004400490044000000 Len: 4 Value: 5195
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:890,    Parameter: @P_530045005200490045000000 Len: 17 Value: 1HVBAZRM8PH526429
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:890,    Parameter: @P_4D0041005200430041000000 Len: 13 Value: Internacional
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:890,    Parameter: @P_4D004F00440045004C004F000000 Value: 2011
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:890,    Parameter: @P_43004100520052004F00430045005200490041000000 Len: 20 Value: NULL
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:890,    Parameter: @P_4D004F0054004F0052000000 Value: 7.3
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:890,    Parameter: @P_41005300490045004E0054004F0053000000 Value: 28
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:890,    Parameter: @P_4300520045004100540049004F004E0044004100540045000000 Value: 3/8/2011 9:13:27 PM
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:890,    Parameter: @P_4C00410053005400450044004900540044004100540045000000 Value: 3/8/2011 9:13:27 PM
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:890,
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:892,       Updates Applied: 0
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:892,       Updates  Failed: 2
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:894,    --- End Applying Upserts for Table Camiones ---
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:894,
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:894,    ----- Applying Upserts for Table CamionesSocios -----
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:894,    --- End Applying Upserts for Table CamionesSocios ---
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:894,
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:894,    ----- Applying Upserts for Table Clientes -----
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:894,    --- End Applying Upserts for Table Clientes ---
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:894,
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:894,    ----- Applying Upserts for Table ClientesTiposDeServicios -----
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:894,    --- End Applying Upserts for Table ClientesTiposDeServicios ---
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:894,
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:894,    ----- Applying Upserts for Table Empleados -----
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:894,    --- End Applying Upserts for Table Empleados ---
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:894,
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:894,    ----- Applying Upserts for Table Socios -----
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:894,    --- End Applying Upserts for Table Socios ---
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:895,
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:895,    ----- Applying Upserts for Table TiposDeServicios -----
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:895,    --- End Applying Upserts for Table TiposDeServicios ---
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:895,
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:895,    ----- Applying Upserts for Table TiposDeViajes -----
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:895,    --- End Applying Upserts for Table TiposDeViajes ---
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:899, Camiones: Set ReceivedAnchor value: 713
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:902, CamionesSocios: Set ReceivedAnchor value: 713
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:906, Clientes: Set ReceivedAnchor value: 713
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:909, ClientesTiposDeServicios: Set ReceivedAnchor value: 713
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:911, Empleados: Set ReceivedAnchor value: 713
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:914, Socios: Set ReceivedAnchor value: 713
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:917, TiposDeServicios: Set ReceivedAnchor value: 713
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:920, TiposDeViajes: Set ReceivedAnchor value: 713
    INFO   , PresentationTier, 1, 04/21/2011 00:27:39:921, --- End Client Applying Changes from Server for Group "MovilAvanteCacheGlobalSyncGroup" ---
    VERBOSE, PresentationTier, 1, 04/21/2011 00:27:39:979, **** Client Provider Commit Transaction ****

     

     


    JD
    Thursday, April 21, 2011 12:45 AM
  • Hi,

    In your trace logs, the update TSQL script was executed but didn't succeed. Can you try to register ApplyChangeFailed event on client provider to see what error is returned in the Event?

    Thanks,
    Dong


    This posting is provided AS IS with no warranties, and confers no rights.
    Monday, April 25, 2011 7:12 PM
    Moderator
  • Hi Dong Cao:

    Can you please explain how to register the ApplyChangeFailed event to be read by the trace?

    Can you please provide an example?  Thank you

     


    JD
    Monday, April 25, 2011 11:13 PM
  • the ApplyChangeFailed event is raised in code when there's a conflict or an error applying the changes. Check out this link on how to handle conflicts or errors: http://msdn.microsoft.com/en-us/library/bb725997.aspx

     

    Tuesday, April 26, 2011 11:42 AM
    Moderator
  • Thanks this sorted it out for me :)

    Wednesday, May 23, 2012 4:07 PM