[08:30:03.3813210] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72641326,"dt_importado":"2024-09-10T10:46:22.737","nom_cliente":"ELIZABETE FERREIRA BRAGA","ddd":44,"num_telefone":988688526,"num_documento":"04268630970","dt_servico":"2024-09-10T10:46:22.737","nom_plano":"TIM CONTROLE SMART 6.0","SerialId":146112,"imei":null,"valor_aparelho":10.00,"val_entrada_dinh":10.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-08T00:00:00","dt_sellout":"2024-09-11T08:29:54","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"41240920654202001993550010000020861012537630","num_dsf":"95096","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-09-11T08:29:47.497","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"306203","custcode_nivel_75":"TS40_TSAGCI_RV0328_A015","Serial_Acessorio":"","ICCID":"89550447000025189282","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_LEMAR_PR","tipo":"Venda","idpedido_origem":306203,"retorno_json":"[{\"cod_importacao\":72641326,\"imei\":null,\"num_telefone\":988688526,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 529) 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:67eb6900-79c2-4262-bc50-736351329d5e Error Number:1205,State:52,Class:13 [08:30:24.2478522] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72641405,"dt_importado":"2024-09-11T08:25:21.727","nom_cliente":"JEFFERSON POZZA PACHECO","ddd":49,"num_telefone":999006160,"num_documento":"09575953959","dt_servico":"2024-09-11T08:25:21.727","nom_plano":"TIM BLACK MULTI D 6.0","SerialId":46676,"imei":356323451621615,"valor_aparelho":2899.00,"val_entrada_dinh":2899.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":"3400.00","nom_tipo_negociacao":"","vl_pre_tabela":6299.00,"dt_sellin":"2024-08-20T00:00:00","dt_sellout":"2024-09-11T08:30:10","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"42240906198067000169650010000054621011153110","num_dsf":"14788","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04014833","dt_operacao":"2024-09-11T08:30:07.52","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"104828","custcode_nivel_75":"TS40_TSAGCI_TS0700_A001","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","database_name":"DTS39_TIM_ZATTACELULARES_SC","tipo":"Venda","idpedido_origem":104828,"retorno_json":"[{\"cod_importacao\":72641405,\"imei\":\"356323451621615\",\"num_telefone\":999006160,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 529) 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:67eb6900-79c2-4262-bc50-736351329d5e Error Number:1205,State:52,Class:13 [08:38:25.2855027] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72643120,"dt_importado":"2024-09-09T10:50:49.097","nom_cliente":"MARIA REGINA RAMO DA SILVA","ddd":81,"num_telefone":983674229,"num_documento":"11331355443","dt_servico":"2024-09-09T10:50:49.097","nom_plano":"TIM CONTROLE SMART 6.0","SerialId":625914,"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-26T00:00:00","dt_sellout":"2024-09-11T08:38:04","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"26240921683365005105550020000133721016368187","num_dsf":"96135","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-09-11T08:38:11.65","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"767478","custcode_nivel_75":"NE80_NEN04I_NE0761_NE002","Serial_Acessorio":"","ICCID":"89550287000015842737","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_ALEGRIATELECOM_SP","tipo":"Venda","idpedido_origem":767478,"retorno_json":"[{\"cod_importacao\":72643120,\"imei\":null,\"num_telefone\":983674229,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 872) 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:58ea4262-1c05-43f3-a97c-897ae9ed6474 Error Number:1205,State:52,Class:13 [08:40:03.4753931] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72643366,"dt_importado":"2024-09-09T17:24:40.76","nom_cliente":"LIDIA DA SILVA SANTOS DE LIRA","ddd":81,"num_telefone":997108945,"num_documento":"39477789453","dt_servico":"2024-09-09T17:24:40.76","nom_plano":"TIM CONTROLE A PLUS 6.0","SerialId":625980,"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-26T00:00:00","dt_sellout":"2024-09-11T08:39:48","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"26240921683365005105550020000133741016373665","num_dsf":"96135","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-09-11T08:39:49.243","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"768195","custcode_nivel_75":"NE80_NEN04I_NE0761_NE002","Serial_Acessorio":"","ICCID":"89550287000015843396","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_ALEGRIATELECOM_SP","tipo":"Venda","idpedido_origem":768195,"retorno_json":"[{\"cod_importacao\":72643366,\"imei\":null,\"num_telefone\":997108945,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 872) 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:58ea4262-1c05-43f3-a97c-897ae9ed6474 Error Number:1205,State:52,Class:13 [08:41:16.1359257] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72643528,"dt_importado":"2024-09-09T18:43:32.65","nom_cliente":"WAGNER NASCIMENTO DE LIMA","ddd":81,"num_telefone":987072398,"num_documento":"03802497406","dt_servico":"2024-09-09T18:43:32.65","nom_plano":"TIM PRÉ TOP","SerialId":625973,"imei":null,"valor_aparelho":10.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":10.00,"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-26T00:00:00","dt_sellout":"2024-09-11T08:40:58","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"26240921683365005105550020000133761016375050","num_dsf":"96135","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-09-11T08:41:01.497","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"768335","custcode_nivel_75":"NE80_NEN04I_NE0761_NE002","Serial_Acessorio":"","ICCID":"89550287000015843321","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_ALEGRIATELECOM_SP","tipo":"Venda","idpedido_origem":768335,"retorno_json":"[{\"cod_importacao\":72643528,\"imei\":null,\"num_telefone\":987072398,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 872) 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:58ea4262-1c05-43f3-a97c-897ae9ed6474 Error Number:1205,State:52,Class:13 [08:42:54.4337240] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72643853,"dt_importado":"2024-09-10T10:59:58.93","nom_cliente":"ZELIO FIDELIS DE MELO","ddd":0,"num_telefone":0,"num_documento":"24435430487","dt_servico":"2024-09-10T10:59:58.93","nom_plano":"","SerialId":625964,"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-08-26T00:00:00","dt_sellout":"2024-09-11T08:42:41","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"26240921683365005105550020000133791016378035","num_dsf":"96135","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-09-11T08:42:38.753","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"768676","custcode_nivel_75":"NE80_NEN04I_NE0761_NE002","Serial_Acessorio":"","ICCID":"89550287000015843230","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_ALEGRIATELECOM_SP","tipo":"Venda","idpedido_origem":768676,"retorno_json":"[{\"cod_importacao\":72643853,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 872) 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:9130243b-f8d2-4482-83c6-6e7a1f434fce Error Number:1205,State:52,Class:13 [09:31:03.5167544] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72646508,"dt_importado":"2024-09-11T09:29:37.477","nom_cliente":"JOSE ALTAMIRO MASSANEIRO","ddd":47,"num_telefone":999588082,"num_documento":"31067506934","dt_servico":"2024-09-11T09:29:37.477","nom_plano":"TIM CONTROLE SMART 6.0","SerialId":85136,"imei":null,"valor_aparelho":10.00,"val_entrada_dinh":10.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-25T00:00:00","dt_sellout":"2024-09-11T09:30:41","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"42240923106562000209650010000076271012139899","num_dsf":"73702","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-09-11T09:30:32.87","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"213212","custcode_nivel_75":"TS40_TSAGCI_RV0930_A001","Serial_Acessorio":"","ICCID":"89550447000024563719","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_SBSCELULARES_SC","tipo":"Venda","idpedido_origem":213212,"retorno_json":"[{\"cod_importacao\":72646508,\"imei\":null,\"num_telefone\":999588082,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 739) 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:b414abe0-67ec-4b6a-956b-f72278375ccb Error Number:1205,State:52,Class:13 [09:31:03.7511172] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72646513,"dt_importado":"2024-09-11T09:29:18.507","nom_cliente":"CELIO GOMES DA SILVA","ddd":0,"num_telefone":0,"num_documento":"02914720602","dt_servico":"2024-09-11T09:29:18.507","nom_plano":"","SerialId":4122,"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-08-09T00:00:00","dt_sellout":"2024-09-11T09:30:46","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"31240908745387000117650030000027931010825983","num_dsf":"30636","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-09-11T09:30:38.957","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"82515","custcode_nivel_75":"MX30_MXM35I_RV2626_VV01","Serial_Acessorio":"","ICCID":"89550237001016973704","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_SKYCELL_MG","tipo":"Venda","idpedido_origem":82515,"retorno_json":"[{\"cod_importacao\":72646513,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 741) 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:f9a10936-b3e1-4c6b-b5c0-595a739c7911 Error Number:1205,State:52,Class:13 [09:35:14.7331318] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72646908,"dt_importado":"2024-09-11T09:33:50.613","nom_cliente":"ELIANA SOARES DA SILVA","ddd":31,"num_telefone":990773396,"num_documento":"06016870609","dt_servico":"2024-09-11T09:33:50.613","nom_plano":"TIM CONTROLE REDES SOCIAIS 6.0","SerialId":1580,"imei":null,"valor_aparelho":10.00,"val_entrada_dinh":10.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-08-06T00:00:00","dt_sellout":"2024-09-11T09:34:36","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"31240907778539000115650080000013531010315009","num_dsf":"90489","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-09-11T09:34:31.127","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"21375","custcode_nivel_75":"MX30_MXM31I_RV5295_A001","Serial_Acessorio":"","ICCID":"89550237001016737349","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_REIDOCELULAR_MG","tipo":"Venda","idpedido_origem":21375,"retorno_json":"[{\"cod_importacao\":72646908,\"imei\":null,\"num_telefone\":990773396,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 2059) 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:e0306499-2ad0-4ea6-8a02-7e4a9f80c65c Error Number:1205,State:52,Class:13 [09:36:14.5880974] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72647061,"dt_importado":"2024-09-11T09:32:16.797","nom_cliente":"Rubens Toledo da silva","ddd":96,"num_telefone":981019550,"num_documento":"98387987115","dt_servico":"2024-09-11T09:32:16.797","nom_plano":"TIM BLACK C HERO 6.0","SerialId":97392,"imei":357722594068817,"valor_aparelho":1699.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":477591,"qtde_parc_1":10,"vl_cartao_credito_1":1699.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"1300.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":2999.00,"dt_sellin":"2024-08-16T00:00:00","dt_sellout":"2024-09-11T09:35:42","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"16240902254271000441550000000061291012257435","num_dsf":"90968","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016285","dt_operacao":"2024-09-11T09:35:37.54","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"213780","custcode_nivel_75":"RN90_MGPMPI_PT0087_A012","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","database_name":"DTS39_TIM_SALINASSAR_AP","tipo":"Venda","idpedido_origem":213780,"retorno_json":"[{\"cod_importacao\":72647061,\"imei\":\"357722594068817\",\"num_telefone\":981019550,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 1234) 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:0f298097-59b2-4120-9639-9ba4e8488837 Error Number:1205,State:52,Class:13 [09:36:34.0436354] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72647115,"dt_importado":"2024-09-11T09:35:25.96","nom_cliente":"JOSE FRANCISCO CARDOSO","ddd":53,"num_telefone":984587541,"num_documento":"32231059053","dt_servico":"2024-09-11T09:35:25.96","nom_plano":"TIM CONTROLE A PLUS 6.0","SerialId":241187,"imei":null,"valor_aparelho":10.00,"val_entrada_dinh":10.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-08-20T00:00:00","dt_sellout":"2024-09-11T09:35:55","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"43240902455036008927650010000095331013035070","num_dsf":"91760","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-09-11T09:35:47.59","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"337480","custcode_nivel_75":"CS50_MGPOAI_PT0105_A007","Serial_Acessorio":"","ICCID":"89550457000007295427","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_MASTERCELLCOMERCIO_SC","tipo":"Venda","idpedido_origem":337480,"retorno_json":"[{\"cod_importacao\":72647115,\"imei\":null,\"num_telefone\":984587541,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 943) 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:0db39f89-6bb1-4d47-81c6-b061afb20417 Error Number:1205,State:52,Class:13 [09:36:34.1373834] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72647052,"dt_importado":"2024-09-11T09:32:30.713","nom_cliente":"PREFEITURA MUNICIPAL DA SERRA","ddd":0,"num_telefone":0,"num_documento":"27174093000127","dt_servico":"2024-09-11T09:32:30.713","nom_plano":"","SerialId":null,"imei":null,"valor_aparelho":30.00,"val_entrada_dinh":null,"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":null,"dt_sellout":"2024-09-11T09:35:27","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"32240918712924000186550010000020621000078179","num_dsf":"49053","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-09-11T09:35:24.537","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":30.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"136462","custcode_nivel_75":"RN20_MGESSI_RV3050_A001","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_TOPVIXCELULARES","tipo":"Venda","idpedido_origem":136462,"retorno_json":"[{\"cod_importacao\":72647052,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 2059) 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:e0306499-2ad0-4ea6-8a02-7e4a9f80c65c Error Number:1205,State:52,Class:13 [09:37:17.9570241] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72647181,"dt_importado":"2024-09-11T09:33:35.92","nom_cliente":"LUCIANA CARNEIRO VIEIRA","ddd":31,"num_telefone":982980287,"num_documento":"05585028650","dt_servico":"2024-09-11T09:33:35.92","nom_plano":"TIM CONTROLE SMART 6.0","SerialId":102625,"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-22T00:00:00","dt_sellout":"2024-09-11T09:37:02","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"31240903372209001499650010000102061011962520","num_dsf":"87858","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-09-11T09:36:53.9","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"180096","custcode_nivel_75":"MX30_MXM31I_PT4892_A001","Serial_Acessorio":"","ICCID":"89550237001015757470","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_JMXTELECOM_MG","tipo":"Venda","idpedido_origem":180096,"retorno_json":"[{\"cod_importacao\":72647181,\"imei\":null,\"num_telefone\":982980287,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 893) 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:c84d4613-4d06-4db9-8d87-0f207e06200b Error Number:1205,State:52,Class:13 [09:43:57.9310256] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72648088,"dt_importado":"2024-09-11T09:41:50.857","nom_cliente":"salvador soares","ddd":71,"num_telefone":992410214,"num_documento":"05320747500","dt_servico":"2024-09-11T09:41:50.857","nom_plano":"TIM CONTROLE SMART 6.0","SerialId":631588,"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-07T00:00:00","dt_sellout":"2024-09-11T09:43:39","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"29240907366109002482650010000383861012539390","num_dsf":"85597","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-09-11T09:43:34.767","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"650483","custcode_nivel_75":"MX30_MXBAHI_PT0001_A002","Serial_Acessorio":"","ICCID":"89550277000007904885","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_FACELL_RN","tipo":"Venda","idpedido_origem":650483,"retorno_json":"[{\"cod_importacao\":72648088,\"imei\":null,\"num_telefone\":992410214,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 846) 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:ee117227-15fb-4af5-b5fe-58603e4a193a Error Number:1205,State:52,Class:13 [09:56:25.4291123] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72649686,"dt_importado":"2024-09-11T09:54:49.463","nom_cliente":"NICACIO OLIVEIRA CARNEIRO","ddd":0,"num_telefone":0,"num_documento":"02736564570","dt_servico":"2024-09-11T09:54:49.463","nom_plano":"","SerialId":588200,"imei":null,"valor_aparelho":15.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":641544,"qtde_parc_1":1,"vl_cartao_credito_1":15.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-29T00:00:00","dt_sellout":"2024-09-11T09:56:00","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"29240907366109002563650010000210001012539418","num_dsf":"85599","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-09-11T09:55:54.42","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"650487","custcode_nivel_75":"MX30_MXBAHI_PT0001_A003","Serial_Acessorio":"","ICCID":"89550277000007469335","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_FACELL_RN","tipo":"Venda","idpedido_origem":650487,"retorno_json":"[{\"cod_importacao\":72649686,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 565) 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:05376cdc-cd1c-4aef-b954-3f70aa801b47 Error Number:1205,State:52,Class:13 [09:56:25.9447296] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72649695,"dt_importado":"2024-09-11T09:54:46.833","nom_cliente":"ELIANDRO JOSÉ MARTINS DE OLIVEIRA","ddd":0,"num_telefone":0,"num_documento":"03361741955","dt_servico":"2024-09-11T09:54:46.833","nom_plano":"","SerialId":203182,"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-07T00:00:00","dt_sellout":"2024-09-11T09:56:10","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"42240902455036011049650010000038001013035263","num_dsf":"95224","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-09-11T09:56:02.443","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"337495","custcode_nivel_75":"TS40_TSPLUI_RV0004_A002","Serial_Acessorio":"","ICCID":"89550447000024097932","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_MASTERCELLCOMERCIO_SC","tipo":"Venda","idpedido_origem":337495,"retorno_json":"[{\"cod_importacao\":72649695,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 1234) 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:0f298097-59b2-4120-9639-9ba4e8488837 Error Number:1205,State:52,Class:13 [09:56:26.4916160] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72649692,"dt_importado":"2024-09-11T09:30:07.5","nom_cliente":"ERONDI VELOSO","ddd":0,"num_telefone":0,"num_documento":"39552160987","dt_servico":"2024-09-11T09:30:07.5","nom_plano":"","SerialId":null,"imei":null,"valor_aparelho":5.00,"val_entrada_dinh":5.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":null,"dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"9890","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-09-11T09:55:59.19","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":5.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"95872","custcode_nivel_75":"TS40_TSAGCI_TS0617_A001","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_MGCSOLUCOES_PR","tipo":"Venda","idpedido_origem":95872,"retorno_json":"[{\"cod_importacao\":72649692,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 1368) 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:e8066b3f-9d98-444c-a568-e88a8ea2793d Error Number:1205,State:52,Class:13 [11:25:28.2034475] [TFP] [EnviaDadosTimCentralizado] Base: $COMERCIAL_TIM - Pedido: $257901 - Cancelamento: $False - Devolucao: $False - Sem TFP: $True: System.InvalidOperationException: The source contains no DataRows. at System.Data.DataTableExtensions.LoadTableFromEnumerable[T](IEnumerable`1 source, DataTable table, Nullable`1 options, FillErrorEventHandler errorHandler) at System.Data.DataTableExtensions.CopyToDataTable[T](IEnumerable`1 source) 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 145 [16:19:52.7468891] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72654962,"dt_importado":"2024-09-11T16:05:27.3","nom_cliente":"RAFAELA FERNANDES SILVA","ddd":0,"num_telefone":0,"num_documento":"10564549622","dt_servico":"2024-09-11T16:05:27.3","nom_plano":"","SerialId":25339,"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-23T00:00:00","dt_sellout":"2024-09-11T16:19:46","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"31240949434654000201550010000041761010667630","num_dsf":"93580","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-09-11T16:19:38.627","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"59889","custcode_nivel_75":"MX30_MXM37I_RV6349_A007","Serial_Acessorio":"","ICCID":"89550238000003928928","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_DMHDIVINOPOLIS_MG","tipo":"Venda","idpedido_origem":59889,"retorno_json":"[{\"cod_importacao\":72654962,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 1445) 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:2b780a71-3315-4352-a774-feb8f068b922 Error Number:1205,State:52,Class:13