[11:15:08.2319272] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72538340,"dt_importado":"2024-09-03T11:13:34.347","nom_cliente":"MARIA CLAUDIA CARDOSO DA SILVA","ddd":0,"num_telefone":0,"num_documento":"56856555253","dt_servico":"2024-09-03T11:13:34.347","nom_plano":"","SerialId":103569,"imei":null,"valor_aparelho":15.00,"val_entrada_dinh":15.00,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":null,"qtde_parc_1":null,"vl_cartao_credito_1":null,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"0.00","nom_tipo_negociacao":"","vl_pre_tabela":0.00,"dt_sellin":"2024-06-20T00:00:00","dt_sellout":"2024-09-03T11:14:50","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"15240911775328002573550010000043051012345207","num_dsf":"92471","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-09-03T11:14:56.28","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"218359","custcode_nivel_75":"RN90_MGPMPI_PT0001_A004","Serial_Acessorio":"","ICCID":"89550297000007358807","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_TELECEL_DF","tipo":"Venda","idpedido_origem":218359,"retorno_json":"[{\"cod_importacao\":72538340,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 1198) entrou em deadlock em bloquear | buffer de comunicação recursos com outro processo e foi escolhida como a vítima do deadlock. Execute a transação novamente. 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.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, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at wsCaixa.Banco.IntegracaoCaixaTim.SalvarDadosTimCentralizado(SqlConnection conn, SqlTransaction tran, DataRow dados, String stJsonEnvio, RetornoIntegracaoTim retorno) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:eef544bd-519b-4abb-a702-5f0ebf41e5e5 Error Number:1205,State:52,Class:13 [11:15:13.2033314] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72538341,"dt_importado":"2024-09-03T11:14:04.09","nom_cliente":"NATALYN ESTEFANY OLIVEIRA DA SILVA","ddd":32,"num_telefone":991469776,"num_documento":"70088754600","dt_servico":"2024-09-03T11:14:04.09","nom_plano":"TIM CONTROLE SMART 5.0","SerialId":52778,"imei":null,"valor_aparelho":0.01,"val_entrada_dinh":0.01,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":null,"qtde_parc_1":null,"vl_cartao_credito_1":null,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"0.00","nom_tipo_negociacao":"","vl_pre_tabela":0.00,"dt_sellin":"2024-07-24T00:00:00","dt_sellout":"2024-09-03T11:14:56","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"31240941910977000395550100000026421011547999","num_dsf":"13093","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-09-03T11:14:57.147","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"142303","custcode_nivel_75":"MX30_MXM32I_PT0945_VV01","Serial_Acessorio":"","ICCID":"89550320000432868421","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_DATAFOR_MG","tipo":"Venda","idpedido_origem":142303,"retorno_json":"[{\"cod_importacao\":72538341,\"imei\":null,\"num_telefone\":991469776,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 1358) entrou em deadlock em bloquear | buffer de comunicação recursos com outro processo e foi escolhida como a vítima do deadlock. Execute a transação novamente. 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.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, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at wsCaixa.Banco.IntegracaoCaixaTim.SalvarDadosTimCentralizado(SqlConnection conn, SqlTransaction tran, DataRow dados, String stJsonEnvio, RetornoIntegracaoTim retorno) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:d306e093-78c8-4846-8f69-809ef8048a1c Error Number:1205,State:52,Class:13 [11:54:06.0526305] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $762354 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 451 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:54:06.0576289] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $762360 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 451 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:54:06.0666364] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $762371 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 451 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:54:06.7793742] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $762363 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 451 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:54:22.1715443] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $762380 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 451 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:55:08.3226134] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $762374 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 451 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [12:00:16.7464883] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $762381 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 451 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [12:00:40.5204580] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $762242 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 451 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [12:00:46.8090865] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $762379 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 451 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [12:02:26.4326611] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $762327 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 451 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [12:07:37.7067452] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $762389 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 451 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [12:11:43.6536717] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72539096,"dt_importado":"2024-09-03T12:10:22.31","nom_cliente":"RICARDO ADAO DE MENEZES","ddd":0,"num_telefone":0,"num_documento":"22299003827","dt_servico":"2024-09-03T12:10:22.31","nom_plano":"","SerialId":74861,"imei":null,"valor_aparelho":15.00,"val_entrada_dinh":15.00,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":null,"qtde_parc_1":null,"vl_cartao_credito_1":null,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"0.00","nom_tipo_negociacao":"","vl_pre_tabela":0.00,"dt_sellin":"2024-07-16T00:00:00","dt_sellout":"2024-09-03T12:10:52","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"41240907531651000823650010000042771011843625","num_dsf":"90180","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-09-03T12:11:30.51","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"183176","custcode_nivel_75":"TS40_TSAGCI_TS0849_A008","Serial_Acessorio":"","ICCID":"89550447000025584292","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_TELEMILCELULARES_PR","tipo":"Venda","idpedido_origem":183176,"retorno_json":"[{\"cod_importacao\":72539096,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 1657) entrou em deadlock em bloquear | buffer de comunicação recursos com outro processo e foi escolhida como a vítima do deadlock. Execute a transação novamente. 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.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, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at wsCaixa.Banco.IntegracaoCaixaTim.SalvarDadosTimCentralizado(SqlConnection conn, SqlTransaction tran, DataRow dados, String stJsonEnvio, RetornoIntegracaoTim retorno) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:9ff5ccfd-c6bc-43ef-b40e-78edaf69eaa0 Error Number:1205,State:52,Class:13 [12:11:46.8540516] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72539093,"dt_importado":"2024-09-03T12:09:56.513","nom_cliente":"luiz carlos rossi filho","ddd":42,"num_telefone":999704818,"num_documento":"00750594950","dt_servico":"2024-09-03T12:09:56.513","nom_plano":"TIM BLACK MULTI A 6.0","SerialId":148930,"imei":357722593298274,"valor_aparelho":1299.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":603016,"qtde_parc_1":12,"vl_cartao_credito_1":1299.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"1700.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":2999.00,"dt_sellin":"2024-08-15T00:00:00","dt_sellout":"2024-09-03T12:11:24","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"41240920654202000750550010000190651012523732","num_dsf":"78761","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016284","dt_operacao":"2024-09-03T12:11:27.773","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"304414","custcode_nivel_75":"TS40_TSAGCI_RV0328_A002","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","database_name":"DTS39_TIM_LEMAR_PR","tipo":"Venda","idpedido_origem":304414,"retorno_json":"[{\"cod_importacao\":72539093,\"imei\":\"357722593298274\",\"num_telefone\":999704818,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 836) entrou em deadlock em bloquear | buffer de comunicação recursos com outro processo e foi escolhida como a vítima do deadlock. Execute a transação novamente. 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.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, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at wsCaixa.Banco.IntegracaoCaixaTim.SalvarDadosTimCentralizado(SqlConnection conn, SqlTransaction tran, DataRow dados, String stJsonEnvio, RetornoIntegracaoTim retorno) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:4f499a5e-4427-4888-8d36-7287fab9d762 Error Number:1205,State:52,Class:13 [16:29:36.2226599] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72542561,"dt_importado":"2024-09-03T16:25:45.86","nom_cliente":"CLAYTON PAZ DE SANT ANNA","ddd":35,"num_telefone":991540701,"num_documento":"08362970677","dt_servico":"2024-09-03T16:25:45.86","nom_plano":"TIM PRÉ TOP","SerialId":2623,"imei":null,"valor_aparelho":10.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":0,"qtde_parc_1":1,"vl_cartao_credito_1":10.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"0.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":0.00,"dt_sellin":"2024-05-07T00:00:00","dt_sellout":"2024-09-03T16:29:27","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"31240971170039000871550030000003101010051306","num_dsf":"98582","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-09-03T16:29:23.503","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"7763","custcode_nivel_75":"MX30_MXM32I_PT3844_A001","Serial_Acessorio":"","ICCID":"89550237001015570816","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_1000KOIZAS_MG","tipo":"Venda","idpedido_origem":7763,"retorno_json":"[{\"cod_importacao\":72542561,\"imei\":null,\"num_telefone\":991540701,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 409) entrou em deadlock em bloquear | buffer de comunicação recursos com outro processo e foi escolhida como a vítima do deadlock. Execute a transação novamente. 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.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, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at wsCaixa.Banco.IntegracaoCaixaTim.SalvarDadosTimCentralizado(SqlConnection conn, SqlTransaction tran, DataRow dados, String stJsonEnvio, RetornoIntegracaoTim retorno) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:375e5e45-dd02-4468-96c3-efa4b2d54e69 Error Number:1205,State:52,Class:13 [16:30:48.9615038] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72542588,"dt_importado":"2024-09-03T16:17:45.16","nom_cliente":"reginaldo antonio da silva","ddd":0,"num_telefone":0,"num_documento":"90553292820","dt_servico":"2024-09-03T16:17:45.16","nom_plano":"","SerialId":null,"imei":null,"valor_aparelho":150.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":0,"qtde_parc_1":3,"vl_cartao_credito_1":150.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"0.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":0.00,"dt_sellin":null,"dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"85161","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-09-03T16:30:33.943","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":150.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"372013","custcode_nivel_75":"SP10_MGVALI_RV0561_A004","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_NONIS_INFORMATICA_SP","tipo":"Venda","idpedido_origem":372013,"retorno_json":"[{\"cod_importacao\":72542588,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 1503) entrou em deadlock em bloquear | buffer de comunicação recursos com outro processo e foi escolhida como a vítima do deadlock. Execute a transação novamente. 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.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, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at wsCaixa.Banco.IntegracaoCaixaTim.SalvarDadosTimCentralizado(SqlConnection conn, SqlTransaction tran, DataRow dados, String stJsonEnvio, RetornoIntegracaoTim retorno) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:2723af79-9e61-4dba-ad2f-7b30c91602c4 Error Number:1205,State:52,Class:13 [17:22:25.8646425] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72543485,"dt_importado":"2024-09-03T17:21:12.473","nom_cliente":"EUGENIO MOLINARI","ddd":12,"num_telefone":982795550,"num_documento":"22937913865","dt_servico":"2024-09-03T17:21:12.473","nom_plano":"TIM BLACK DEPENDENTE","SerialId":617564,"imei":null,"valor_aparelho":0.01,"val_entrada_dinh":0.01,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":null,"qtde_parc_1":null,"vl_cartao_credito_1":null,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"0.00","nom_tipo_negociacao":"","vl_pre_tabela":0.00,"dt_sellin":"2024-08-13T00:00:00","dt_sellout":"2024-09-03T17:22:05","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"35240921683365002858550010000227461016325064","num_dsf":"85853","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-09-03T17:22:12.427","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"762875","custcode_nivel_75":"SP10_MGCAMI_PT2899_A018","Serial_Acessorio":"","ICCID":"89550327001052653385","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_ALEGRIATELECOM_SP","tipo":"Venda","idpedido_origem":762875,"retorno_json":"[{\"cod_importacao\":72543485,\"imei\":null,\"num_telefone\":982795550,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 1513) entrou em deadlock em bloquear | buffer de comunicação recursos com outro processo e foi escolhida como a vítima do deadlock. Execute a transação novamente. 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.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, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at wsCaixa.Banco.IntegracaoCaixaTim.SalvarDadosTimCentralizado(SqlConnection conn, SqlTransaction tran, DataRow dados, String stJsonEnvio, RetornoIntegracaoTim retorno) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:cd7eaa94-a364-47fc-9d55-d78753a87d9d Error Number:1205,State:52,Class:13 [17:22:31.6716422] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72543486,"dt_importado":"2024-09-03T17:21:16.127","nom_cliente":"BETO DOUGLAS NASCIMENTO DOS SANTOS","ddd":96,"num_telefone":981011608,"num_documento":"05683291208","dt_servico":"2024-09-03T17:21:16.127","nom_plano":"TIM CONTROLE A PLUS 6.0","SerialId":27472,"imei":null,"valor_aparelho":0.01,"val_entrada_dinh":0.01,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":null,"qtde_parc_1":null,"vl_cartao_credito_1":null,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"0.00","nom_tipo_negociacao":"","vl_pre_tabela":0.00,"dt_sellin":"2024-08-14T00:00:00","dt_sellout":"2024-09-03T17:21:58","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"16240923894662000239550010000043851011195044","num_dsf":"61713","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-09-03T17:22:13.49","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"98666","custcode_nivel_75":"RN90_MGPMPI_RV3114_A002","Serial_Acessorio":"","ICCID":"89550297000008413676","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_SOUZA_CELULAR_AP","tipo":"Venda","idpedido_origem":98666,"retorno_json":"[{\"cod_importacao\":72543486,\"imei\":null,\"num_telefone\":981011608,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 768) entrou em deadlock em bloquear | buffer de comunicação recursos com outro processo e foi escolhida como a vítima do deadlock. Execute a transação novamente. 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.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, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at wsCaixa.Banco.IntegracaoCaixaTim.SalvarDadosTimCentralizado(SqlConnection conn, SqlTransaction tran, DataRow dados, String stJsonEnvio, RetornoIntegracaoTim retorno) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:1cf6497f-5b7c-45d7-97ed-d2b7dc677232 Error Number:1205,State:52,Class:13