Answered by:
DbConnectionFailure Event is not firing?

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.
- Marked as answer by Jaliya UdagedaraMVP Wednesday, February 13, 2013 7:27 AM
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
- Edited by Jaliya UdagedaraMVP Tuesday, February 12, 2013 5:04 AM
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.
- Marked as answer by Jaliya UdagedaraMVP Wednesday, February 13, 2013 7:27 AM
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