[23:42:12.3294790] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74016452,"dt_importado":"2024-02-10T19:00:31.557","nom_cliente":"HELOISA HELENA NEVES DE CARVALHO","ddd":16,"num_telefone":981584476,"num_documento":"44752634848","dt_servico":"2024-02-10T19:00:31.557","nom_plano":"TIM BLACK MULTI A HERO 5.0","SerialId":24543,"imei":355970160197658,"valor_aparelho":3999.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":12,"vl_cartao_credito_1":3999.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"3300.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":7299.00,"dt_sellin":"2024-02-06T00:00:00","dt_sellout":"2024-02-11T14:03:21","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"35240226495248000164550010000010291010404429","num_dsf":"89218","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015711","dt_operacao":"2025-02-23T23:41:20.35","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"74408","custcode_nivel_75":"SP10_MGRIBI_PT2904_A001","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_CELLJVA_SP","tipo":"Venda","idpedido_origem":74408,"retorno_json":"[{\"cod_importacao\":74016452,\"imei\":\"355970160197658\",\"num_telefone\":981584476,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 350) 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 WS CAIXA - QA\Banco\Integracoes.cs:line 337 ClientConnectionId:63c73496-c742-4bd4-bc9f-480db0f307ab Error Number:1205,State:51,Class:13 [23:43:04.9261324] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74016538,"dt_importado":"2024-02-10T15:23:58.24","nom_cliente":"LUZIA SEVERINA DA SILVA TORRES","ddd":61,"num_telefone":996113400,"num_documento":"22077839449","dt_servico":"2024-02-10T15:23:58.24","nom_plano":"TIM CONTROLE B EXPRESS 5.1","SerialId":45317,"imei":354494160195878,"valor_aparelho":849.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":849.00,"cod_aut_1":255675,"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":"50.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":899.00,"dt_sellin":"2024-02-06T00:00:00","dt_sellout":"2024-02-10T15:28:14.243","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"53240212159617000214650010000066611011300418","num_dsf":"86294","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016003","dt_operacao":"2025-02-23T23:42:04.313","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"122688","custcode_nivel_75":"CS60_MGBSBI_RV2993_A002","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_STILLOCELULAR_DF","tipo":"Venda","idpedido_origem":122688,"retorno_json":"[{\"cod_importacao\":74016538,\"imei\":\"354494160195878\",\"num_telefone\":996113400,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 360) 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 WS CAIXA - QA\Banco\Integracoes.cs:line 337 ClientConnectionId:b2346ad9-f220-494c-b004-b40767c2ca77 Error Number:1205,State:51,Class:13 [23:45:17.6697682] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74016788,"dt_importado":"2024-02-10T16:37:10.41","nom_cliente":"SILVA ","ddd":61,"num_telefone":982098474,"num_documento":"87611708104","dt_servico":"2024-02-10T16:37:10.41","nom_plano":"TIM BLACK C HERO 5.0","SerialId":64571,"imei":357709570186572,"valor_aparelho":1999.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":199.00,"cod_aut_1":685348,"qtde_parc_1":12,"vl_cartao_credito_1":2000.00,"cod_aut_2":0,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"3000.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":4999.00,"dt_sellin":"2023-10-31T00:00:00","dt_sellout":"2024-02-10T16:40:00","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"53240211775328000520550010000314721011620109","num_dsf":"55565","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015030","dt_operacao":"2025-02-23T23:44:21.373","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"145640","custcode_nivel_75":"CS60_MGBSBI_PT2861_A001","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_TELECEL_DF","tipo":"Venda","idpedido_origem":145640,"retorno_json":"[{\"cod_importacao\":74016788,\"imei\":\"357709570186572\",\"num_telefone\":982098474,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 356) 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 WS CAIXA - QA\Banco\Integracoes.cs:line 337 ClientConnectionId:0b4a8666-7a26-4d55-9657-ec8faae6ecd7 Error Number:1205,State:51,Class:13 [23:54:11.6491929] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74017634,"dt_importado":"2024-05-07T18:15:45.31","nom_cliente":"VAGNA SOARES DA SILVA","ddd":98,"num_telefone":983249690,"num_documento":"57825653220","dt_servico":"2024-05-07T18:15:45.31","nom_plano":"TIM CONTROLE SMART 6.0","SerialId":446,"imei":350528720504485,"valor_aparelho":999.00,"val_entrada_dinh":999.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":"1000.00","nom_tipo_negociacao":"","vl_pre_tabela":1999.00,"dt_sellin":"2023-11-17T00:00:00","dt_sellout":"2024-06-21T08:27:21","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"21240634923541000103650010000000011010000755","num_dsf":"88874","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015257","dt_operacao":"2025-02-23T23:53:15.71","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"67","custcode_nivel_75":"RN90_MGMARI_RV4886_A001","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_BLADECELULARES_MA","tipo":"Venda","idpedido_origem":67,"retorno_json":"[{\"cod_importacao\":74017634,\"imei\":\"350528720504485\",\"num_telefone\":983249690,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 167) 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 WS CAIXA - QA\Banco\Integracoes.cs:line 337 ClientConnectionId:dd52ded5-b0ac-4963-a070-41de7d706089 Error Number:1205,State:51,Class:13 [23:54:19.1371808] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74017643,"dt_importado":"2024-06-01T10:14:04.517","nom_cliente":"joanita aparecida ferreira da silva","ddd":0,"num_telefone":0,"num_documento":"09491794698","dt_servico":"2024-06-01T10:14:04.517","nom_plano":"","SerialId":2346,"imei":355896811070079,"valor_aparelho":899.00,"val_entrada_dinh":899.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-04-02T00:00:00","dt_sellout":"2024-06-01T10:14:55","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"31240607749642000480650010000001611010621122","num_dsf":"93266","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016017","dt_operacao":"2025-02-23T23:53:20.263","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"62065","custcode_nivel_75":"MX30_MXM31I_RV5297_A002","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_BLUEMOON_MG","tipo":"Venda","idpedido_origem":62065,"retorno_json":"[{\"cod_importacao\":74017643,\"imei\":\"355896811070079\",\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 625) 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 WS CAIXA - QA\Banco\Integracoes.cs:line 337 ClientConnectionId:53b51d16-34be-4079-9a50-8d9dec00155a Error Number:1205,State:51,Class:13 [23:55:11.7395128] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74017736,"dt_importado":"2024-06-08T13:28:24.677","nom_cliente":"LUCAS MIGUEL MEDEIROS DE OLIVEIRA SANTOS","ddd":81,"num_telefone":996927413,"num_documento":"70435815407","dt_servico":"2024-06-08T13:28:24.677","nom_plano":"TIM BLACK A 6.0","SerialId":14854,"imei":358615317479189,"valor_aparelho":2299.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":891818,"qtde_parc_1":10,"vl_cartao_credito_1":2299.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"2200.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":4499.00,"dt_sellin":"2024-05-25T00:00:00","dt_sellout":"2024-06-08T13:30:17","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"26240622529731000242650010000359981010864037","num_dsf":"76060","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015666","dt_operacao":"2025-02-23T23:54:09.073","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"76135","custcode_nivel_75":"NE80_NEN04I_NE8261_A002","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_CELLZAP_PE","tipo":"Venda","idpedido_origem":76135,"retorno_json":"[{\"cod_importacao\":74017736,\"imei\":\"358615317479189\",\"num_telefone\":996927413,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 612) 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 WS CAIXA - QA\Banco\Integracoes.cs:line 337 ClientConnectionId:935ce87e-9659-43e6-8495-ec6078818dd0 Error Number:1205,State:51,Class:13 [23:56:49.3991401] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74017923,"dt_importado":"2024-05-08T16:56:04.843","nom_cliente":"ADELAR JOSE PERUZZOLO","ddd":49,"num_telefone":999814046,"num_documento":"05631785900","dt_servico":"2024-05-08T16:56:04.843","nom_plano":"DA VINCI","SerialId":16054,"imei":354494162826272,"valor_aparelho":899.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":602416,"qtde_parc_1":3,"vl_cartao_credito_1":899.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":899.00,"dt_sellin":"2024-04-18T00:00:00","dt_sellout":"2024-05-09T11:18:43","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"42240512558823000388650010000059931011089486","num_dsf":"51453","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016003","dt_operacao":"2025-02-23T23:55:49.737","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"97826","custcode_nivel_75":"TS40_TSAGCI_TS2780_A003","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_LAMEGACELULARES_SC","tipo":"Venda","idpedido_origem":97826,"retorno_json":"[{\"cod_importacao\":74017923,\"imei\":\"354494162826272\",\"num_telefone\":999814046,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 627) 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 WS CAIXA - QA\Banco\Integracoes.cs:line 337 ClientConnectionId:e8b9bdb3-7ccc-4fed-b69c-df4d603210e9 Error Number:1205,State:51,Class:13 [23:58:12.0049277] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74018078,"dt_importado":"2024-05-11T14:30:39.937","nom_cliente":"LUIZ ERNESTO ROZARIO","ddd":41,"num_telefone":998412317,"num_documento":"72396547968","dt_servico":"2024-05-11T14:30:39.937","nom_plano":"TIM CONTROLE REDES SOCIAIS 6.0","SerialId":24473,"imei":353685812420553,"valor_aparelho":1399.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":613685,"qtde_parc_1":10,"vl_cartao_credito_1":1399.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"600.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":1999.00,"dt_sellin":"2024-05-07T00:00:00","dt_sellout":"2024-05-13T10:23:55","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"41240500995956000170650020000090321011032507","num_dsf":"41791","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015669","dt_operacao":"2025-02-23T23:57:10.243","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"102086","custcode_nivel_75":"TS40_TSAGCI_TS2776_A001","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_TELECOMPANY_PR","tipo":"Venda","idpedido_origem":102086,"retorno_json":"[{\"cod_importacao\":74018078,\"imei\":\"353685812420553\",\"num_telefone\":998412317,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 167) 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 WS CAIXA - QA\Banco\Integracoes.cs:line 337 ClientConnectionId:dd52ded5-b0ac-4963-a070-41de7d706089 Error Number:1205,State:51,Class:13