[11:12:00.2110569] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FACELL_RN - Pedido: $643632 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 451 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:39:32.6808589] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_MASTERCELLCOMERCIO_SC - Pedido: $331420 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Cannot continue the execution because the session is in the kill state. A severe error occurred on the current command. The results, if any, should be discarded. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 451 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:40:03.1044167] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_CIAJARAGUA_GO - Pedido: $21175 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Cannot continue the execution because the session is in the kill state. A severe error occurred on the current command. The results, if any, should be discarded. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 451 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:53:52.9120194] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $676255 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 451 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:55:07.6113554] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $676291 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 451 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [13:28:45.0362611] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_MASTERCELLCOMERCIO_SC - Pedido: $331496 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 451 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [13:40:24.1473907] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FACELL_RN - Pedido: $643659 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 451 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [13:40:39.9568049] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FACELL_RN - Pedido: $643746 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 451 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [13:47:52.6132202] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FORTTELECOM_CE - Pedido: $282825 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Data.SqlClient.SqlException (0x80131904): Cannot continue the execution because the session is in the kill state. A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) at wsCaixa.Banco.fnBanco.executeComTransacao(String stQuery, SqlConnection Conn, SqlTransaction Tran, Boolean throws) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Data.cs:line 113 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 140 ClientConnectionId:46b24ba2-deb0-4e28-91f2-aa04186e61b4 Error Number:596,State:1,Class:21 [13:51:07.6757890] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_SETELAN - Pedido: $1402227 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Data.SqlClient.SqlException (0x80131904): Cannot continue the execution because the session is in the kill state. A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) at wsCaixa.Banco.fnBanco.executeComTransacao(String stQuery, SqlConnection Conn, SqlTransaction Tran, Boolean throws) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Data.cs:line 113 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 140 ClientConnectionId:0643b8b3-5a55-4fd8-987f-5cc55b31fe02 Error Number:596,State:1,Class:21 [13:51:28.9301004] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_DMHDIVINOPOLIS_MG - Pedido: $57154 - Cancelamento: $False - Devolucao: $True - Sem TFP: $False: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 181) entrou em deadlock em bloquear recursos com outro processo e foi escolhida como a vítima do deadlock. Execute a transação novamente. at wsCaixa.Banco.fnBanco.executeComTransacao(String stQuery, SqlConnection Conn, SqlTransaction Tran, Boolean throws) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Data.cs:line 113 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 140 ClientConnectionId:81def524-8564-4462-8ae9-b5e9042dd384 Error Number:1205,State:18,Class:13 [14:20:50.5354316] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FORTTELECOM_CE - Pedido: $282836 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Data.SqlClient.SqlException (0x80131904): Cannot continue the execution because the session is in the kill state. A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) at wsCaixa.Banco.fnBanco.executeComTransacao(String stQuery, SqlConnection Conn, SqlTransaction Tran, Boolean throws) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Data.cs:line 113 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 140 ClientConnectionId:5367dffb-d6cc-429e-b43d-0c3143b33045 Error Number:596,State:1,Class:21 [14:25:25.0957335] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FORTTELECOM_CE - Pedido: $282835 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Data.SqlClient.SqlException (0x80131904): Cannot continue the execution because the session is in the kill state. A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) at wsCaixa.Banco.fnBanco.executeComTransacao(String stQuery, SqlConnection Conn, SqlTransaction Tran, Boolean throws) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Data.cs:line 113 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 140 ClientConnectionId:44efc79f-31f1-4f87-8b90-5c9c03839ed7 Error Number:596,State:1,Class:21 [14:52:42.9587439] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_BATIMALDONADO - Pedido: $256667 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Data.SqlClient.SqlException (0x80131904): Cannot continue the execution because the session is in the kill state. A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) at wsCaixa.Banco.fnBanco.executeComTransacao(String stQuery, SqlConnection Conn, SqlTransaction Tran, Boolean throws) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Data.cs:line 113 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 140 ClientConnectionId:74bc7e76-b521-416f-89dc-fe3a1764052c Error Number:596,State:1,Class:21 [15:14:16.0042347] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JMXTELECOM_MG - Pedido: $178657 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Data.SqlClient.SqlException (0x80131904): Cannot continue the execution because the session is in the kill state. A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) at wsCaixa.Banco.fnBanco.executeComTransacao(String stQuery, SqlConnection Conn, SqlTransaction Tran, Boolean throws) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Data.cs:line 113 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 140 ClientConnectionId:050008f5-aba1-44f2-9358-70125937ea68 Error Number:596,State:1,Class:21 [15:14:16.6148021] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JMXTELECOM_MG - Pedido: $178668 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Data.SqlClient.SqlException (0x80131904): Cannot continue the execution because the session is in the kill state. A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) at wsCaixa.Banco.fnBanco.executeComTransacao(String stQuery, SqlConnection Conn, SqlTransaction Tran, Boolean throws) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Data.cs:line 113 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 140 ClientConnectionId:76b7f9ef-f017-42b5-8122-de36ab5d55d8 Error Number:596,State:1,Class:21 [15:34:19.7534723] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72502480,"dt_importado":"2024-08-29T15:29:06.443","nom_cliente":"JANE FRISKE","ddd":0,"num_telefone":0,"num_documento":"03251550977","dt_servico":"2024-08-29T15:29:06.443","nom_plano":"","SerialId":212728,"imei":null,"valor_aparelho":15.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":15.00,"cod_aut_1":585608,"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-23T00:00:00","dt_sellout":"2024-08-29T15:33:19","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"41240802356946001435550010000077281013471232","num_dsf":"90385","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-29T15:34:07.957","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"343529","custcode_nivel_75":"TS40_TSAGCI_TS0363_A009","Serial_Acessorio":"","ICCID":"89550448000009290592","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_DPIDULCOM_PR","tipo":"Venda","idpedido_origem":343529,"retorno_json":"[{\"cod_importacao\":72502480,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 64) entrou em deadlock em bloquear | buffer de comunicação recursos com outro processo e foi escolhida como a vítima do deadlock. Execute a transação novamente. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at wsCaixa.Banco.IntegracaoCaixaTim.SalvarDadosTimCentralizado(SqlConnection conn, SqlTransaction tran, DataRow dados, String stJsonEnvio, RetornoIntegracaoTim retorno) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:0094904d-7b3b-4d9a-bc9a-abf13d5331bf Error Number:1205,State:52,Class:13 [16:10:31.4705664] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_MAGNATA - Pedido: $520095 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Cannot continue the execution because the session is in the kill state. A severe error occurred on the current command. The results, if any, should be discarded. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 451 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [16:26:36.0741390] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72503298,"dt_importado":"2024-08-29T16:24:15.713","nom_cliente":"CAROLINA PADILHA JANSEN","ddd":0,"num_telefone":0,"num_documento":"06337499409","dt_servico":"2024-08-29T16:24:15.713","nom_plano":"","SerialId":279155,"imei":null,"valor_aparelho":15.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":88728,"qtde_parc_1":1,"vl_cartao_credito_1":15.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"0.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":0.00,"dt_sellin":"2024-06-29T00:00:00","dt_sellout":"2024-08-29T16:26:08","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"25240811105504000354650010000759571007436701","num_dsf":"47303","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-29T16:26:24.213","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"304233","custcode_nivel_75":"NE80_NEN03I_NE8175_PT02","Serial_Acessorio":"","ICCID":"89550288500003385952","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_CONECTRIO_PB","tipo":"Venda","idpedido_origem":304233,"retorno_json":"[{\"cod_importacao\":72503298,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 1611) entrou em deadlock em bloquear | buffer de comunicação recursos com outro processo e foi escolhida como a vítima do deadlock. Execute a transação novamente. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at wsCaixa.Banco.IntegracaoCaixaTim.SalvarDadosTimCentralizado(SqlConnection conn, SqlTransaction tran, DataRow dados, String stJsonEnvio, RetornoIntegracaoTim retorno) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:300a8872-1c04-4b3a-951a-624527ebaea3 Error Number:1205,State:52,Class:13 [16:32:05.4292538] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_IANKCELL_SC - Pedido: $227787 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 451 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [16:34:15.9067103] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_IANKCELL_SC - Pedido: $227786 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 451 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [16:36:16.4800710] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FORTTELECOM_CE - Pedido: $282899 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Data.SqlClient.SqlException (0x80131904): Cannot continue the execution because the session is in the kill state. A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) at wsCaixa.Banco.fnBanco.executeComTransacao(String stQuery, SqlConnection Conn, SqlTransaction Tran, Boolean throws) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Data.cs:line 113 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 140 ClientConnectionId:b396966d-a6f6-4a46-8c86-99be1bd97f5d Error Number:596,State:1,Class:21 [16:36:30.5431287] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_DMHDIVINOPOLIS_MG - Pedido: $58732 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Data.SqlClient.SqlException (0x80131904): Cannot continue the execution because the session is in the kill state. A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) at wsCaixa.Banco.fnBanco.executeComTransacao(String stQuery, SqlConnection Conn, SqlTransaction Tran, Boolean throws) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Data.cs:line 113 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 140 ClientConnectionId:146fe337-6054-4dd6-87dd-b43b0b4831e6 Error Number:596,State:1,Class:21 [16:45:19.2915503] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_IANKCELL_SC - Pedido: $227747 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 451 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [17:25:21.8923987] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72504007,"dt_importado":"2024-08-29T17:24:52.18","nom_cliente":"DANILLO MARCOS TEIXEIRA","ddd":83,"num_telefone":996655616,"num_documento":"70789768437","dt_servico":"2024-08-29T17:24:52.18","nom_plano":"TIM BLACK DEPENDENTE","SerialId":283582,"imei":null,"valor_aparelho":0.01,"val_entrada_dinh":0.01,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":null,"qtde_parc_1":null,"vl_cartao_credito_1":null,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"0.00","nom_tipo_negociacao":"","vl_pre_tabela":0.00,"dt_sellin":"2024-07-18T00:00:00","dt_sellout":"2024-08-29T17:25:15","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"25240811105504000788650010000593411007436905","num_dsf":"53129","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-29T17:25:10.853","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"304261","custcode_nivel_75":"NE80_NEN03I_NE8175_PT04","Serial_Acessorio":"","ICCID":"89550287500012072204","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_CONECTRIO_PB","tipo":"Venda","idpedido_origem":304261,"retorno_json":"[{\"cod_importacao\":72504007,\"imei\":null,\"num_telefone\":996655616,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 1408) entrou em deadlock em bloquear | buffer de comunicação recursos com outro processo e foi escolhida como a vítima do deadlock. Execute a transação novamente. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at wsCaixa.Banco.IntegracaoCaixaTim.SalvarDadosTimCentralizado(SqlConnection conn, SqlTransaction tran, DataRow dados, String stJsonEnvio, RetornoIntegracaoTim retorno) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:dfbe9f8e-77e1-4948-b8b0-d99faa8c7cd3 Error Number:1205,State:52,Class:13