[00:00:34.7102304] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74018347,"dt_importado":"2024-05-07T12:29:14.087","nom_cliente":"MANOEL SILVESTRE DE JESUS","ddd":82,"num_telefone":996121283,"num_documento":"02099788480","dt_servico":"2024-05-07T12:29:14.087","nom_plano":"TIM CONTROLE SMART 6.0","SerialId":143006,"imei":350433279341852,"valor_aparelho":799.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":54187,"qtde_parc_1":10,"vl_cartao_credito_1":799.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":999.00,"dt_sellin":"2024-02-08T00:00:00","dt_sellout":"2024-05-09T08:16:14","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"27240508351313000104650010001143571003851990","num_dsf":"27204","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015641","dt_operacao":"2025-02-23T23:59:32.71","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"233239","custcode_nivel_75":"NE80_NEN01I_NE0596_NE00","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_GEOLIVEIRA_AL","tipo":"Venda","idpedido_origem":233239,"retorno_json":"[{\"cod_importacao\":74018347,\"imei\":\"350433279341852\",\"num_telefone\":996121283,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 205) 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:53fac948-519d-47dc-a017-1852193f5c3c
Error Number:1205,State:51,Class:13
[00:03:22.4760713] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74018653,"dt_importado":"2024-05-07T20:54:44.147","nom_cliente":"AGNALDO FLORES JUNIOR","ddd":47,"num_telefone":992741321,"num_documento":"10403465966","dt_servico":"2024-05-07T20:54:44.147","nom_plano":"TIM CONTROLE REDES SOCIAIS 4.0","SerialId":95152,"imei":353037555614333,"valor_aparelho":1399.00,"val_entrada_dinh":400.00,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":694160,"qtde_parc_1":5,"vl_cartao_credito_1":999.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"300.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":1699.00,"dt_sellin":"2024-04-22T00:00:00","dt_sellout":"2024-05-08T14:03:30","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"42240508640305000927650010000021021011400446","num_dsf":"46607","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015989","dt_operacao":"2025-02-24T00:02:21.52","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"193709","custcode_nivel_75":"TS40_TSPLUI_TS0046_A003","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_IANKCELL_SC","tipo":"Venda","idpedido_origem":193709,"retorno_json":"[{\"cod_importacao\":74018653,\"imei\":\"353037555614333\",\"num_telefone\":992741321,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 217) 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:d5a1c88d-a5d9-4657-bd15-9defa6ed8e9e
Error Number:1205,State:51,Class:13
[00:03:22.4912943] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":3,"cod_importacao":74018654,"dt_importado":"2024-06-22T19:10:43.097","nom_cliente":"GARLENE SILVA NERIS","ddd":0,"num_telefone":0,"num_documento":"80668631368","dt_servico":"2024-06-22T19:10:43.097","nom_plano":"","SerialId":41984,"imei":7501,"valor_aparelho":99.00,"val_entrada_dinh":0.01,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":1000.00,"cod_aut_1":0,"qtde_parc_1":8,"vl_cartao_credito_1":498.00,"cod_aut_2":0,"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-06-12T00:00:00","dt_sellout":"2024-06-22T19:23:10","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"21240644944217000125550010000162901011318710","num_dsf":"88732","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015922","dt_operacao":"2025-02-24T00:02:22.02","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"129452","custcode_nivel_75":"RN90_MGMARI_PT4897_A001","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":true,"database_name":"DTS39_TIM_TALKLINETELECOM_MA","tipo":"Venda","idpedido_origem":129452,"retorno_json":"[{\"cod_importacao\":74018654,\"imei\":\"7501\",\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"},{"item":1,"cod_importacao":null,"dt_importado":"2024-06-22T19:10:43.097","nom_cliente":"GARLENE SILVA NERIS","ddd":99,"num_telefone":981513356,"num_documento":"80668631368","dt_servico":"2024-06-22T19:10:43.097","nom_plano":"TIM CONTROLE SMART 6.0","SerialId":42159,"imei":357567913878028,"valor_aparelho":1399.00,"val_entrada_dinh":0.01,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":1000.00,"cod_aut_1":0,"qtde_parc_1":8,"vl_cartao_credito_1":498.00,"cod_aut_2":0,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"1000.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":2399.00,"dt_sellin":"2024-06-18T00:00:00","dt_sellout":"2024-06-22T19:23:10","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"21240644944217000125550010000162901011318710","num_dsf":"88732","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016095","dt_operacao":"2025-02-24T00:02:22.02","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"129452","custcode_nivel_75":"RN90_MGMARI_PT4897_A001","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":true,"database_name":null,"tipo":null,"idpedido_origem":null,"retorno_json":null}]:
System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 609) 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:9768a019-358c-42e0-9a62-9be21d74d963
Error Number:1205,State:51,Class:13
[00:04:05.0815301] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74018727,"dt_importado":"2024-06-22T15:51:48.883","nom_cliente":"MICHELLE RAMOS DA SILVA","ddd":92,"num_telefone":982790067,"num_documento":"07729646455","dt_servico":"2024-06-22T15:51:48.883","nom_plano":"TIM BLACK A 6.0","SerialId":58362,"imei":355970161453720,"valor_aparelho":4399.00,"val_entrada_dinh":null,"val_entrada_bol":900.01,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":633918,"qtde_parc_1":21,"vl_cartao_credito_1":3499.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"2900.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":7299.00,"dt_sellin":"2024-04-18T00:00:00","dt_sellout":"2024-06-22T15:54:18","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"13240611050941000580650000000260711011651433","num_dsf":"82342","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015711","dt_operacao":"2025-02-24T00:03:05.377","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"148888","custcode_nivel_75":"RN90_MGAMAI_RV3083_A005","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_INFORCELL_AM","tipo":"Venda","idpedido_origem":148888,"retorno_json":"[{\"cod_importacao\":74018727,\"imei\":\"355970161453720\",\"num_telefone\":982790067,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 609) 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:9768a019-358c-42e0-9a62-9be21d74d963
Error Number:1205,State:51,Class:13
[00:04:05.0947114] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74018728,"dt_importado":"2024-06-22T18:01:42.21","nom_cliente":"NILSON GERALDO DE RESENDE JUNIOR","ddd":98,"num_telefone":992241174,"num_documento":"01437900640","dt_servico":"2024-06-22T18:01:42.21","nom_plano":"TIM CONTROLE SMART 6.0","SerialId":42148,"imei":359167816305134,"valor_aparelho":799.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":10,"vl_cartao_credito_1":799.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":1399.00,"dt_sellin":"2024-06-18T00:00:00","dt_sellout":"2024-06-22T18:07:49","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"21240644944217000125550010000162881011318623","num_dsf":"88732","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015983","dt_operacao":"2025-02-24T00:03:05.9","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"129444","custcode_nivel_75":"RN90_MGMARI_PT4897_A001","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_TALKLINETELECOM_MA","tipo":"Venda","idpedido_origem":129444,"retorno_json":"[{\"cod_importacao\":74018728,\"imei\":\"359167816305134\",\"num_telefone\":992241174,\"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:d68e0f76-7130-451d-8d5a-8113dd9a06fe
Error Number:1205,State:51,Class:13
[00:04:17.6137714] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74018748,"dt_importado":"2024-06-22T13:26:25.78","nom_cliente":"ANDERSON GERALDO PICKLER","ddd":42,"num_telefone":999975164,"num_documento":"02536962911","dt_servico":"2024-06-22T13:26:25.78","nom_plano":"TIM BLACK A 6.0","SerialId":95932,"imei":357722590769459,"valor_aparelho":1499.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":184.00,"val_entrada_deb":null,"cod_aut_1":16985,"qtde_parc_1":10,"vl_cartao_credito_1":800.00,"cod_aut_2":711934,"qtde_parc_2":10,"vl_cartao_credito_2":315.00,"sit_fidelizacao":false,"vl_desconto":"1500.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":2999.00,"dt_sellin":"2024-06-07T00:00:00","dt_sellout":"2024-06-22T13:51:49","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"41240605323673000872550010000019091011161832","num_dsf":"90580","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016284","dt_operacao":"2025-02-24T00:03:17.807","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"171915","custcode_nivel_75":"TS40_TSPLUI_TS0016_A002","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_VIVERECELULARES_PR","tipo":"Venda","idpedido_origem":171915,"retorno_json":"[{\"cod_importacao\":74018748,\"imei\":\"357722590769459\",\"num_telefone\":999975164,\"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:f5ca040e-7bcd-4340-a5ff-8499ed634096
Error Number:1205,State:51,Class:13
[00:05:05.1562822] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74018830,"dt_importado":"2024-05-08T17:58:56.83","nom_cliente":"JESSICA PAULA LOPES CORREIA","ddd":21,"num_telefone":980981585,"num_documento":"13734412757","dt_servico":"2024-05-08T17:58:56.83","nom_plano":"TIM BLACK MULTI A HERO 5.0","SerialId":314889,"imei":353725680790073,"valor_aparelho":599.00,"val_entrada_dinh":99.00,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":569243,"qtde_parc_1":4,"vl_cartao_credito_1":500.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"300.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":899.00,"dt_sellin":"2022-02-19T00:00:00","dt_sellout":"2024-05-10T12:19:30","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"33240505999455001077650000000095531003602857","num_dsf":"86979","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04014438","dt_operacao":"2025-02-24T00:04:05.593","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"491568","custcode_nivel_75":"RN20_MGSULI_PT2851_A007","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_MAGNATA","tipo":"Venda","idpedido_origem":491568,"retorno_json":"[{\"cod_importacao\":74018830,\"imei\":\"353725680790073\",\"num_telefone\":980981585,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 174) 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:af9ce714-523c-404b-b6f8-6e39ebe5a143
Error Number:1205,State:51,Class:13
[00:08:17.9930400] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74019167,"dt_importado":"2024-06-15T11:34:10.01","nom_cliente":"GERALDO CELIO DA SILVA","ddd":31,"num_telefone":989387061,"num_documento":"65342097649","dt_servico":"2024-06-15T11:34:10.01","nom_plano":"TIM CONTROLE SMART 6.0","SerialId":44089,"imei":350409871520069,"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":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":799.00,"dt_sellin":"2023-10-27T00:00:00","dt_sellout":"2024-06-15T11:35:11","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"31240626103866000111650010000067311011633471","num_dsf":"62447","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015222","dt_operacao":"2025-02-24T00:07:19.76","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"162368","custcode_nivel_75":"MX30_MXM31I_PT4180_A001","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_GDCELULARES_MG","tipo":"Venda","idpedido_origem":162368,"retorno_json":"[{\"cod_importacao\":74019167,\"imei\":\"350409871520069\",\"num_telefone\":989387061,\"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:bc597dad-8ec5-4057-a124-b1dc585f346a
Error Number:1205,State:51,Class:13
[00:08:35.5247091] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":3,"cod_importacao":74019196,"dt_importado":"2024-05-07T14:04:58.217","nom_cliente":"RONALDO VIEIRA DA COSTA","ddd":21,"num_telefone":980826847,"num_documento":"02329279361","dt_servico":"2024-05-07T14:04:58.217","nom_plano":"TIM BLACK A 5.0","SerialId":1090565,"imei":354173240757341,"valor_aparelho":1249.00,"val_entrada_dinh":384.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":"650.00","nom_tipo_negociacao":"","vl_pre_tabela":1899.00,"dt_sellin":"2024-04-26T00:00:00","dt_sellout":"2024-05-08T14:59:48","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"33240508312444000417650010000778041012049752","num_dsf":"42698","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016086","dt_operacao":"2025-02-24T00:07:37.13","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"1344207","custcode_nivel_75":"RN20_MGBAII_PT2865_A004","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_SETELAN","tipo":"Venda","idpedido_origem":1344207,"retorno_json":"[{\"cod_importacao\":74019196,\"imei\":\"354173240757341\",\"num_telefone\":980826847,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 628) 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:5e714401-62a0-4edc-9467-ffda59c1a3d9
Error Number:1205,State:51,Class:13
[00:12:43.4590409] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74019625,"dt_importado":"2024-06-08T12:10:21.207","nom_cliente":"JP DIESEL COMERCIO E IMPORTAÇÃO LTDA","ddd":31,"num_telefone":992153720,"num_documento":"26349027000188","dt_servico":"2024-06-08T12:10:21.207","nom_plano":"TIM CONTROLE REDES SOCIAIS 6.0","SerialId":43963,"imei":356722911274438,"valor_aparelho":1049.00,"val_entrada_dinh":0.01,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":0,"qtde_parc_1":18,"vl_cartao_credito_1":1098.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"550.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":1599.00,"dt_sellin":"2024-04-02T00:00:00","dt_sellout":"2024-06-08T12:17:22","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"31240641910977001286550100000024361011275224","num_dsf":"91584","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016083","dt_operacao":"2025-02-24T00:11:40.937","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"115487","custcode_nivel_75":"MX30_MXM31I_RV0002_A001","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_DATAFOR_MG","tipo":"Venda","idpedido_origem":115487,"retorno_json":"[{\"cod_importacao\":74019625,\"imei\":\"356722911274438\",\"num_telefone\":992153720,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 913) 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:c11cd179-1b42-4ace-8617-ec3a0a8993c3
Error Number:1205,State:51,Class:13
[00:13:31.0695563] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74019701,"dt_importado":"2024-05-07T17:12:43.607","nom_cliente":"MAYKON DOUGLAS PEREIRA DA SILVA","ddd":84,"num_telefone":996220086,"num_documento":"70445858419","dt_servico":"2024-05-07T17:12:43.607","nom_plano":"TIM CONTROLE J EXPRESS 6.0","SerialId":540325,"imei":355317935851294,"valor_aparelho":4299.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":52964,"qtde_parc_1":12,"vl_cartao_credito_1":2990.00,"cod_aut_2":85407,"qtde_parc_2":12,"vl_cartao_credito_2":1309.00,"sit_fidelizacao":false,"vl_desconto":"2000.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":6299.00,"dt_sellin":"2024-03-13T00:00:00","dt_sellout":"2024-05-08T19:22:58","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"24240507366109000943650000001328371011774771","num_dsf":"52736","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04014836","dt_operacao":"2025-02-24T00:12:29.84","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"567185","custcode_nivel_75":"NE80_NEN06I_NE0429_NE04","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_FACELL_RN","tipo":"Venda","idpedido_origem":567185,"retorno_json":"[{\"cod_importacao\":74019701,\"imei\":\"355317935851294\",\"num_telefone\":996220086,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 609) 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:51d4b6cc-7b74-444d-a822-d39b812f87af
Error Number:1205,State:51,Class:13
[00:13:36.1008552] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74019704,"dt_importado":"2024-06-22T12:07:45.013","nom_cliente":"ADENILSON ANTONIO AMORIM ","ddd":44,"num_telefone":998513909,"num_documento":"59949147972","dt_servico":"2024-06-22T12:07:45.013","nom_plano":"TIM CONTROLE SMART 6.0","SerialId":125328,"imei":357567915237504,"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":36902,"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":"1000.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":2399.00,"dt_sellin":"2024-03-25T00:00:00","dt_sellout":"2024-06-22T12:25:10","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"41240620654202001055550010000100581012169678","num_dsf":"85027","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016095","dt_operacao":"2025-02-24T00:12:31.84","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"264796","custcode_nivel_75":"TS40_TSAGCI_RV0328_A006","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_LEMAR_PR","tipo":"Venda","idpedido_origem":264796,"retorno_json":"[{\"cod_importacao\":74019704,\"imei\":\"357567915237504\",\"num_telefone\":998513909,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 210) 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:dba2f38b-5d82-4f13-ad17-b7af2315f2c8
Error Number:1205,State:51,Class:13
[00:16:37.6649865] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74020020,"dt_importado":"2024-05-10T20:06:46.23","nom_cliente":"dilsemara maschio","ddd":0,"num_telefone":0,"num_documento":"95501363968","dt_servico":"2024-05-10T20:06:46.23","nom_plano":"","SerialId":116789,"imei":4000,"valor_aparelho":100.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":499.00,"cod_aut_1":932344,"qtde_parc_1":12,"vl_cartao_credito_1":3000.00,"cod_aut_2":309097,"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-04-22T00:00:00","dt_sellout":"2024-05-11T09:38:40","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"41240511021140000677650020000284181001886923","num_dsf":"57935","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015696","dt_operacao":"2025-02-24T00:15:38.683","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"233520","custcode_nivel_75":"TS40_TSPLUI_TS0055_A007","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":true,"database_name":"DTS39_TIM_BATIMALDONADO","tipo":"Venda","idpedido_origem":233520,"retorno_json":"[{\"cod_importacao\":74020020,\"imei\":\"4000\",\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"},{"item":2,"cod_importacao":74020025,"dt_importado":"2024-05-10T20:06:46.23","nom_cliente":"dilsemara maschio","ddd":41,"num_telefone":995499441,"num_documento":"95501363968","dt_servico":"2024-05-10T20:06:46.23","nom_plano":"TIM BLACK C ULTRA 6.0","SerialId":119803,"imei":354737335067749,"valor_aparelho":3399.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":499.00,"cod_aut_1":932344,"qtde_parc_1":12,"vl_cartao_credito_1":3000.00,"cod_aut_2":309097,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"3600.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":6999.00,"dt_sellin":"2024-05-08T00:00:00","dt_sellout":"2024-05-11T09:38:40","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"41240511021140000677650020000284181001886923","num_dsf":"57935","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016064","dt_operacao":"2025-02-24T00:15:38.683","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"233520","custcode_nivel_75":"TS40_TSPLUI_TS0055_A007","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":true,"database_name":"DTS39_TIM_BATIMALDONADO","tipo":"Venda","idpedido_origem":233520,"retorno_json":"[{\"cod_importacao\":74020025,\"imei\":\"354737335067749\",\"num_telefone\":995499441,\"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:b3b0fdac-90c8-4839-b019-153fde61b1c2
Error Number:1205,State:51,Class:13
[00:16:42.6739397] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74020014,"dt_importado":"2024-06-15T12:22:30.58","nom_cliente":"CELIA REGINA DE FREITAS ","ddd":44,"num_telefone":999145868,"num_documento":"17465537827","dt_servico":"2024-06-15T12:22:30.58","nom_plano":"TIM CONTROLE REDES SOCIAIS 6.0","SerialId":125582,"imei":358615317050923,"valor_aparelho":2799.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":2799.00,"cod_aut_1":576771,"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":"1700.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":4499.00,"dt_sellin":"2024-03-30T00:00:00","dt_sellout":"2024-06-15T12:23:54","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"41240620654202001055550010000099931012154803","num_dsf":"85027","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015666","dt_operacao":"2025-02-24T00:15:35.203","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"262844","custcode_nivel_75":"TS40_TSAGCI_RV0328_A006","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_LEMAR_PR","tipo":"Venda","idpedido_origem":262844,"retorno_json":"[{\"cod_importacao\":74020014,\"imei\":\"358615317050923\",\"num_telefone\":999145868,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 609) 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:bd05ad06-87df-4706-af98-c6da44211bbc
Error Number:1205,State:51,Class:13
[00:16:45.1971021] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74019999,"dt_importado":"2024-05-07T13:48:27.827","nom_cliente":"carlos eduardo freitas morais","ddd":84,"num_telefone":996014744,"num_documento":"02975623470","dt_servico":"2024-05-07T13:48:27.827","nom_plano":"TIM CONTROLE B EXPRESS 5.1","SerialId":560283,"imei":358543580592506,"valor_aparelho":2499.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":721597,"qtde_parc_1":10,"vl_cartao_credito_1":2598.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":3499.00,"dt_sellin":"2024-04-16T00:00:00","dt_sellout":"2024-05-08T19:09:06","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"24240507366109000609650000000904181011772875","num_dsf":"34408","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016156","dt_operacao":"2025-02-24T00:15:26.5","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"566919","custcode_nivel_75":"NE80_NEN06I_NE0429_NE01","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":true,"database_name":"DTS39_TIM_FACELL_RN","tipo":"Venda","idpedido_origem":566919,"retorno_json":"[{\"cod_importacao\":74019999,\"imei\":\"358543580592506\",\"num_telefone\":996014744,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 210) 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:b4067311-5d7e-456e-9192-0cc8eb046981
Error Number:1205,State:51,Class:13
[00:16:46.4525001] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":4,"cod_importacao":74020006,"dt_importado":"2024-06-15T16:27:43.857","nom_cliente":"SANDRA AQUINO BARBOSA","ddd":61,"num_telefone":982912235,"num_documento":"52447561172","dt_servico":"2024-06-15T16:27:43.857","nom_plano":"TIM BLACK MULTI C 6.0","SerialId":95632,"imei":355163185089437,"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":888151,"qtde_parc_1":8,"vl_cartao_credito_1":2177.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"4100.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":5999.00,"dt_sellin":"2024-04-23T00:00:00","dt_sellout":"2024-06-15T16:33:09","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"53240611775328000368550010000304271012024116","num_dsf":"42711","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016071","dt_operacao":"2025-02-24T00:15:30.13","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"186192","custcode_nivel_75":"CS60_MGBSBI_RV3063_A003","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":true,"database_name":"DTS39_TIM_TELECEL_DF","tipo":"Venda","idpedido_origem":186192,"retorno_json":"[{\"cod_importacao\":74020006,\"imei\":\"355163185089437\",\"num_telefone\":982912235,\"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:9d17fc3e-0f9d-409e-b741-a2206c36223e
Error Number:1205,State:51,Class:13
[00:16:48.0693154] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74020026,"dt_importado":"2024-06-15T18:10:25.023","nom_cliente":"SCHARLON SILVESTRE BUDAL","ddd":47,"num_telefone":997948448,"num_documento":"08366049973","dt_servico":"2024-06-15T18:10:25.023","nom_plano":"TIM CONTROLE REDES SOCIAIS 6.0","SerialId":93064,"imei":356722911029394,"valor_aparelho":1099.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":1099.00,"cod_aut_1":227654,"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":"500.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":1599.00,"dt_sellin":"2024-03-05T00:00:00","dt_sellout":"2024-06-15T18:11:58","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"42240608640305001060650010000013081011414298","num_dsf":"48607","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016081","dt_operacao":"2025-02-24T00:15:41.77","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"198869","custcode_nivel_75":"TS40_TSPLUI_TS0046_A007","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_IANKCELL_SC","tipo":"Venda","idpedido_origem":198869,"retorno_json":"[{\"cod_importacao\":74020026,\"imei\":\"356722911029394\",\"num_telefone\":997948448,\"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:c616b856-5ccb-4015-a65f-97c867792d33
Error Number:1205,State:51,Class:13
[00:16:49.9319664] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74020019,"dt_importado":"2024-06-22T19:06:48.213","nom_cliente":"giovane gomes modesto ","ddd":35,"num_telefone":991624881,"num_documento":"05517130623","dt_servico":"2024-06-22T19:06:48.213","nom_plano":"TIM CONTROLE REDES SOCIAIS 6.0","SerialId":429444,"imei":357576780525927,"valor_aparelho":1999.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":298.00,"cod_aut_1":45973,"qtde_parc_1":10,"vl_cartao_credito_1":1800.00,"cod_aut_2":69341,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"1500.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":3499.00,"dt_sellin":"2024-06-17T00:00:00","dt_sellout":"2024-06-22T19:13:29","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"35240681214819002873550010000152371005745511","num_dsf":"83371","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015933","dt_operacao":"2025-02-24T00:15:38.407","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"613258","custcode_nivel_75":"SP10_MGRIBI_PT0298_A001","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":true,"database_name":"DTS39_TIM_JUFAP_PR","tipo":"Venda","idpedido_origem":613258,"retorno_json":"[{\"cod_importacao\":74020019,\"imei\":\"357576780525927\",\"num_telefone\":991624881,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 1007) 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:48e39bf9-7506-4b39-bca0-1466ac4a09c1
Error Number:1205,State:51,Class:13
[00:16:51.2053380] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74020022,"dt_importado":"2024-05-05T15:59:43.467","nom_cliente":"jorge gabriel ferraz barbosa","ddd":0,"num_telefone":0,"num_documento":"39657581877","dt_servico":"2024-05-05T15:59:43.467","nom_plano":"","SerialId":250305,"imei":356722917013749,"valor_aparelho":1599.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":354.64,"cod_aut_1":982076,"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":"rebate","vl_pre_tabela":0.00,"dt_sellin":"2024-04-09T00:00:00","dt_sellout":"2024-05-08T14:33:56","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"35240511378319000414650010000052591012999898","num_dsf":"51261","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016080","dt_operacao":"2025-02-24T00:15:40.01","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"271975","custcode_nivel_75":"SP10_MGBAUI_PT2833_A004","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_ROCHATELECOM_SP","tipo":"Venda","idpedido_origem":271975,"retorno_json":"[{\"cod_importacao\":74020022,\"imei\":\"356722917013749\",\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 623) 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:a867b05f-d73f-40a1-ac28-b601e812afe1
Error Number:1205,State:51,Class:13
[00:16:52.7218343] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74020017,"dt_importado":"2024-05-10T13:30:44.447","nom_cliente":"EFIGENIA CRISTINA DA SILVA","ddd":84,"num_telefone":988825191,"num_documento":"02457885493","dt_servico":"2024-05-10T13:30:44.447","nom_plano":"TIM CONTROLE SMART 6.0","SerialId":87043,"imei":358615317128869,"valor_aparelho":2799.00,"val_entrada_dinh":1400.00,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":89414,"qtde_parc_1":12,"vl_cartao_credito_1":1499.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"1700.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":4499.00,"dt_sellin":"2024-03-20T00:00:00","dt_sellout":"2024-05-10T13:56:06","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"24240570310289002840650010000026511010599065","num_dsf":"93349","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015660","dt_operacao":"2025-02-24T00:15:37.263","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"184245","custcode_nivel_75":"NE80_NEN06I_NE0076_NE18","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":true,"database_name":"DTS39_TIM_MCTELECOM","tipo":"Venda","idpedido_origem":184245,"retorno_json":"[{\"cod_importacao\":74020017,\"imei\":\"358615317128869\",\"num_telefone\":988825191,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 205) 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:2eccc316-9c0d-4494-a86c-b5418cf12d5c
Error Number:1205,State:51,Class:13
[00:16:52.7542779] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":74020016,"dt_importado":"2024-06-01T13:34:04.653","nom_cliente":"PAULO HENRIQUE DUARTE","ddd":31,"num_telefone":991722047,"num_documento":"06383911643","dt_servico":"2024-06-01T13:34:04.653","nom_plano":"TIM BLACK MULTI C 6.0","SerialId":101169,"imei":355280885132646,"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":82095,"qtde_parc_1":10,"vl_cartao_credito_1":3999.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"4000.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":7999.00,"dt_sellin":"2024-02-21T00:00:00","dt_sellout":"2024-06-01T13:38:13","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"31240608017682000157650010000239521002446380","num_dsf":"24945","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016068","dt_operacao":"2025-02-24T00:15:37.177","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"166432","custcode_nivel_75":"MX30_MXM31I_PT1375_VV01","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","promo_aparelho_acessorio":false,"database_name":"DTS39_TIM_MANNA_MG","tipo":"Venda","idpedido_origem":166432,"retorno_json":"[{\"cod_importacao\":74020016,\"imei\":\"355280885132646\",\"num_telefone\":991722047,\"erro\":\"sem erro, importado com sucesso.\"}]"}]:
System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 610) 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:7e448df0-fc18-4bef-b3d6-bb12866e423c
Error Number:1205,State:51,Class:13