locked
DbConnectionFailure Event is not firing? RRS feed

  • Question

  • Hi All,

    While I am doing a download and having a local provider in my machine, I have stopped my SQL Server service. But still it does not trigger local providers' DbConnectionFailure Event. Any ideas please?

    Appreciate your help.

    Thanks.

    Happy Coding.

    Regards,

    Jaliya


    Jaliya Udagedara(MCPD) http://www.jaliyaudagedara.blogspot.com

    Tuesday, February 12, 2013 3:49 AM

Answers

  • looking inside the framework, it seems that DbConnectionFailure  is only going to get fired if ApplicationTransactionSize property is set.
    Wednesday, February 13, 2013 3:44 AM

All replies

  • the DbConnectionFailure fires when applying changes. are you sure you stopped your service just in time during change application?

    i suggest you enable sync framework tracing so you can have a look at the internal events happening.

    Tuesday, February 12, 2013 3:57 AM
  • Hi JuneT,

    Nice to see you back. Yeah, I have enabled tracing, the phase is changes are applying to my local provider. When I stopped my SQL Server service, application throws me an exception and the event DbConnectionFailure on local provider is not firing.


    Jaliya Udagedara(MCPD) http://www.jaliyaudagedara.blogspot.com

    Tuesday, February 12, 2013 4:31 AM
  • can you post the trace before the exception?
    Tuesday, February 12, 2013 4:46 AM
  • Here RetVNLive_PD is my local provider.

    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:390,    Inserting row with PK: COMPANY_CODE="PD" STORE_CODE="PD1" TERMINAL="012" TABLE_NAME="AUTH_FUNC_LOG" TRAN_DATE="27/02/2012 00:00:00"  on RetVNLive_PD
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:391,    Executing Command: [POSSTATUS_insert]
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:392,       Parameter: @P_1 Len: 2 Value: PD
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:393,       Parameter: @P_2 Len: 3 Value: PD1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:393,       Parameter: @P_3 Len: 3 Value: 012
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:394,       Parameter: @P_4 Len: 13 Value: AUTH_FUNC_LOG
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:395,       Parameter: @P_5 Value: 27/02/2012 00:00:00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:395,       Parameter: @P_6 Value: True
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:396,       Parameter: @P_7 Value: True
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:397,       Parameter: @P_8 Value: 0.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:397,       Parameter: @P_9 Value: 0.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:398,       Parameter: @P_10 Value: 0.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:399,       Parameter: @P_11 Value: 0.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:399,       Parameter: @P_12 Value: 0.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:400,       Parameter: @P_13 Value: 06/03/2012 10:18:43
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:401,       Parameter: @sync_row_count Value: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:416,    Rows affected: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:418,    Executing Command: [POSSTATUS_selectrow]
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:418,       Parameter: @P_1 Len: 2 Value: PD
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:419,       Parameter: @P_2 Len: 3 Value: PD1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:420,       Parameter: @P_3 Len: 3 Value: 012
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:420,       Parameter: @P_4 Len: 13 Value: AUTH_FUNC_LOG
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:421,       Parameter: @P_5 Value: 27/02/2012 00:00:00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:422,       Parameter: @sync_scope_local_id Value: 36
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:422,       Parameter: @sync_scope_restore_count Value: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:438, 
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:439,    RowId: posstatus-PD-PD1-012-AUTH_FUNC_LOG-27/02/2012 00:00:00 UV: 0,4822004 CV: 0,4822002 IsTomb: False
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:440,             Checking for conflict.
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:441,             Change cannot be applied. Returning Conflict.
    WARNING, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:442,          Exception: Insert Conflict detected
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:443,    Local UV: 0,4822004 CV: 0,4822002 IsTomb: False
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:443,          Raising Apply Change Failed Event
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:444,             Action: Continue
    INFO   , ExecuteSync.vshost, 10, 02/12/2013 04:59:31:445,          Local Wins, update metadata
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:446,             New local UpdateVersion: 0,4846001
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:446,    Executing Command: [POSSTATUS_updatemetadata]
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:447,       Parameter: @P_1 Len: 2 Value: PD
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:448,       Parameter: @P_2 Len: 3 Value: PD1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:449,       Parameter: @P_3 Len: 3 Value: 012
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:449,       Parameter: @P_4 Len: 13 Value: AUTH_FUNC_LOG
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:450,       Parameter: @P_5 Value: 27/02/2012 00:00:00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:450,       Parameter: @sync_scope_local_id Value: NULL
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:451,       Parameter: @sync_row_is_tombstone Value: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:452,       Parameter: @sync_create_peer_key Value: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:453,       Parameter: @sync_create_peer_timestamp Value: 4822002
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:453,       Parameter: @sync_update_peer_key Value: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:454,       Parameter: @sync_update_peer_timestamp Value: 4846001
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:454,       Parameter: @sync_check_concurrency Value: 1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:455,       Parameter: @sync_row_timestamp Value: 4822004
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:456,       Parameter: @sync_row_count Value: 1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:472,    Rows affected: 1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:475, 
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:476,    RowId: posstatus-PD-PD1-012-AUTH_FUNC_LOG-06/03/2012 00:00:00 UV: 1,1874247 CV: 1,1874244 IsTomb: False
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:476,    Inserting row with PK: COMPANY_CODE="PD" STORE_CODE="PD1" TERMINAL="012" TABLE_NAME="AUTH_FUNC_LOG" TRAN_DATE="06/03/2012 00:00:00"  on RetVNLive_PD
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:477,    Executing Command: [POSSTATUS_insert]
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:478,       Parameter: @P_1 Len: 2 Value: PD
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:478,       Parameter: @P_2 Len: 3 Value: PD1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:479,       Parameter: @P_3 Len: 3 Value: 012
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:480,       Parameter: @P_4 Len: 13 Value: AUTH_FUNC_LOG
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:480,       Parameter: @P_5 Value: 06/03/2012 00:00:00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:481,       Parameter: @P_6 Value: True
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:482,       Parameter: @P_7 Value: True
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:483,       Parameter: @P_8 Value: 8.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:483,       Parameter: @P_9 Value: 0.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:484,       Parameter: @P_10 Value: 0.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:485,       Parameter: @P_11 Value: 0.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:485,       Parameter: @P_12 Value: 0.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:486,       Parameter: @P_13 Value: 12/03/2012 11:26:04
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:487,       Parameter: @sync_row_count Value: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:502,    Rows affected: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:504,    Executing Command: [POSSTATUS_selectrow]
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:505,       Parameter: @P_1 Len: 2 Value: PD
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:505,       Parameter: @P_2 Len: 3 Value: PD1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:506,       Parameter: @P_3 Len: 3 Value: 012
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:507,       Parameter: @P_4 Len: 13 Value: AUTH_FUNC_LOG
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:508,       Parameter: @P_5 Value: 06/03/2012 00:00:00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:508,       Parameter: @sync_scope_local_id Value: 36
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:509,       Parameter: @sync_scope_restore_count Value: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:525, 
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:526,    RowId: posstatus-PD-PD1-012-AUTH_FUNC_LOG-06/03/2012 00:00:00 UV: 0,4822005 CV: 0,4822002 IsTomb: False
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:527,             Checking for conflict.
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:528,             Change cannot be applied. Returning Conflict.
    WARNING, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:529,          Exception: Insert Conflict detected
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:530,    Local UV: 0,4822005 CV: 0,4822002 IsTomb: False
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:531,          Raising Apply Change Failed Event
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:532,             Action: Continue
    INFO   , ExecuteSync.vshost, 10, 02/12/2013 04:59:31:532,          Local Wins, update metadata
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:533,             New local UpdateVersion: 0,4846001
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:534,    Executing Command: [POSSTATUS_updatemetadata]
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:534,       Parameter: @P_1 Len: 2 Value: PD
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:535,       Parameter: @P_2 Len: 3 Value: PD1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:536,       Parameter: @P_3 Len: 3 Value: 012
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:537,       Parameter: @P_4 Len: 13 Value: AUTH_FUNC_LOG
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:537,       Parameter: @P_5 Value: 06/03/2012 00:00:00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:538,       Parameter: @sync_scope_local_id Value: NULL
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:538,       Parameter: @sync_row_is_tombstone Value: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:539,       Parameter: @sync_create_peer_key Value: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:540,       Parameter: @sync_create_peer_timestamp Value: 4822002
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:540,       Parameter: @sync_update_peer_key Value: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:541,       Parameter: @sync_update_peer_timestamp Value: 4846001
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:542,       Parameter: @sync_check_concurrency Value: 1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:542,       Parameter: @sync_row_timestamp Value: 4822005
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:543,       Parameter: @sync_row_count Value: 1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:560,    Rows affected: 1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:562, 
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:563,    RowId: posstatus-PD-PD1-012-AUTH_FUNC_LOG-12/03/2012 00:00:00 UV: 1,1874248 CV: 1,1874244 IsTomb: False
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:564,    Inserting row with PK: COMPANY_CODE="PD" STORE_CODE="PD1" TERMINAL="012" TABLE_NAME="AUTH_FUNC_LOG" TRAN_DATE="12/03/2012 00:00:00"  on RetVNLive_PD
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:565,    Executing Command: [POSSTATUS_insert]
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:565,       Parameter: @P_1 Len: 2 Value: PD
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:566,       Parameter: @P_2 Len: 3 Value: PD1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:567,       Parameter: @P_3 Len: 3 Value: 012
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:567,       Parameter: @P_4 Len: 13 Value: AUTH_FUNC_LOG
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:568,       Parameter: @P_5 Value: 12/03/2012 00:00:00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:569,       Parameter: @P_6 Value: True
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:569,       Parameter: @P_7 Value: True
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:570,       Parameter: @P_8 Value: 4.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:571,       Parameter: @P_9 Value: 0.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:571,       Parameter: @P_10 Value: 0.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:572,       Parameter: @P_11 Value: 0.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:573,       Parameter: @P_12 Value: 0.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:573,       Parameter: @P_13 Value: 15/03/2012 21:36:04
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:574,       Parameter: @sync_row_count Value: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:590,    Rows affected: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:592,    Executing Command: [POSSTATUS_selectrow]
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:592,       Parameter: @P_1 Len: 2 Value: PD
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:593,       Parameter: @P_2 Len: 3 Value: PD1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:594,       Parameter: @P_3 Len: 3 Value: 012
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:595,       Parameter: @P_4 Len: 13 Value: AUTH_FUNC_LOG
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:595,       Parameter: @P_5 Value: 12/03/2012 00:00:00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:596,       Parameter: @sync_scope_local_id Value: 36
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:597,       Parameter: @sync_scope_restore_count Value: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:612, 
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:614,    RowId: posstatus-PD-PD1-012-AUTH_FUNC_LOG-12/03/2012 00:00:00 UV: 0,4822006 CV: 0,4822002 IsTomb: False
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:614,             Checking for conflict.
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:615,             Change cannot be applied. Returning Conflict.
    WARNING, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:616,          Exception: Insert Conflict detected
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:617,    Local UV: 0,4822006 CV: 0,4822002 IsTomb: False
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:618,          Raising Apply Change Failed Event
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:619,             Action: Continue
    INFO   , ExecuteSync.vshost, 10, 02/12/2013 04:59:31:620,          Local Wins, update metadata
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:621,             New local UpdateVersion: 0,4846001
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:622,    Executing Command: [POSSTATUS_updatemetadata]
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:623,       Parameter: @P_1 Len: 2 Value: PD
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:624,       Parameter: @P_2 Len: 3 Value: PD1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:625,       Parameter: @P_3 Len: 3 Value: 012
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:626,       Parameter: @P_4 Len: 13 Value: AUTH_FUNC_LOG
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:627,       Parameter: @P_5 Value: 12/03/2012 00:00:00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:628,       Parameter: @sync_scope_local_id Value: NULL
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:629,       Parameter: @sync_row_is_tombstone Value: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:629,       Parameter: @sync_create_peer_key Value: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:630,       Parameter: @sync_create_peer_timestamp Value: 4822002
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:631,       Parameter: @sync_update_peer_key Value: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:632,       Parameter: @sync_update_peer_timestamp Value: 4846001
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:632,       Parameter: @sync_check_concurrency Value: 1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:633,       Parameter: @sync_row_timestamp Value: 4822006
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:634,       Parameter: @sync_row_count Value: 1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:650,    Rows affected: 1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:653, 
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:653,    RowId: posstatus-PD-PD1-012-AUTH_FUNC_LOG-15/03/2012 00:00:00 UV: 1,1874249 CV: 1,1874244 IsTomb: False
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:654,    Inserting row with PK: COMPANY_CODE="PD" STORE_CODE="PD1" TERMINAL="012" TABLE_NAME="AUTH_FUNC_LOG" TRAN_DATE="15/03/2012 00:00:00"  on RetVNLive_PD
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:655,    Executing Command: [POSSTATUS_insert]
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:656,       Parameter: @P_1 Len: 2 Value: PD
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:657,       Parameter: @P_2 Len: 3 Value: PD1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:657,       Parameter: @P_3 Len: 3 Value: 012
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:658,       Parameter: @P_4 Len: 13 Value: AUTH_FUNC_LOG
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:659,       Parameter: @P_5 Value: 15/03/2012 00:00:00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:659,       Parameter: @P_6 Value: True
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:660,       Parameter: @P_7 Value: True
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:661,       Parameter: @P_8 Value: 6.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:661,       Parameter: @P_9 Value: 0.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:662,       Parameter: @P_10 Value: 0.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:663,       Parameter: @P_11 Value: 0.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:664,       Parameter: @P_12 Value: 0.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:664,       Parameter: @P_13 Value: 19/03/2012 13:03:35
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:665,       Parameter: @sync_row_count Value: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:681,    Rows affected: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:682,    Executing Command: [POSSTATUS_selectrow]
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:683,       Parameter: @P_1 Len: 2 Value: PD
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:684,       Parameter: @P_2 Len: 3 Value: PD1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:684,       Parameter: @P_3 Len: 3 Value: 012
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:685,       Parameter: @P_4 Len: 13 Value: AUTH_FUNC_LOG
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:686,       Parameter: @P_5 Value: 15/03/2012 00:00:00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:687,       Parameter: @sync_scope_local_id Value: 36
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:687,       Parameter: @sync_scope_restore_count Value: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:703, 
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:705,    RowId: posstatus-PD-PD1-012-AUTH_FUNC_LOG-15/03/2012 00:00:00 UV: 0,4822007 CV: 0,4822002 IsTomb: False
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:705,             Checking for conflict.
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:706,             Change cannot be applied. Returning Conflict.
    WARNING, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:707,          Exception: Insert Conflict detected
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:708,    Local UV: 0,4822007 CV: 0,4822002 IsTomb: False
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:709,          Raising Apply Change Failed Event
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:710,             Action: Continue
    INFO   , ExecuteSync.vshost, 10, 02/12/2013 04:59:31:711,          Local Wins, update metadata
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:712,             New local UpdateVersion: 0,4846001
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:712,    Executing Command: [POSSTATUS_updatemetadata]
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:713,       Parameter: @P_1 Len: 2 Value: PD
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:714,       Parameter: @P_2 Len: 3 Value: PD1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:714,       Parameter: @P_3 Len: 3 Value: 012
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:715,       Parameter: @P_4 Len: 13 Value: AUTH_FUNC_LOG
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:716,       Parameter: @P_5 Value: 15/03/2012 00:00:00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:717,       Parameter: @sync_scope_local_id Value: NULL
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:717,       Parameter: @sync_row_is_tombstone Value: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:718,       Parameter: @sync_create_peer_key Value: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:719,       Parameter: @sync_create_peer_timestamp Value: 4822002
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:719,       Parameter: @sync_update_peer_key Value: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:720,       Parameter: @sync_update_peer_timestamp Value: 4846001
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:721,       Parameter: @sync_check_concurrency Value: 1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:721,       Parameter: @sync_row_timestamp Value: 4822007
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:722,       Parameter: @sync_row_count Value: 1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:739,    Rows affected: 1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:742, 
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:743,    RowId: posstatus-PD-PD1-012-AUTH_FUNC_LOG-19/03/2012 00:00:00 UV: 1,1874250 CV: 1,1874244 IsTomb: False
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:744,    Inserting row with PK: COMPANY_CODE="PD" STORE_CODE="PD1" TERMINAL="012" TABLE_NAME="AUTH_FUNC_LOG" TRAN_DATE="19/03/2012 00:00:00"  on RetVNLive_PD
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:745,    Executing Command: [POSSTATUS_insert]
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:746,       Parameter: @P_1 Len: 2 Value: PD
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:746,       Parameter: @P_2 Len: 3 Value: PD1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:747,       Parameter: @P_3 Len: 3 Value: 012
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:748,       Parameter: @P_4 Len: 13 Value: AUTH_FUNC_LOG
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:748,       Parameter: @P_5 Value: 19/03/2012 00:00:00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:749,       Parameter: @P_6 Value: True
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:750,       Parameter: @P_7 Value: True
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:751,       Parameter: @P_8 Value: 8.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:752,       Parameter: @P_9 Value: 0.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:752,       Parameter: @P_10 Value: 0.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:753,       Parameter: @P_11 Value: 0.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:754,       Parameter: @P_12 Value: 0.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:755,       Parameter: @P_13 Value: 23/03/2012 11:17:56
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:756,       Parameter: @sync_row_count Value: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:772,    Rows affected: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:773,    Executing Command: [POSSTATUS_selectrow]
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:774,       Parameter: @P_1 Len: 2 Value: PD
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:774,       Parameter: @P_2 Len: 3 Value: PD1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:775,       Parameter: @P_3 Len: 3 Value: 012
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:776,       Parameter: @P_4 Len: 13 Value: AUTH_FUNC_LOG
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:776,       Parameter: @P_5 Value: 19/03/2012 00:00:00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:777,       Parameter: @sync_scope_local_id Value: 36
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:778,       Parameter: @sync_scope_restore_count Value: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:794, 
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:795,    RowId: posstatus-PD-PD1-012-AUTH_FUNC_LOG-19/03/2012 00:00:00 UV: 0,4822008 CV: 0,4822002 IsTomb: False
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:795,             Checking for conflict.
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:796,             Change cannot be applied. Returning Conflict.
    WARNING, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:797,          Exception: Insert Conflict detected
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:798,    Local UV: 0,4822008 CV: 0,4822002 IsTomb: False
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:799,          Raising Apply Change Failed Event
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:800,             Action: Continue
    INFO   , ExecuteSync.vshost, 10, 02/12/2013 04:59:31:800,          Local Wins, update metadata
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:801,             New local UpdateVersion: 0,4846001
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:802,    Executing Command: [POSSTATUS_updatemetadata]
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:803,       Parameter: @P_1 Len: 2 Value: PD
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:803,       Parameter: @P_2 Len: 3 Value: PD1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:804,       Parameter: @P_3 Len: 3 Value: 012
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:805,       Parameter: @P_4 Len: 13 Value: AUTH_FUNC_LOG
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:805,       Parameter: @P_5 Value: 19/03/2012 00:00:00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:806,       Parameter: @sync_scope_local_id Value: NULL
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:807,       Parameter: @sync_row_is_tombstone Value: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:807,       Parameter: @sync_create_peer_key Value: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:808,       Parameter: @sync_create_peer_timestamp Value: 4822002
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:809,       Parameter: @sync_update_peer_key Value: 0
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:810,       Parameter: @sync_update_peer_timestamp Value: 4846001
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:810,       Parameter: @sync_check_concurrency Value: 1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:811,       Parameter: @sync_row_timestamp Value: 4822008
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:811,       Parameter: @sync_row_count Value: 1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:828,    Rows affected: 1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:831, 
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:832,    RowId: posstatus-PD-PD1-012-AUTH_FUNC_LOG-23/03/2012 00:00:00 UV: 1,1874251 CV: 1,1874244 IsTomb: False
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:833,    Inserting row with PK: COMPANY_CODE="PD" STORE_CODE="PD1" TERMINAL="012" TABLE_NAME="AUTH_FUNC_LOG" TRAN_DATE="23/03/2012 00:00:00"  on RetVNLive_PD
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:833,    Executing Command: [POSSTATUS_insert]
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:834,       Parameter: @P_1 Len: 2 Value: PD
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:835,       Parameter: @P_2 Len: 3 Value: PD1
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:835,       Parameter: @P_3 Len: 3 Value: 012
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:836,       Parameter: @P_4 Len: 13 Value: AUTH_FUNC_LOG
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:837,       Parameter: @P_5 Value: 23/03/2012 00:00:00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:837,       Parameter: @P_6 Value: True
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:838,       Parameter: @P_7 Value: True
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:839,       Parameter: @P_8 Value: 2.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:840,       Parameter: @P_9 Value: 0.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:840,       Parameter: @P_10 Value: 0.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:841,       Parameter: @P_11 Value: 0.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:842,       Parameter: @P_12 Value: 0.00
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:843,       Parameter: @P_13 Value: 26/03/2012 11:07:50
    VERBOSE, ExecuteSync.vshost, 10, 02/12/2013 04:59:31:844,       Parameter: @sync_row_count Value: 0
    ERROR  , ExecuteSync.vshost, 10, 02/12/2013 04:59:32:141, Error during InsertCommand: System.Data.SqlClient.SqlException (0x80131904): A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.) ---> System.ComponentModel.Win32Exception (0x80004005): The pipe has been ended
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
       at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
       at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
       at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
       at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.Synchronization.Data.DbChangeHandler.ExecuteCommandReturnRowcount(IDbCommand command, Boolean& found)
       at Microsoft.Synchronization.Data.DbChangeHandler.ExecuteChangeApplicationCommandBase(IDbCommand command, SyncRowMetadata rowMetadata, String commandName)
    ClientConnectionId:cf066bb1-130f-4252-b51f-44c2b72e1008
    ERROR  , ExecuteSync.vshost, 10, 02/12/2013 04:59:32:144, Transaction has exited due to command execution failure, throwing exception
    ERROR  , ExecuteSync.vshost, 10, 02/12/2013 04:59:32:181, Caught exception while applying changes: Microsoft.Synchronization.Data.DbSyncException: Failed to execute the command 'InsertCommand' for table 'POSSTATUS'; the transaction was rolled back. Ensure that the command syntax is correct. ---> System.Data.SqlClient.SqlException: A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.) ---> System.ComponentModel.Win32Exception: The pipe has been ended
       --- End of inner exception stack trace ---
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
       at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
       at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
       at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
       at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.Synchronization.Data.DbChangeHandler.ExecuteCommandReturnRowcount(IDbCommand command, Boolean& found)
       at Microsoft.Synchronization.Data.DbChangeHandler.ExecuteChangeApplicationCommandBase(IDbCommand command, SyncRowMetadata rowMetadata, String commandName)
       --- End of inner exception stack trace ---
       at Microsoft.Synchronization.Data.ChangeHandlerBase.CheckZombieTransaction(String commandName, String table, Exception ex)
       at Microsoft.Synchronization.Data.ChangeHandlerBase.ExecuteChangeApplicationCommandInternal(IDbCommand command, SyncRowMetadata rowMetadata, String commandName)
       at Microsoft.Synchronization.Data.DbChangeHandler.ApplyInsert()
       at Microsoft.Synchronization.Data.ChangeHandlerBase.ApplyChange(FailedDeleteDelegate_type failedDeleteDelegate)
       at Microsoft.Synchronization.Data.RelationalSyncProvider.ApplyChangesInternal(DbSyncScopeMetadata scopeMetadata, IDbTransaction transaction, FailedDeleteDelegate_type failedDeleteDelegate, DataSet dataSet, ChangeApplicationType applyType)
       at Microsoft.Synchronization.Data.RelationalSyncProvider.ApplyChanges(DbSyncScopeMetadata scopeMetadata, IDbTransaction applyTransaction, DataSet dataSet, DbSyncSession DbSyncSession, Boolean commitTransaction, FailedDeleteDelegate_type failedDeleteDelegate, String batchFileName, ChangeApplicationAction& action)
    ERROR  , ExecuteSync.vshost, 10, 02/12/2013 04:59:32:214, Rolling back application transaction.
    INFO   , ExecuteSync.vshost, 10, 02/12/2013 04:59:32:252,    EndSession() called on Provider SqlSyncProvider, Microsoft.Synchronization.Data.SqlServer, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
    INFO   , ExecuteSync.vshost, 10, 02/12/2013 04:59:32:255,    EndSession() called on Provider SqlSyncProvider, Microsoft.Synchronization.Data.SqlServer, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91

    Tuesday, February 12, 2013 5:01 AM
  • looking inside the framework, it seems that DbConnectionFailure  is only going to get fired if ApplicationTransactionSize property is set.
    Wednesday, February 13, 2013 3:44 AM
  • Hi JuneT,

    Thanks.

    Happy Coding.

    Regards,

    Jaliya


    Jaliya Udagedara(MCPD) http://www.jaliyaudagedara.blogspot.com

    Wednesday, February 13, 2013 7:27 AM