[23:31:16.0073889] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74015456,"dt_importado":"2024-01-21T17:58:00.94","nom_cliente":"MARILIA FLORENCIO SANTOS","ddd":0,"num_telefone":0,"num_documento":"12429748738","dt_servico":"2024-01-21T17:58:00.94","nom_plano":"","SerialId":23,"imei":352429897500877,"valor_aparelho":1100.00,"val_entrada_dinh":null,"val_entrada_bol":1100.00,"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":"2022-07-28T00:00:00","dt_sellout":"2024-01-22T09:56:51","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"26240145342567000184650010000075821010958817","num_dsf":"89497","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04014810","dt_operacao":"2025-02-23T23:30:18.82","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"104262","custcode_nivel_75":"NE80_NEN04I_NE0713_NE001","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_SWATMOBILE_PE","tipo":"Venda","idpedido_origem":104262,"retorno_json":"[{\"cod_importacao\":74015456,\"imei\":\"352429897500877\",\"num_telefone\":0,\"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 331
ClientConnectionId:c86cd945-2e39-4ce4-b84a-94ffcfcda655
Error Number:1205,State:51,Class:13
[23:31:20.9952880] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74015455,"dt_importado":"2024-01-27T11:50:33.377","nom_cliente":"JOAO SLOBODZAN","ddd":42,"num_telefone":991332183,"num_documento":"84393602900","dt_servico":"2024-01-27T11:50:33.377","nom_plano":"TIM CONTROLE SMART 5.0","SerialId":4878,"imei":353171129137289,"valor_aparelho":999.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":815187,"qtde_parc_1":12,"vl_cartao_credito_1":999.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"1000.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":1999.00,"dt_sellin":"2023-12-20T00:00:00","dt_sellout":"2024-01-27T11:56:32","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"41240132633267000102550010000009111010623587","num_dsf":"80637","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015257","dt_operacao":"2025-02-23T23:30:18.83","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"89624","custcode_nivel_75":"TS40_TSAGCI_RV0377_A001","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_TOPCELL_PR","tipo":"Venda","idpedido_origem":89624,"retorno_json":"[{\"cod_importacao\":74015455,\"imei\":\"353171129137289\",\"num_telefone\":991332183,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 254) 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 331
ClientConnectionId:2553748b-f095-415b-8f57-535246eff8f9
Error Number:1205,State:51,Class:13
[23:31:23.4988660] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74015457,"dt_importado":"2024-01-27T10:38:22.77","nom_cliente":"itamar pereira","ddd":47,"num_telefone":999864778,"num_documento":"00402401930","dt_servico":"2024-01-27T10:38:22.77","nom_plano":"TIM CONTROLE REDES SOCIAIS 5.0","SerialId":28830,"imei":355100982329087,"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":0,"qtde_parc_1":12,"vl_cartao_credito_1":1399.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"200.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":1599.00,"dt_sellin":"2024-01-05T00:00:00","dt_sellout":"2024-01-27T12:01:28","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"42240141561318000200650010000011341010417315","num_dsf":"87825","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015447","dt_operacao":"2025-02-23T23:30:19.04","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"89706","custcode_nivel_75":"TS40_TSAGCI_RV0372_A002","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_SOULTEAM_SC","tipo":"Venda","idpedido_origem":89706,"retorno_json":"[{\"cod_importacao\":74015457,\"imei\":\"355100982329087\",\"num_telefone\":999864778,\"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 331
ClientConnectionId:cbe2fd55-f369-4da6-a946-0b4d7e0c690a
Error Number:1205,State:51,Class:13
[23:31:24.7478539] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74015458,"dt_importado":"2024-01-17T18:14:29.893","nom_cliente":"SONALDO DE SOUSA MARAIS","ddd":11,"num_telefone":985435203,"num_documento":"28707495897","dt_servico":"2024-01-17T18:14:29.893","nom_plano":"TIM BLACK FAMÍLIA B (MULTI 60GB)","SerialId":67878,"imei":358615315599509,"valor_aparelho":2199.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":0,"qtde_parc_1":1,"vl_cartao_credito_1":2199.01,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"2300.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":4499.00,"dt_sellin":"2023-11-25T00:00:00","dt_sellout":"2024-01-18T10:19:58","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"35240133150686000741550010000000341010491724","num_dsf":"85170","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015665","dt_operacao":"2025-02-23T23:30:19.15","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"268126","custcode_nivel_75":"SP10_MGVALI_RV0561_A007","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_NONIS_INFORMATICA_SP","tipo":"Venda","idpedido_origem":268126,"retorno_json":"[{\"cod_importacao\":74015458,\"imei\":\"358615315599509\",\"num_telefone\":985435203,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 334) 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 331
ClientConnectionId:86d5cd77-4f94-4ff1-a764-2c283eb2d5e8
Error Number:1205,State:51,Class:13
[23:31:40.0497777] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74015487,"dt_importado":"2024-01-19T21:00:27.483","nom_cliente":"ELISMONY ALVES DA SILVA GUALBERTO","ddd":62,"num_telefone":981536882,"num_documento":"04902846128","dt_servico":"2024-01-19T21:00:27.483","nom_plano":"TIM BLACK C HERO 5.0","SerialId":66228,"imei":358615316765612,"valor_aparelho":2299.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":9.00,"cod_aut_1":93017,"qtde_parc_1":12,"vl_cartao_credito_1":2290.00,"cod_aut_2":40142,"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-01-12T00:00:00","dt_sellout":"2024-01-26T17:47:54","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"52240120881831000208550010000249441011432676","num_dsf":"58327","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015666","dt_operacao":"2025-02-23T23:30:34.263","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"140199","custcode_nivel_75":"CS60_MGGOII_PT2450_A002","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_CELMAXTELECOMUNICACOES_GO","tipo":"Venda","idpedido_origem":140199,"retorno_json":"[{\"cod_importacao\":74015487,\"imei\":\"358615316765612\",\"num_telefone\":981536882,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 543) 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 331
ClientConnectionId:ddb8be1d-d645-4736-afda-d328d3f3f707
Error Number:1205,State:51,Class:13
[23:31:47.5651345] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74015497,"dt_importado":"2024-01-27T20:43:00.493","nom_cliente":"TACIANO CORREIA DA SILVA","ddd":83,"num_telefone":999158091,"num_documento":"07947043442","dt_servico":"2024-01-27T20:43:00.493","nom_plano":"TIM CONTROLE SMART 5.0","SerialId":11971,"imei":356544398682788,"valor_aparelho":1799.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":90734,"qtde_parc_1":12,"vl_cartao_credito_1":1799.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"1400.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":3199.00,"dt_sellin":"2024-01-25T00:00:00","dt_sellout":"2024-01-27T20:45:45","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"26240122529731000242550010000004211010631442","num_dsf":"76060","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015472","dt_operacao":"2025-02-23T23:30:38.04","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"52910","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":52910,"retorno_json":"[{\"cod_importacao\":74015497,\"imei\":\"356544398682788\",\"num_telefone\":999158091,\"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 331
ClientConnectionId:955f0d7b-e9f7-4e0f-aa14-faa109499db5
Error Number:1205,State:51,Class:13
[23:33:10.1726632] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74015650,"dt_importado":"2024-01-05T14:54:17.103","nom_cliente":"CASSILDA EVARISTO DE SIQUEIRA","ddd":43,"num_telefone":999052616,"num_documento":"04554897931","dt_servico":"2024-01-05T14:54:17.103","nom_plano":"TIM BLACK A 5.0","SerialId":18840,"imei":350433275957859,"valor_aparelho":749.00,"val_entrada_dinh":749.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":"250.00","nom_tipo_negociacao":"","vl_pre_tabela":999.00,"dt_sellin":"2023-12-15T00:00:00","dt_sellout":"2024-01-08T09:12:45","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"41240118896531000250650020000005101010673767","num_dsf":"51184","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015640","dt_operacao":"2025-02-23T23:32:00.337","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"82052","custcode_nivel_75":"TS40_TSAGCI_TS2846_A001","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_CENTERTELECOMUNICACOES_PR","tipo":"Venda","idpedido_origem":82052,"retorno_json":"[{\"cod_importacao\":74015650,\"imei\":\"350433275957859\",\"num_telefone\":999052616,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 931) 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 331
ClientConnectionId:50b4158e-3f60-4f46-9fc6-07a3e59f2203
Error Number:1205,State:51,Class:13
[23:33:52.7742592] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74015725,"dt_importado":"2024-01-27T11:51:06.38","nom_cliente":"ANTONIO CARLOS DA SILVA","ddd":21,"num_telefone":989520516,"num_documento":"81431767387","dt_servico":"2024-01-27T11:51:06.38","nom_plano":"TIM CONTROLE SMART 5.0","SerialId":1064345,"imei":353907445994915,"valor_aparelho":1299.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":1368.19,"cod_aut_1":13206,"qtde_parc_1":12,"vl_cartao_credito_1":620.00,"cod_aut_2":593028,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"2200.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":3499.00,"dt_sellin":"2024-01-18T00:00:00","dt_sellout":"2024-01-27T12:32:20","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"33240108312444001812650010000654531011554927","num_dsf":"51317","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015070","dt_operacao":"2025-02-23T23:32:46.487","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"1296371","custcode_nivel_75":"RN20_MGBAII_PT2865_A014","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_SETELAN","tipo":"Venda","idpedido_origem":1296371,"retorno_json":"[{\"cod_importacao\":74015725,\"imei\":\"353907445994915\",\"num_telefone\":989520516,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 1041) 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 331
ClientConnectionId:a2c1c931-d502-460a-a36e-8a3167eef90d
Error Number:1205,State:51,Class:13
[23:34:35.3616236] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74015796,"dt_importado":"2024-01-27T18:03:06.3","nom_cliente":"MYDHIELI ALVES DE LIMA SANTOS","ddd":41,"num_telefone":997195368,"num_documento":"01187661988","dt_servico":"2024-01-27T18:03:06.3","nom_plano":"TIM CONTROLE REDES SOCIAIS 5.0","SerialId":190743,"imei":350528721740732,"valor_aparelho":999.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":57932,"qtde_parc_1":10,"vl_cartao_credito_1":1098.80,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"1000.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":1999.00,"dt_sellin":"2024-01-17T00:00:00","dt_sellout":"2024-01-27T18:05:05","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"41240102356946000110550010000527541012509690","num_dsf":"13178","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015257","dt_operacao":"2025-02-23T23:33:28.03","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"245908","custcode_nivel_75":"TS40_TSPLUI_TS0027_A001","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_DPIDULCOM_PR","tipo":"Venda","idpedido_origem":245908,"retorno_json":"[{\"cod_importacao\":74015796,\"imei\":\"350528721740732\",\"num_telefone\":997195368,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 920) 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 331
ClientConnectionId:4be2d4ac-439f-467d-824f-d052420d886c
Error Number:1205,State:51,Class:13
[23:35:53.9891840] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74015935,"dt_importado":"2024-01-06T20:18:35.207","nom_cliente":"SHIRLEI APARECIDA FERREIRA DENUNCIO","ddd":11,"num_telefone":984031646,"num_documento":"30960899812","dt_servico":"2024-01-06T20:18:35.207","nom_plano":"TIM BLACK MULTI A HERO 5.0","SerialId":60549,"imei":357389586447894,"valor_aparelho":499.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":577050,"qtde_parc_1":1,"vl_cartao_credito_1":499.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"500.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":999.00,"dt_sellin":"2023-12-27T00:00:00","dt_sellout":"2024-01-10T12:35:24","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"35240133032717000174550010000056231010896163","num_dsf":"77361","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015640","dt_operacao":"2025-02-23T23:34:50.72","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"131713","custcode_nivel_75":"SP10_MGVALI_PT8042_A001","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_MOBILEMAGAZINE_SP","tipo":"Venda","idpedido_origem":131713,"retorno_json":"[{\"cod_importacao\":74015935,\"imei\":\"357389586447894\",\"num_telefone\":984031646,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 543) 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 331
ClientConnectionId:ddb8be1d-d645-4736-afda-d328d3f3f707
Error Number:1205,State:51,Class:13
[23:36:01.5111260] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74015945,"dt_importado":"2024-01-27T20:49:56.42","nom_cliente":"matheus arconti bonassa","ddd":47,"num_telefone":997937344,"num_documento":"10187725969","dt_servico":"2024-01-27T20:49:56.42","nom_plano":"TIM CONTROLE SMART 5.0","SerialId":70933,"imei":353685811150870,"valor_aparelho":1699.00,"val_entrada_dinh":1699.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":"300.00","nom_tipo_negociacao":"","vl_pre_tabela":1999.00,"dt_sellin":"2023-11-16T00:00:00","dt_sellout":"2024-01-27T20:58:50","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"42240108640305000846650010000011721011264359","num_dsf":"46830","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015669","dt_operacao":"2025-02-23T23:34:56.267","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"158172","custcode_nivel_75":"TS40_TSPLUI_TS0046_A004","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_IANKCELL_SC","tipo":"Venda","idpedido_origem":158172,"retorno_json":"[{\"cod_importacao\":74015945,\"imei\":\"353685811150870\",\"num_telefone\":997937344,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 937) 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 331
ClientConnectionId:167014a9-feaf-4991-8672-eba862567122
Error Number:1205,State:51,Class:13
[23:36:49.1037610] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74016026,"dt_importado":"2024-01-27T14:21:11.51","nom_cliente":"IGOR DO NASCIMENTO MOURA ","ddd":21,"num_telefone":965919125,"num_documento":"20779833708","dt_servico":"2024-01-27T14:21:11.51","nom_plano":"TIM BLACK MULTI A HERO 5.0","SerialId":1063852,"imei":353494811509338,"valor_aparelho":1899.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":"1100.00","nom_tipo_negociacao":"","vl_pre_tabela":2999.00,"dt_sellin":"2024-01-18T00:00:00","dt_sellout":"2024-01-27T14:31:12","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"33240108312444001650650010000558071011555842","num_dsf":"46646","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015692","dt_operacao":"2025-02-23T23:35:49.823","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"1296484","custcode_nivel_75":"RN20_MGBAII_PT2865_A013","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_SETELAN","tipo":"Venda","idpedido_origem":1296484,"retorno_json":"[{\"cod_importacao\":74016026,\"imei\":\"353494811509338\",\"num_telefone\":965919125,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 334) 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 331
ClientConnectionId:fc372f4f-59ef-4fa0-b341-3821493d7365
Error Number:1205,State:51,Class:13