[09:15:34.4103644] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72199109,"dt_importado":"2024-08-02T16:05:05.39","nom_cliente":"POLLYANNA MERLIM CASTILHO","ddd":61,"num_telefone":981954344,"num_documento":"91824192215","dt_servico":"2024-08-02T16:05:05.39","nom_plano":"TIM CONTROLE REDES SOCIAIS 6.0","SerialId":100255,"imei":356722910428183,"valor_aparelho":999.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":78073,"qtde_parc_1":6,"vl_cartao_credito_1":1078.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":1599.00,"dt_sellin":"2024-05-08T00:00:00","dt_sellout":"2024-08-07T09:15:00","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"53240811775328001500550000000075891012097145","num_dsf":"87656","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016081","dt_operacao":"2024-08-07T09:15:13.33","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"193536","custcode_nivel_75":"CS60_MGBSBI_PT2861_A003","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","database_name":"DTS39_TIM_TELECEL_DF","tipo":"Venda","idpedido_origem":193536,"retorno_json":"[{\"cod_importacao\":72199109,\"imei\":\"356722910428183\",\"num_telefone\":981954344,\"erro\":\"sem erro, importado com sucesso.\"}]"},{"item":2,"cod_importacao":null,"dt_importado":"2024-08-02T16:05:05.39","nom_cliente":"POLLYANNA MERLIM CASTILHO","ddd":61,"num_telefone":981954344,"num_documento":"91824192215","dt_servico":"2024-08-02T16:05:05.39","nom_plano":"TIM CONTROLE REDES SOCIAIS 6.0","SerialId":105291,"imei":null,"valor_aparelho":10.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":78073,"qtde_parc_1":6,"vl_cartao_credito_1":1078.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-06T00:00:00","dt_sellout":"2024-08-07T09:15:00","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"53240811775328001500550000000075891012097145","num_dsf":"87656","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T09:15:13.33","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"193536","custcode_nivel_75":"CS60_MGBSBI_PT2861_A003","Serial_Acessorio":"","ICCID":"89550467000013453265","Fidelizacao":"SIM","item_juros":"NÃO","database_name":null,"tipo":null,"idpedido_origem":null,"retorno_json":null},{"item":3,"cod_importacao":null,"dt_importado":"2024-08-02T16:05:05.39","nom_cliente":"POLLYANNA MERLIM CASTILHO","ddd":0,"num_telefone":0,"num_documento":"91824192215","dt_servico":"2024-08-02T16:05:05.39","nom_plano":"","SerialId":null,"imei":null,"valor_aparelho":69.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":78073,"qtde_parc_1":6,"vl_cartao_credito_1":1078.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":null,"dt_sellout":"2024-08-07T09:15:00","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"53240811775328001500550000000075891012097145","num_dsf":"87656","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T09:15:13.33","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":149.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"193536","custcode_nivel_75":"CS60_MGBSBI_PT2861_A003","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":null,"tipo":null,"idpedido_origem":null,"retorno_json":null}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 106) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:c033fbce-f7f4-44ab-b578-a33fe46fee04 Error Number:1205,State:52,Class:13 [09:16:02.0842039] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72199109,"dt_importado":"2024-08-02T16:05:05.39","nom_cliente":"POLLYANNA MERLIM CASTILHO","ddd":61,"num_telefone":981954344,"num_documento":"91824192215","dt_servico":"2024-08-02T16:05:05.39","nom_plano":"TIM CONTROLE REDES SOCIAIS 6.0","SerialId":100255,"imei":356722910428183,"valor_aparelho":999.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":78073,"qtde_parc_1":6,"vl_cartao_credito_1":1078.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":1599.00,"dt_sellin":"2024-05-08T00:00:00","dt_sellout":"2024-08-07T09:15:00","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"53240811775328001500550000000075891012097145","num_dsf":"87656","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016081","dt_operacao":"2024-08-07T09:15:13.33","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"193536","custcode_nivel_75":"CS60_MGBSBI_PT2861_A003","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","database_name":"DTS39_TIM_TELECEL_DF","tipo":"Venda","idpedido_origem":193536,"retorno_json":"[{\"cod_importacao\":72199109,\"imei\":\"356722910428183\",\"num_telefone\":981954344,\"erro\":\"sem erro, importado com sucesso.\"}]"},{"item":2,"cod_importacao":72199114,"dt_importado":"2024-08-02T16:05:05.39","nom_cliente":"POLLYANNA MERLIM CASTILHO","ddd":61,"num_telefone":981954344,"num_documento":"91824192215","dt_servico":"2024-08-02T16:05:05.39","nom_plano":"TIM CONTROLE REDES SOCIAIS 6.0","SerialId":105291,"imei":null,"valor_aparelho":10.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":78073,"qtde_parc_1":6,"vl_cartao_credito_1":1078.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-06T00:00:00","dt_sellout":"2024-08-07T09:15:00","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"53240811775328001500550000000075891012097145","num_dsf":"87656","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T09:15:13.33","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"193536","custcode_nivel_75":"CS60_MGBSBI_PT2861_A003","Serial_Acessorio":"","ICCID":"89550467000013453265","Fidelizacao":"SIM","item_juros":"NÃO","database_name":"DTS39_TIM_TELECEL_DF","tipo":"Venda","idpedido_origem":193536,"retorno_json":"[{\"cod_importacao\":72199114,\"imei\":null,\"num_telefone\":981954344,\"erro\":\"sem erro, importado com sucesso.\"}]"},{"item":3,"cod_importacao":null,"dt_importado":"2024-08-02T16:05:05.39","nom_cliente":"POLLYANNA MERLIM CASTILHO","ddd":0,"num_telefone":0,"num_documento":"91824192215","dt_servico":"2024-08-02T16:05:05.39","nom_plano":"","SerialId":null,"imei":null,"valor_aparelho":69.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":78073,"qtde_parc_1":6,"vl_cartao_credito_1":1078.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":null,"dt_sellout":"2024-08-07T09:15:00","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"53240811775328001500550000000075891012097145","num_dsf":"87656","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T09:15:13.33","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":149.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"193536","custcode_nivel_75":"CS60_MGBSBI_PT2861_A003","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":null,"tipo":null,"idpedido_origem":null,"retorno_json":null}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 106) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:ab6e43f3-4c4f-4c49-95aa-a6e4ffa54103 Error Number:1205,State:52,Class:13 [09:16:15.3029396] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72199109,"dt_importado":"2024-08-02T16:05:05.39","nom_cliente":"POLLYANNA MERLIM CASTILHO","ddd":61,"num_telefone":981954344,"num_documento":"91824192215","dt_servico":"2024-08-02T16:05:05.39","nom_plano":"TIM CONTROLE REDES SOCIAIS 6.0","SerialId":100255,"imei":356722910428183,"valor_aparelho":999.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":78073,"qtde_parc_1":6,"vl_cartao_credito_1":1078.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":1599.00,"dt_sellin":"2024-05-08T00:00:00","dt_sellout":"2024-08-07T09:15:00","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"53240811775328001500550000000075891012097145","num_dsf":"87656","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016081","dt_operacao":"2024-08-07T09:15:13.33","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"193536","custcode_nivel_75":"CS60_MGBSBI_PT2861_A003","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","database_name":"DTS39_TIM_TELECEL_DF","tipo":"Venda","idpedido_origem":193536,"retorno_json":"[{\"cod_importacao\":72199109,\"imei\":\"356722910428183\",\"num_telefone\":981954344,\"erro\":\"sem erro, importado com sucesso.\"}]"},{"item":2,"cod_importacao":72199114,"dt_importado":"2024-08-02T16:05:05.39","nom_cliente":"POLLYANNA MERLIM CASTILHO","ddd":61,"num_telefone":981954344,"num_documento":"91824192215","dt_servico":"2024-08-02T16:05:05.39","nom_plano":"TIM CONTROLE REDES SOCIAIS 6.0","SerialId":105291,"imei":null,"valor_aparelho":10.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":78073,"qtde_parc_1":6,"vl_cartao_credito_1":1078.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-06T00:00:00","dt_sellout":"2024-08-07T09:15:00","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"53240811775328001500550000000075891012097145","num_dsf":"87656","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T09:15:13.33","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"193536","custcode_nivel_75":"CS60_MGBSBI_PT2861_A003","Serial_Acessorio":"","ICCID":"89550467000013453265","Fidelizacao":"SIM","item_juros":"NÃO","database_name":"DTS39_TIM_TELECEL_DF","tipo":"Venda","idpedido_origem":193536,"retorno_json":"[{\"cod_importacao\":72199114,\"imei\":null,\"num_telefone\":981954344,\"erro\":\"sem erro, importado com sucesso.\"}]"},{"item":3,"cod_importacao":72199118,"dt_importado":"2024-08-02T16:05:05.39","nom_cliente":"POLLYANNA MERLIM CASTILHO","ddd":0,"num_telefone":0,"num_documento":"91824192215","dt_servico":"2024-08-02T16:05:05.39","nom_plano":"","SerialId":null,"imei":null,"valor_aparelho":69.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":78073,"qtde_parc_1":6,"vl_cartao_credito_1":1078.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":null,"dt_sellout":"2024-08-07T09:15:00","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"53240811775328001500550000000075891012097145","num_dsf":"87656","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T09:15:13.33","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":149.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"193536","custcode_nivel_75":"CS60_MGBSBI_PT2861_A003","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_TELECEL_DF","tipo":"Venda","idpedido_origem":193536,"retorno_json":"[{\"cod_importacao\":72199118,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 106) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:ab6e43f3-4c4f-4c49-95aa-a6e4ffa54103 Error Number:1205,State:52,Class:13 [09:18:31.3075269] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72199129,"dt_importado":"2024-08-05T12:15:28.573","nom_cliente":"FRANCISCA NUNES DE BRITO","ddd":61,"num_telefone":986056837,"num_documento":"61936707187","dt_servico":"2024-08-05T12:15:28.573","nom_plano":"","SerialId":100476,"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-05-08T00:00:00","dt_sellout":"2024-08-07T09:18:12","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"53240811775328001500550000000075911012100632","num_dsf":"87656","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"04010937 EX-OI","dt_operacao":"2024-08-07T09:18:18.03","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"193927","custcode_nivel_75":"CS60_MGBSBI_PT2861_A003","Serial_Acessorio":"","ICCID":"89550467000012700724","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_TELECEL_DF","tipo":"Venda","idpedido_origem":193927,"retorno_json":"[{\"cod_importacao\":72199129,\"imei\":null,\"num_telefone\":986056837,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 106) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:ab6e43f3-4c4f-4c49-95aa-a6e4ffa54103 Error Number:1205,State:52,Class:13 [09:19:26.2189164] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72199138,"dt_importado":"2024-08-06T18:37:40.903","nom_cliente":"RAYANA VIANA DOS SANTOS","ddd":0,"num_telefone":0,"num_documento":"05734960136","dt_servico":"2024-08-06T18:37:40.903","nom_plano":"","SerialId":99677,"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":null,"qtde_parc_1":null,"vl_cartao_credito_1":null,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"0.00","nom_tipo_negociacao":"","vl_pre_tabela":0.00,"dt_sellin":"2024-04-26T00:00:00","dt_sellout":"2024-08-07T09:18:44","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"53240811775328001500550000000075921012103523","num_dsf":"87656","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T09:19:21.097","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"194211","custcode_nivel_75":"CS60_MGBSBI_PT2861_A003","Serial_Acessorio":"","ICCID":"89550468000004386192","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_TELECEL_DF","tipo":"Venda","idpedido_origem":194211,"retorno_json":"[{\"cod_importacao\":72199138,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 109) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:41eff787-bc76-4706-96cc-8b815a91df60 Error Number:1205,State:52,Class:13 [09:26:13.9392962] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72199178,"dt_importado":"2024-08-06T11:31:36.43","nom_cliente":"elzira luiza de oliveira","ddd":44,"num_telefone":999441891,"num_documento":"08566281829","dt_servico":"2024-08-06T11:31:36.43","nom_plano":"TIM BLACK B LIGHT 5.0","SerialId":118326,"imei":356722910781110,"valor_aparelho":1199.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":7755,"qtde_parc_1":12,"vl_cartao_credito_1":1199.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"400.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":1599.00,"dt_sellin":"2024-02-16T00:00:00","dt_sellout":"2024-08-07T09:25:48","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"41240820654202001560550010000035641012262624","num_dsf":"92874","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016083","dt_operacao":"2024-08-07T09:25:54.17","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"276777","custcode_nivel_75":"TS40_TSAGCI_RV0328_A012","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_LEMAR_PR","tipo":"Venda","idpedido_origem":276777,"retorno_json":"[{\"cod_importacao\":72199178,\"imei\":\"356722910781110\",\"num_telefone\":999441891,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 517) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:621f211c-847e-49d5-846a-a2b06f6c0aeb Error Number:1205,State:52,Class:13 [09:26:43.0642116] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72199186,"dt_importado":"2024-08-07T09:24:35.143","nom_cliente":"SIDNEI ALVES MAURICIO","ddd":21,"num_telefone":968393698,"num_documento":"94902402734","dt_servico":"2024-08-07T09:24:35.143","nom_plano":"TIM CONTROLE REDES SOCIAIS 6.0","SerialId":30989,"imei":null,"valor_aparelho":0.01,"val_entrada_dinh":0.01,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":null,"qtde_parc_1":null,"vl_cartao_credito_1":null,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"0.00","nom_tipo_negociacao":"","vl_pre_tabela":0.00,"dt_sellin":"2024-08-06T00:00:00","dt_sellout":"2024-08-07T09:26:15","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"33240810876915000623550010000026191011321816","num_dsf":"95954","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T09:26:26.153","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"110181","custcode_nivel_75":"RN20_MGSULI_RV6451_A003","Serial_Acessorio":"","ICCID":"89550227001022126158","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_FDV_RJ","tipo":"Venda","idpedido_origem":110181,"retorno_json":"[{\"cod_importacao\":72199186,\"imei\":null,\"num_telefone\":968393698,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 517) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:621f211c-847e-49d5-846a-a2b06f6c0aeb Error Number:1205,State:52,Class:13 [09:29:07.9714181] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_POSITIVA_RJ - Pedido: $189146 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:29:30.4870705] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642423 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:30:21.0719266] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642422 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:30:22.4469192] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642424 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:32:18.9529651] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ROCHATELECOM_SP - Pedido: $293184 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:33:22.6134039] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_LEMAR_PR - Pedido: $277077 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:34:25.2128615] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_TELECEL_DF - Pedido: $193356 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:35:21.5922819] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72201854,"dt_importado":"2024-08-06T16:57:41.97","nom_cliente":"HIGOR IVAN DA SILVA GOIS","ddd":0,"num_telefone":0,"num_documento":"48208829889","dt_servico":"2024-08-06T16:57:41.97","nom_plano":"","SerialId":null,"imei":null,"valor_aparelho":89.90,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":null,"qtde_parc_1":null,"vl_cartao_credito_1":null,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"0.00","nom_tipo_negociacao":"","vl_pre_tabela":0.00,"dt_sellin":null,"dt_sellout":"2024-08-07T09:35:09","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"35240811378319002115550010000065921013217504","num_dsf":"87065","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T09:35:17.86","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":89.90,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"293084","custcode_nivel_75":"SP10_MGBAUI_PT2833_A020","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_ROCHATELECOM_SP","tipo":"Venda","idpedido_origem":293084,"retorno_json":"[{\"cod_importacao\":72201854,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 110) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:6fd89b16-cafc-49d0-9532-25b9acd0e87f Error Number:1205,State:52,Class:13 [09:36:52.7515033] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642425 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:37:20.0014913] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72202340,"dt_importado":"2024-08-06T18:31:27.9","nom_cliente":"JOAO PAULO SILVA SANTOS","ddd":61,"num_telefone":981957239,"num_documento":"04547456135","dt_servico":"2024-08-06T18:31:27.9","nom_plano":"TIM BLACK A 6.0","SerialId":106098,"imei":null,"valor_aparelho":10.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":10.00,"cod_aut_1":324171,"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-06-06T00:00:00","dt_sellout":"2024-08-07T09:37:04","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"53240811775328001925550020000149031012103514","num_dsf":"66377","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T09:37:17.647","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"194210","custcode_nivel_75":"CS60_MGBSBI_RV3063_A005","Serial_Acessorio":"","ICCID":"89550467000013396332","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_TELECEL_DF","tipo":"Venda","idpedido_origem":194210,"retorno_json":"[{\"cod_importacao\":72202340,\"imei\":null,\"num_telefone\":981957239,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 1785) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:360d4044-8df6-4075-b722-cf4c4482d027 Error Number:1205,State:52,Class:13 [09:38:34.6617517] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_TELECEL_DF - Pedido: $194210 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:40:13.7128027] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $718763 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:40:21.6346759] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ROCHATELECOM_SP - Pedido: $293084 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:40:31.1190453] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_LEMAR_PR - Pedido: $276943 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:41:22.1692347] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_CONECTRIO_PB - Pedido: $279551 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:41:37.3411086] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_CONECTRIO_PB - Pedido: $279553 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:42:12.5150804] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_MCTELECOM - Pedido: $204474 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:42:15.9369006] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_CONECTRIO_PB - Pedido: $279554 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:42:20.8744009] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_LEMAR_PR - Pedido: $277080 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:42:57.7322230] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642429 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:42:58.0595128] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_LEMAR_PR - Pedido: $277082 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:43:54.6400513] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_CONECTRIO_PB - Pedido: $279552 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:45:26.8425521] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_LEMAR_PR - Pedido: $277088 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:46:00.1012497] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72204543,"dt_importado":"2024-08-07T09:44:11.627","nom_cliente":"REGINALDO AMORIM","ddd":48,"num_telefone":999525971,"num_documento":"03680574967","dt_servico":"2024-08-07T09:44:11.627","nom_plano":"TIM CONTROLE SMART 6.0","SerialId":15044,"imei":null,"valor_aparelho":10.00,"val_entrada_dinh":10.00,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":null,"qtde_parc_1":null,"vl_cartao_credito_1":null,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"0.00","nom_tipo_negociacao":"","vl_pre_tabela":0.00,"dt_sellin":"2024-07-11T00:00:00","dt_sellout":"2024-08-07T09:45:52","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"42240830191641000131550010000020441011049281","num_dsf":"74724","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T09:45:57.863","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"104751","custcode_nivel_75":"TS40_TSAGCI_RV9993_A001","Serial_Acessorio":"","ICCID":"89550447000025253070","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_TIJUCAS_SC","tipo":"Venda","idpedido_origem":104751,"retorno_json":"[{\"cod_importacao\":72204543,\"imei\":null,\"num_telefone\":999525971,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 367) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:8bac7bb9-65ea-4f75-8fe8-3da53f956083 Error Number:1205,State:52,Class:13 [09:46:27.0572811] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_LEMAR_PR - Pedido: $277084 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:47:23.7403095] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FACELL_RN - Pedido: $621545 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:49:31.9833685] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_MASTERCELLCOMERCIO_SC - Pedido: $299687 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:49:37.1239877] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642430 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:52:37.2112743] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72205484,"dt_importado":"2024-08-07T09:40:08.25","nom_cliente":"JULIANO HENRIQUE BATISTEL","ddd":0,"num_telefone":0,"num_documento":"12135541958","dt_servico":"2024-08-07T09:40:08.25","nom_plano":"","SerialId":22649,"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-02-16T00:00:00","dt_sellout":"2024-08-07T09:52:32","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"41240800995956000251650010000041141011048626","num_dsf":"75449","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T09:52:36.01","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"103552","custcode_nivel_75":"TS40_TSAGCI_TS2776_A002","Serial_Acessorio":"","ICCID":"89550448000008495036","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_TELECOMPANY_PR","tipo":"Venda","idpedido_origem":103552,"retorno_json":"[{\"cod_importacao\":72205484,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 232) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:6751d649-34e5-413a-816f-d9dcf7464b1c Error Number:1205,State:52,Class:13 [09:53:18.7691139] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FACELL_RN - Pedido: $621546 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:54:26.5074441] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72205648,"dt_importado":"2024-08-07T09:49:59.937","nom_cliente":"RUITHER DA SILVA LOIOLA","ddd":96,"num_telefone":981240494,"num_documento":"57737991204","dt_servico":"2024-08-07T09:49:59.937","nom_plano":"TIM BLACK MULTI A HERO 5.0","SerialId":93742,"imei":355970160398595,"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":199300,"qtde_parc_1":12,"vl_cartao_credito_1":4218.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"3300.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":7299.00,"dt_sellin":"2024-07-12T00:00:00","dt_sellout":"2024-08-07T09:54:12","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"16240802254271000107550010000753341012020843","num_dsf":"12756","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015711","dt_operacao":"2024-08-07T09:54:18.113","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"190447","custcode_nivel_75":"RN90_MGPMPI_PT0087_A001","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","database_name":"DTS39_TIM_SALINASSAR_AP","tipo":"Venda","idpedido_origem":190447,"retorno_json":"[{\"cod_importacao\":72205648,\"imei\":\"355970160398595\",\"num_telefone\":981240494,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 1070) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:46403620-9f23-4a27-959e-837596e24d54 Error Number:1205,State:52,Class:13 [09:54:34.3992695] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642431 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:57:39.9080836] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FACELL_RN - Pedido: $621547 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [09:57:57.7235248] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FACELL_RN - Pedido: $621549 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:23:09.6031742] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72207682,"dt_importado":"2024-08-07T10:12:55.557","nom_cliente":"DIEGO PINHEIRO GONCALVES","ddd":81,"num_telefone":995415644,"num_documento":"06298008470","dt_servico":"2024-08-07T10:12:55.557","nom_plano":"TIM BLACK MULTI B 6.0","SerialId":163382,"imei":356323451472761,"valor_aparelho":3299.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":10.00,"cod_aut_1":533757,"qtde_parc_1":10,"vl_cartao_credito_1":3299.00,"cod_aut_2":137050,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"3000.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":6299.00,"dt_sellin":"2024-08-05T00:00:00","dt_sellout":"2024-08-07T10:22:49","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"26240803370545000420550010000011391004007069","num_dsf":"59689","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04014833","dt_operacao":"2024-08-07T10:22:51.16","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"250857","custcode_nivel_75":"NE80_NEN04I_NE8271_A001","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","database_name":"DTS39_TIM_GEOLIVEIRA_AL","tipo":"Venda","idpedido_origem":250857,"retorno_json":"[{\"cod_importacao\":72207682,\"imei\":\"356323451472761\",\"num_telefone\":995415644,\"erro\":\"sem erro, importado com sucesso.\"}]"},{"item":2,"cod_importacao":null,"dt_importado":"2024-08-07T10:12:55.557","nom_cliente":"DIEGO PINHEIRO GONCALVES","ddd":81,"num_telefone":995415644,"num_documento":"06298008470","dt_servico":"2024-08-07T10:12:55.557","nom_plano":"TIM BLACK MULTI B 6.0","SerialId":160241,"imei":null,"valor_aparelho":10.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":10.00,"cod_aut_1":533757,"qtde_parc_1":10,"vl_cartao_credito_1":3299.00,"cod_aut_2":137050,"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-07-05T00:00:00","dt_sellout":"2024-08-07T10:22:49","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"26240803370545000420550010000011391004007069","num_dsf":"59689","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T10:22:51.16","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"250857","custcode_nivel_75":"NE80_NEN04I_NE8271_A001","Serial_Acessorio":"","ICCID":"89550288000004659182","Fidelizacao":"SIM","item_juros":"NÃO","database_name":null,"tipo":null,"idpedido_origem":null,"retorno_json":null}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 658) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:4b99884b-c393-485f-b8e4-cdf212a26646 Error Number:1205,State:52,Class:13 [10:23:27.1812953] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72207747,"dt_importado":"2024-08-07T10:21:34.247","nom_cliente":"IVONETE VIEIRA DOS SANTOS","ddd":44,"num_telefone":997688628,"num_documento":"67582516915","dt_servico":"2024-08-07T10:21:34.247","nom_plano":"TIM CONTROLE SMART 6.0","SerialId":137103,"imei":null,"valor_aparelho":10.00,"val_entrada_dinh":10.00,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":null,"qtde_parc_1":null,"vl_cartao_credito_1":null,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"0.00","nom_tipo_negociacao":"","vl_pre_tabela":0.00,"dt_sellin":"2024-06-11T00:00:00","dt_sellout":"2024-08-07T10:23:01","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"41240820654202001721550010000086481012265109","num_dsf":"93705","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T10:23:08.09","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"277117","custcode_nivel_75":"TS40_TSAGCI_RV0328_A013","Serial_Acessorio":"","ICCID":"89550447000024199621","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_LEMAR_PR","tipo":"Venda","idpedido_origem":277117,"retorno_json":"[{\"cod_importacao\":72207747,\"imei\":null,\"num_telefone\":997688628,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 2039) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:b474987e-9706-4fb6-9def-832df6191203 Error Number:1205,State:52,Class:13 [10:23:42.1188085] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72207682,"dt_importado":"2024-08-07T10:12:55.557","nom_cliente":"DIEGO PINHEIRO GONCALVES","ddd":81,"num_telefone":995415644,"num_documento":"06298008470","dt_servico":"2024-08-07T10:12:55.557","nom_plano":"TIM BLACK MULTI B 6.0","SerialId":163382,"imei":356323451472761,"valor_aparelho":3299.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":10.00,"cod_aut_1":533757,"qtde_parc_1":10,"vl_cartao_credito_1":3299.00,"cod_aut_2":137050,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"3000.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":6299.00,"dt_sellin":"2024-08-05T00:00:00","dt_sellout":"2024-08-07T10:22:49","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"26240803370545000420550010000011391004007069","num_dsf":"59689","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04014833","dt_operacao":"2024-08-07T10:22:51.16","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"250857","custcode_nivel_75":"NE80_NEN04I_NE8271_A001","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","database_name":"DTS39_TIM_GEOLIVEIRA_AL","tipo":"Venda","idpedido_origem":250857,"retorno_json":"[{\"cod_importacao\":72207682,\"imei\":\"356323451472761\",\"num_telefone\":995415644,\"erro\":\"sem erro, importado com sucesso.\"}]"},{"item":2,"cod_importacao":72207756,"dt_importado":"2024-08-07T10:12:55.557","nom_cliente":"DIEGO PINHEIRO GONCALVES","ddd":81,"num_telefone":995415644,"num_documento":"06298008470","dt_servico":"2024-08-07T10:12:55.557","nom_plano":"TIM BLACK MULTI B 6.0","SerialId":160241,"imei":null,"valor_aparelho":10.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":10.00,"cod_aut_1":533757,"qtde_parc_1":10,"vl_cartao_credito_1":3299.00,"cod_aut_2":137050,"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-07-05T00:00:00","dt_sellout":"2024-08-07T10:22:49","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"26240803370545000420550010000011391004007069","num_dsf":"59689","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T10:22:51.16","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"250857","custcode_nivel_75":"NE80_NEN04I_NE8271_A001","Serial_Acessorio":"","ICCID":"89550288000004659182","Fidelizacao":"SIM","item_juros":"NÃO","database_name":"DTS39_TIM_GEOLIVEIRA_AL","tipo":"Venda","idpedido_origem":250857,"retorno_json":"[{\"cod_importacao\":72207756,\"imei\":null,\"num_telefone\":995415644,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 658) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:4b99884b-c393-485f-b8e4-cdf212a26646 Error Number:1205,State:52,Class:13 [10:27:19.2711597] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72208483,"dt_importado":"2024-08-07T10:13:18.94","nom_cliente":"DIEGO PINHEIRO GONCALVES","ddd":81,"num_telefone":995416966,"num_documento":"06298008470","dt_servico":"2024-08-07T10:13:18.94","nom_plano":"TIM BLACK DEPENDENTE","SerialId":159449,"imei":null,"valor_aparelho":10.00,"val_entrada_dinh":0.01,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":9.99,"cod_aut_1":237202,"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-06-29T00:00:00","dt_sellout":"2024-08-07T10:27:01","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"26240803370545000420550010000011401004007116","num_dsf":"59689","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T10:27:08.797","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"250858","custcode_nivel_75":"NE80_NEN04I_NE8271_A001","Serial_Acessorio":"","ICCID":"89550287000014492518","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_GEOLIVEIRA_AL","tipo":"Venda","idpedido_origem":250858,"retorno_json":"[{\"cod_importacao\":72208483,\"imei\":null,\"num_telefone\":995416966,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 2039) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:b474987e-9706-4fb6-9def-832df6191203 Error Number:1205,State:52,Class:13 [10:31:41.1704454] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72209704,"dt_importado":"2024-08-07T10:31:00.743","nom_cliente":"ANA LUCIA DA SILVA BARBOSA GUIMARAES","ddd":44,"num_telefone":998600009,"num_documento":"88507947972","dt_servico":"2024-08-07T10:31:00.743","nom_plano":"TIM BLACK DEPENDENTE","SerialId":127679,"imei":null,"valor_aparelho":10.00,"val_entrada_dinh":10.00,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":null,"qtde_parc_1":null,"vl_cartao_credito_1":null,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"0.00","nom_tipo_negociacao":"","vl_pre_tabela":0.00,"dt_sellin":"2024-06-11T00:00:00","dt_sellout":"2024-08-07T10:31:35","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"41240842570270000420650010000098861002049191","num_dsf":"86267","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T10:31:39.963","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"252336","custcode_nivel_75":"TS40_TSPLUI_PT0150_A003","Serial_Acessorio":"","ICCID":"89550448000008994996","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_BATIMALDONADO","tipo":"Venda","idpedido_origem":252336,"retorno_json":"[{\"cod_importacao\":72209704,\"imei\":null,\"num_telefone\":998600009,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 817) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:f5a41ced-cac4-41a0-b8b0-e4c128265552 Error Number:1205,State:52,Class:13 [10:33:23.1785914] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_GEOLIVEIRA_AL - Pedido: $250864 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:33:24.9286476] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72210170,"dt_importado":"2024-08-07T10:28:01.293","nom_cliente":"WESLEY PONTES","ddd":0,"num_telefone":0,"num_documento":"63574039115","dt_servico":"2024-08-07T10:28:01.293","nom_plano":"","SerialId":98472,"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":137717,"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-26T00:00:00","dt_sellout":"2024-08-07T10:33:02","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"53240811775328000287550010000333201012104103","num_dsf":"42710","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T10:33:11.333","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"194263","custcode_nivel_75":"CS60_MGBSBI_RV3063_A002","Serial_Acessorio":"","ICCID":"89550468000004063148","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_TELECEL_DF","tipo":"Venda","idpedido_origem":194263,"retorno_json":"[{\"cod_importacao\":72210170,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 2188) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:d6f63aa4-1062-4504-8a95-19f36c086641 Error Number:1205,State:52,Class:13 [10:34:56.2822205] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_GEOLIVEIRA_AL - Pedido: $250863 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:35:40.5049323] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72210820,"dt_importado":"2024-08-07T10:33:53.87","nom_cliente":"DIEGO SANTORELI GUIMARAES DE OLIVEIRA","ddd":0,"num_telefone":0,"num_documento":"08291925658","dt_servico":"2024-08-07T10:33:53.87","nom_plano":"","SerialId":104301,"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":167384,"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-07-25T00:00:00","dt_sellout":"2024-08-07T10:35:31","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"31240803372209000921650010000184461011915996","num_dsf":"66777","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T10:35:37.1","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"175820","custcode_nivel_75":"MX30_MXMIGI_RV0053_A008","Serial_Acessorio":"","ICCID":"89550238000003713528","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_JMXTELECOM_MG","tipo":"Venda","idpedido_origem":175820,"retorno_json":"[{\"cod_importacao\":72210820,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 209) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:62bd2795-c2b4-4a47-8975-bd9de7c1c561 Error Number:1205,State:52,Class:13 [10:37:40.7956325] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72211345,"dt_importado":"2024-08-07T10:33:19.193","nom_cliente":"DIEGO PINHEIRO GONCALVES","ddd":81,"num_telefone":995415610,"num_documento":"06298008470","dt_servico":"2024-08-07T10:33:19.193","nom_plano":"TIM BLACK DEPENDENTE","SerialId":159448,"imei":null,"valor_aparelho":10.00,"val_entrada_dinh":0.02,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":9.98,"cod_aut_1":338034,"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-06-29T00:00:00","dt_sellout":"2024-08-07T10:37:31","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"26240803370545000420550010000011411004007172","num_dsf":"59689","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T10:37:35.797","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"250868","custcode_nivel_75":"NE80_NEN04I_NE8271_A001","Serial_Acessorio":"","ICCID":"89550287000014492500","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_GEOLIVEIRA_AL","tipo":"Venda","idpedido_origem":250868,"retorno_json":"[{\"cod_importacao\":72211345,\"imei\":null,\"num_telefone\":995415610,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 209) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:62bd2795-c2b4-4a47-8975-bd9de7c1c561 Error Number:1205,State:52,Class:13 [10:37:46.7956604] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642455 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:37:54.8268902] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_TELEMILCELULARES_PR - Pedido: $161257 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:38:24.2665356] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642452 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:38:50.9384110] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72211671,"dt_importado":"2024-08-07T10:35:45.363","nom_cliente":"SONIA FERREIRA DE ARAUJO NASCIMENTO","ddd":0,"num_telefone":0,"num_documento":"04459406462","dt_servico":"2024-08-07T10:35:45.363","nom_plano":"","SerialId":592785,"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":212675,"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-07-08T00:00:00","dt_sellout":"2024-08-07T10:38:40","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"26240821683365004982550020000041701015899158","num_dsf":"96137","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T10:38:48.99","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"718796","custcode_nivel_75":"NE80_NEN04I_NE0761_NE004","Serial_Acessorio":"","ICCID":"89550287000014589214","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_ALEGRIATELECOM_SP","tipo":"Venda","idpedido_origem":718796,"retorno_json":"[{\"cod_importacao\":72211671,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 1272) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:672e2e58-7699-430b-85a2-890169e74f12 Error Number:1205,State:52,Class:13 [10:39:57.1759493] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_GEOLIVEIRA_AL - Pedido: $250865 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:39:59.0040822] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_GEOLIVEIRA_AL - Pedido: $250868 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:40:13.1174348] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72211972,"dt_importado":"2024-08-07T10:06:14.817","nom_cliente":"MAURICIO FERREIRA","ddd":42,"num_telefone":998142105,"num_documento":"88284859904","dt_servico":"2024-08-07T10:06:14.817","nom_plano":"TIM CONTROLE REDES SOCIAIS 6.0","SerialId":98181,"imei":357567916623983,"valor_aparelho":1699.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":1699.00,"cod_aut_1":205851,"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":"700.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":2399.00,"dt_sellin":"2024-07-22T00:00:00","dt_sellout":"2024-08-07T10:39:58","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"41240805323673000520550000000030751011170050","num_dsf":"54370","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016095","dt_operacao":"2024-08-07T10:40:05.68","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"174524","custcode_nivel_75":"TS40_TSAGCI_TS0659_A003","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","database_name":"DTS39_TIM_VIVERECELULARES_PR","tipo":"Venda","idpedido_origem":174524,"retorno_json":"[{\"cod_importacao\":72211972,\"imei\":\"357567916623983\",\"num_telefone\":998142105,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 1272) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:672e2e58-7699-430b-85a2-890169e74f12 Error Number:1205,State:52,Class:13 [10:40:58.3629522] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642458 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:40:58.4410689] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_GEOLIVEIRA_AL - Pedido: $250869 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:41:53.0697282] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642459 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:42:54.7903663] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72212418,"dt_importado":"2024-08-07T10:41:31.487","nom_cliente":"NATILLA DE SOUSA TIGRE","ddd":47,"num_telefone":999563106,"num_documento":"03878850212","dt_servico":"2024-08-07T10:41:31.487","nom_plano":"TIM CONTROLE REDES SOCIAIS 6.0","SerialId":96459,"imei":null,"valor_aparelho":10.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":198951,"qtde_parc_1":1,"vl_cartao_credito_1":10.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"0.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":0.00,"dt_sellin":"2024-05-06T00:00:00","dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"48607","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T10:42:49.447","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"205169","custcode_nivel_75":"TS40_TSPLUI_TS0046_A007","Serial_Acessorio":"","ICCID":"89550448000008789990","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_IANKCELL_SC","tipo":"Venda","idpedido_origem":205169,"retorno_json":"[{\"cod_importacao\":72212418,\"imei\":null,\"num_telefone\":999563106,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 817) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:f5b491b2-0414-435c-86c9-a2e1377f13ae Error Number:1205,State:52,Class:13 [10:43:50.9499116] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $718796 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:44:17.7802691] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_POSITIVA_RJ - Pedido: $189168 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:44:55.9359769] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642457 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:44:59.0453364] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_GEOLIVEIRA_AL - Pedido: $250868 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:45:30.8764470] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72212951,"dt_importado":"2024-08-06T18:27:14.72","nom_cliente":"JOAO VITOR FREITAS DO MONTE","ddd":96,"num_telefone":981019795,"num_documento":"03881314202","dt_servico":"2024-08-06T18:27:14.72","nom_plano":"TIM BLACK DEPENDENTE","SerialId":79606,"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-02-19T00:00:00","dt_sellout":"2024-08-07T10:45:18","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"16240802254271000360550010000433311012020591","num_dsf":"21178","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T10:45:24.46","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"190428","custcode_nivel_75":"RN90_MGPMPI_PT0087_A003","Serial_Acessorio":"","ICCID":"89550297000006432405","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_SALINASSAR_AP","tipo":"Venda","idpedido_origem":190428,"retorno_json":"[{\"cod_importacao\":72212951,\"imei\":null,\"num_telefone\":981019795,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 1272) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:73912884-39d0-4c53-9f78-d41a1020d7b9 Error Number:1205,State:52,Class:13 [10:45:42.6420874] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_GEOLIVEIRA_AL - Pedido: $250856 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:46:09.0183803] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642462 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:47:14.9948247] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_IANKCELL_SC - Pedido: $205168 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:47:15.8229441] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_GEOLIVEIRA_AL - Pedido: $250870 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:47:17.1979276] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72213287,"dt_importado":"2024-08-07T10:23:48.057","nom_cliente":"MATHEUS DOS SANTOS GASQUES","ddd":17,"num_telefone":981029687,"num_documento":"41041025807","dt_servico":"2024-08-07T10:23:48.057","nom_plano":"TIM BLACK MULTI D 6.0","SerialId":236623,"imei":355970161692962,"valor_aparelho":3399.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":430973,"qtde_parc_1":12,"vl_cartao_credito_1":3399.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"3900.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":7299.00,"dt_sellin":"2024-07-29T00:00:00","dt_sellout":"2024-08-07T10:47:06","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"35240802356946002598550010000064511013214378","num_dsf":"80500","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015713","dt_operacao":"2024-08-07T10:47:12.013","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"317600","custcode_nivel_75":"SP10_MGPPEI_PT2849_A010","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","database_name":"DTS39_TIM_DPIDULCOM_PR","tipo":"Venda","idpedido_origem":317600,"retorno_json":"[{\"cod_importacao\":72213287,\"imei\":\"355970161692962\",\"num_telefone\":981029687,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 422) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:640b402f-57b4-40de-8063-d4c68456a249 Error Number:1205,State:52,Class:13 [10:47:32.4635526] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72213353,"dt_importado":"2024-08-07T10:39:35.49","nom_cliente":"DEBORAH DE JESUS SOUSA PORTO","ddd":62,"num_telefone":991767105,"num_documento":"04791333101","dt_servico":"2024-08-07T10:39:35.49","nom_plano":"","SerialId":19484,"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-08T00:00:00","dt_sellout":"2024-08-07T10:47:24","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"52240842123720000194550010000115361010893720","num_dsf":"86254","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"04010937 EX-OI","dt_operacao":"2024-08-07T10:47:27.623","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"89318","custcode_nivel_75":"CS60_MGGOII_RV7480_A001","Serial_Acessorio":"","ICCID":"89550467000013191923","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_FOCOCELULARES_GO","tipo":"Venda","idpedido_origem":89318,"retorno_json":"[{\"cod_importacao\":72213353,\"imei\":null,\"num_telefone\":991767105,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 422) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:640b402f-57b4-40de-8063-d4c68456a249 Error Number:1205,State:52,Class:13 [10:48:06.2854795] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ROCHATELECOM_SP - Pedido: $293210 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:49:06.0612441] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_GEOLIVEIRA_AL - Pedido: $250871 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:49:13.7359610] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $718798 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:49:33.4232516] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642460 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:50:00.5706767] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ROCHATELECOM_SP - Pedido: $293211 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:51:23.4178495] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FACELL_RN - Pedido: $621580 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:51:59.0271998] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72214029,"dt_importado":"2024-08-07T10:47:34.183","nom_cliente":"jose carlos lara da silva","ddd":42,"num_telefone":999254472,"num_documento":"02750134994","dt_servico":"2024-08-07T10:47:34.183","nom_plano":"TIM CONTROLE SMART 5.0","SerialId":83797,"imei":356722914397111,"valor_aparelho":1199.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":1199.00,"cod_aut_1":437898,"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":"400.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":1599.00,"dt_sellin":"2024-06-17T00:00:00","dt_sellout":"2024-08-07T10:51:21","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"41240812327025000183650010000221681011425637","num_dsf":"41844","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016081","dt_operacao":"2024-08-07T10:51:25.73","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"179488","custcode_nivel_75":"TS40_TSAGCI_TS2777_A001","Serial_Acessorio":"","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_MAETESON_PR","tipo":"Venda","idpedido_origem":179488,"retorno_json":"[{\"cod_importacao\":72214029,\"imei\":\"356722914397111\",\"num_telefone\":999254472,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 817) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:555a6432-ae3f-4d54-8465-f929807be4d3 Error Number:1205,State:52,Class:13 [10:52:13.1394720] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $718801 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:52:34.7800922] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642464 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:52:53.4363405] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $718800 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:53:11.3467445] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72214191,"dt_importado":"2024-08-07T10:40:23.443","nom_cliente":"MARIA IRISLANDIA DA SILVA","ddd":0,"num_telefone":0,"num_documento":"09369340424","dt_servico":"2024-08-07T10:40:23.443","nom_plano":"","SerialId":94251,"imei":null,"valor_aparelho":0.01,"val_entrada_dinh":null,"val_entrada_bol":0.01,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":null,"qtde_parc_1":null,"vl_cartao_credito_1":null,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"0.00","nom_tipo_negociacao":"","vl_pre_tabela":0.00,"dt_sellin":"2024-06-06T00:00:00","dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"85173","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T10:53:06.44","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"342953","custcode_nivel_75":"SP10_MGVALI_RV0561_A008","Serial_Acessorio":"","ICCID":"89550327001049314133","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_NONIS_INFORMATICA_SP","tipo":"Venda","idpedido_origem":342953,"retorno_json":"[{\"cod_importacao\":72214191,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 666) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:47d8bfd5-73da-475f-9baa-857213b97467 Error Number:1205,State:52,Class:13 [10:53:24.1743964] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642468 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:54:07.2450351] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ROCHATELECOM_SP - Pedido: $293212 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:54:09.0419015] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $718802 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:54:11.8543993] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_CONECTRIO_PB - Pedido: $279569 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:54:22.4481494] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $718797 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:54:26.0731509] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642463 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:54:27.6988372] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $718804 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:54:44.4794000] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FACELL_RN - Pedido: $621582 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:55:09.0129625] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_CONECTRIO_PB - Pedido: $279293 - Cancelamento: $False - Devolucao: $True - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:55:12.2785935] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642471 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:55:39.9035640] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642466 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:55:40.9045780] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FACELL_RN - Pedido: $621585 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:55:42.4194609] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642469 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:57:09.6271702] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $718772 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:57:13.7521887] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FACELL_RN - Pedido: $621578 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:57:23.4396708] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_IMAGEM_SP - Pedido: $354522 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:58:06.8637337] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FACELL_RN - Pedido: $621584 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:58:26.5981111] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72215049,"dt_importado":"2024-08-07T10:14:54.157","nom_cliente":"RUSLEY ALVES DA SILVA","ddd":99,"num_telefone":988524048,"num_documento":"47195100359","dt_servico":"2024-08-07T10:14:54.157","nom_plano":"","SerialId":43301,"imei":null,"valor_aparelho":0.01,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":0,"qtde_parc_1":1,"vl_cartao_credito_1":0.01,"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-07-11T00:00:00","dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"93268","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"04010932 EX-OI","dt_operacao":"2024-08-07T10:58:25.397","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"131299","custcode_nivel_75":"RN90_MGMARI_RV4887_A002","Serial_Acessorio":"","ICCID":"89550297000007360977","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_TALKLINETELECOM_MA","tipo":"Venda","idpedido_origem":131299,"retorno_json":"[{\"cod_importacao\":72215049,\"imei\":null,\"num_telefone\":988524048,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 476) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:96b6cdb6-3665-45e7-84c3-f763ab8a1fb4 Error Number:1205,State:52,Class:13 [10:58:58.3793786] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_LEMAR_PR - Pedido: $277144 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:59:08.0844886] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642475 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [10:59:16.2096338] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72215155,"dt_importado":"2024-08-07T10:40:23.443","nom_cliente":"MARIA IRISLANDIA DA SILVA","ddd":0,"num_telefone":0,"num_documento":"09369340424","dt_servico":"2024-08-07T10:40:23.443","nom_plano":"","SerialId":94251,"imei":null,"valor_aparelho":15.00,"val_entrada_dinh":15.00,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":null,"qtde_parc_1":null,"vl_cartao_credito_1":null,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"0.00","nom_tipo_negociacao":"","vl_pre_tabela":0.00,"dt_sellin":"2024-06-06T00:00:00","dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"85173","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T10:59:08.183","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"342953","custcode_nivel_75":"SP10_MGVALI_RV0561_A008","Serial_Acessorio":"","ICCID":"89550327001049314133","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_NONIS_INFORMATICA_SP","tipo":"Venda","idpedido_origem":342953,"retorno_json":"[{\"cod_importacao\":72215155,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 476) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:96b6cdb6-3665-45e7-84c3-f763ab8a1fb4 Error Number:1205,State:52,Class:13 [10:59:30.9282278] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72215188,"dt_importado":"2024-08-07T10:14:54.157","nom_cliente":"RUSLEY ALVES DA SILVA","ddd":99,"num_telefone":988524048,"num_documento":"47195100359","dt_servico":"2024-08-07T10:14:54.157","nom_plano":"","SerialId":43301,"imei":null,"valor_aparelho":0.01,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":0,"qtde_parc_1":1,"vl_cartao_credito_1":0.01,"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-07-11T00:00:00","dt_sellout":"2024-08-07T10:58:45","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"21240844944217000397550010000038431011338086","num_dsf":"93268","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"04010932 EX-OI","dt_operacao":"2024-08-07T10:59:22.41","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"131299","custcode_nivel_75":"RN90_MGMARI_RV4887_A002","Serial_Acessorio":"","ICCID":"89550297000007360977","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_TALKLINETELECOM_MA","tipo":"Venda","idpedido_origem":131299,"retorno_json":"[{\"cod_importacao\":72215188,\"imei\":null,\"num_telefone\":988524048,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 476) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:96b6cdb6-3665-45e7-84c3-f763ab8a1fb4 Error Number:1205,State:52,Class:13 [10:59:57.6469964] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72215271,"dt_importado":"2024-08-07T10:48:42.753","nom_cliente":"Luiz carlos lourenco ","ddd":0,"num_telefone":0,"num_documento":"75302640953","dt_servico":"2024-08-07T10:48:42.753","nom_plano":"","SerialId":100989,"imei":null,"valor_aparelho":699.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":699.00,"cod_aut_1":139368,"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-05-27T00:00:00","dt_sellout":"2024-08-07T10:59:16","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"42240808640305001494650010000417201011429375","num_dsf":"55021","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T10:59:53.65","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":699.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"205171","custcode_nivel_75":"TS40_TSPLUI_TS0046_A009","Serial_Acessorio":"R7AX40945BZ","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_IANKCELL_SC","tipo":"Venda","idpedido_origem":205171,"retorno_json":"[{\"cod_importacao\":72215271,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 479) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:e870edfa-a033-43a6-a76f-df9d14ff1774 Error Number:1205,State:52,Class:13 [11:00:05.4459454] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_IMAGEM_SP - Pedido: $354523 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:00:25.8990735] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72215330,"dt_importado":"2024-08-07T10:55:46.757","nom_cliente":"ELENITE CARVALHO","ddd":41,"num_telefone":999007265,"num_documento":"31770207953","dt_servico":"2024-08-07T10:55:46.757","nom_plano":"TIM CONTROLE SMART 6.0","SerialId":234291,"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-25T00:00:00","dt_sellout":"2024-08-07T10:59:44","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"41240802356946001605550010000109011013214417","num_dsf":"90293","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T11:00:20.87","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"317615","custcode_nivel_75":"TS40_TSAGCI_TS0363_A008","Serial_Acessorio":"","ICCID":"89550447000026292408","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_DPIDULCOM_PR","tipo":"Venda","idpedido_origem":317615,"retorno_json":"[{\"cod_importacao\":72215330,\"imei\":null,\"num_telefone\":999007265,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 476) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:96b6cdb6-3665-45e7-84c3-f763ab8a1fb4 Error Number:1205,State:52,Class:13 [11:00:29.3210962] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642467 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:00:48.4615874] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72215403,"dt_importado":"2024-08-07T10:59:23.773","nom_cliente":"inacia gomes de amorim","ddd":83,"num_telefone":996558176,"num_documento":"73809055468","dt_servico":"2024-08-07T10:59:23.773","nom_plano":"TIM CONTROLE A PLUS 6.0","SerialId":277518,"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-06-29T00:00:00","dt_sellout":"2024-08-07T11:00:11","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"25240811105504000605650010000901591007191588","num_dsf":"52805","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T11:00:48.21","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"279575","custcode_nivel_75":"NE80_NEN03I_NE8175_PT03","Serial_Acessorio":"","ICCID":"89550287500012012184","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_CONECTRIO_PB","tipo":"Venda","idpedido_origem":279575,"retorno_json":"[{\"cod_importacao\":72215403,\"imei\":null,\"num_telefone\":996558176,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 479) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:e870edfa-a033-43a6-a76f-df9d14ff1774 Error Number:1205,State:52,Class:13 [11:01:15.6155482] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72215478,"dt_importado":"2024-08-07T10:44:18.733","nom_cliente":"Luiz carlos lourenco ","ddd":0,"num_telefone":0,"num_documento":"75302640953","dt_servico":"2024-08-07T10:44:18.733","nom_plano":"","SerialId":95738,"imei":null,"valor_aparelho":100.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":681086,"qtde_parc_1":12,"vl_cartao_credito_1":1999.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-04-22T00:00:00","dt_sellout":"2024-08-07T11:00:36","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"42240808640305001494650010000417211011429380","num_dsf":"55021","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T11:01:13.147","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":100.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"205170","custcode_nivel_75":"TS40_TSPLUI_TS0046_A009","Serial_Acessorio":"RXAX4004LKR","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_IANKCELL_SC","tipo":"Venda","idpedido_origem":205170,"retorno_json":"[{\"cod_importacao\":72215478,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"},{"item":2,"cod_importacao":null,"dt_importado":"2024-08-07T10:44:18.733","nom_cliente":"Luiz carlos lourenco ","ddd":47,"num_telefone":996072012,"num_documento":"75302640953","dt_servico":"2024-08-07T10:44:18.733","nom_plano":"TIM BLACK MULTI B 6.0","SerialId":101307,"imei":359351340154867,"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":681086,"qtde_parc_1":12,"vl_cartao_credito_1":1999.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"2600.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":4499.00,"dt_sellin":"2024-06-19T00:00:00","dt_sellout":"2024-08-07T11:00:36","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"42240808640305001494650010000417211011429380","num_dsf":"55021","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015666","dt_operacao":"2024-08-07T11:01:13.147","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"205170","custcode_nivel_75":"TS40_TSPLUI_TS0046_A009","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","database_name":null,"tipo":null,"idpedido_origem":null,"retorno_json":null}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 476) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:96b6cdb6-3665-45e7-84c3-f763ab8a1fb4 Error Number:1205,State:52,Class:13 [11:01:18.2717925] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72215478,"dt_importado":"2024-08-07T10:44:18.733","nom_cliente":"Luiz carlos lourenco ","ddd":0,"num_telefone":0,"num_documento":"75302640953","dt_servico":"2024-08-07T10:44:18.733","nom_plano":"","SerialId":95738,"imei":null,"valor_aparelho":100.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":681086,"qtde_parc_1":12,"vl_cartao_credito_1":1999.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-04-22T00:00:00","dt_sellout":"2024-08-07T11:00:36","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"42240808640305001494650010000417211011429380","num_dsf":"55021","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T11:01:13.147","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":100.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"205170","custcode_nivel_75":"TS40_TSPLUI_TS0046_A009","Serial_Acessorio":"RXAX4004LKR","ICCID":"","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_IANKCELL_SC","tipo":"Venda","idpedido_origem":205170,"retorno_json":"[{\"cod_importacao\":72215478,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"},{"item":2,"cod_importacao":72215490,"dt_importado":"2024-08-07T10:44:18.733","nom_cliente":"Luiz carlos lourenco ","ddd":47,"num_telefone":996072012,"num_documento":"75302640953","dt_servico":"2024-08-07T10:44:18.733","nom_plano":"TIM BLACK MULTI B 6.0","SerialId":101307,"imei":359351340154867,"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":681086,"qtde_parc_1":12,"vl_cartao_credito_1":1999.00,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"2600.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":4499.00,"dt_sellin":"2024-06-19T00:00:00","dt_sellout":"2024-08-07T11:00:36","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"42240808640305001494650010000417211011429380","num_dsf":"55021","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015666","dt_operacao":"2024-08-07T11:01:13.147","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"205170","custcode_nivel_75":"TS40_TSPLUI_TS0046_A009","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","database_name":"DTS39_TIM_IANKCELL_SC","tipo":"Venda","idpedido_origem":205170,"retorno_json":"[{\"cod_importacao\":72215490,\"imei\":\"359351340154867\",\"num_telefone\":996072012,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 476) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:96b6cdb6-3665-45e7-84c3-f763ab8a1fb4 Error Number:1205,State:52,Class:13 [11:01:22.5687206] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642476 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:02:31.7912314] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_IMAGEM_SP - Pedido: $354525 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:02:48.4942534] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_IMAGEM_SP - Pedido: $354521 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:02:57.2598882] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642477 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:02:58.9317514] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $718816 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:03:02.2442681] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $718814 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:03:11.4600800] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642474 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:05:46.4218476] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $718819 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:05:54.9710725] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642482 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:05:55.0781089] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $718821 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:06:03.4218521] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642478 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:06:13.8926141] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642481 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:06:38.3601305] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642483 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:07:06.8620868] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FACELL_RN - Pedido: $621591 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:07:31.7058371] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FACELL_RN - Pedido: $621593 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:08:26.2512816] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72216388,"dt_importado":"2024-08-07T10:19:01.437","nom_cliente":"LUZIA FAGUNDES DE SOUZA","ddd":19,"num_telefone":982244726,"num_documento":"30043108806","dt_servico":"2024-08-07T10:19:01.437","nom_plano":"TIM BLACK MULTI C 6.0","SerialId":280245,"imei":null,"valor_aparelho":10.00,"val_entrada_dinh":10.00,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":null,"qtde_parc_1":null,"vl_cartao_credito_1":null,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"0.00","nom_tipo_negociacao":"","vl_pre_tabela":0.00,"dt_sellin":"2024-07-23T00:00:00","dt_sellout":"2024-08-07T11:07:45","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"35240811378319001305550010000331231013218770","num_dsf":"66968","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T11:08:22.5","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"293205","custcode_nivel_75":"SP10_MGBAUI_PT2833_A011","Serial_Acessorio":"","ICCID":"89550327001053600328","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_ROCHATELECOM_SP","tipo":"Venda","idpedido_origem":293205,"retorno_json":"[{\"cod_importacao\":72216388,\"imei\":null,\"num_telefone\":982244726,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 479) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:a8fce2ea-9a3b-4c31-b83c-d322e99e5ad4 Error Number:1205,State:52,Class:13 [11:08:52.6031703] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_IMAGEM_SP - Pedido: $354524 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:09:00.9787085] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72216458,"dt_importado":"2024-08-07T11:02:45.773","nom_cliente":"TATIANA APARECIDA DA CUNHA FERREIRA IOTTE","ddd":24,"num_telefone":988670835,"num_documento":"08438661793","dt_servico":"2024-08-07T11:02:45.773","nom_plano":"","SerialId":50126,"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-06-18T00:00:00","dt_sellout":"2024-08-07T11:08:16","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"33240841910977001103550010000035471011326099","num_dsf":"90181","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"04010927 EX-OI","dt_operacao":"2024-08-07T11:08:53.31","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"120252","custcode_nivel_75":"RN20_MGINTI_PT0479_A002","Serial_Acessorio":"","ICCID":"89550227001022115516","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_DATAFOR_MG","tipo":"Venda","idpedido_origem":120252,"retorno_json":"[{\"cod_importacao\":72216458,\"imei\":null,\"num_telefone\":988670835,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 1953) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:ce85ac71-bb77-4ae8-8fdd-f418a49c9d60 Error Number:1205,State:52,Class:13 [11:09:31.7208919] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FACELL_RN - Pedido: $621597 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:09:57.6110590] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642485 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:10:48.4166437] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_SETELAN - Pedido: $1382892 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:10:50.9634938] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FACELL_RN - Pedido: $621592 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:10:51.9018892] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_SETELAN - Pedido: $1382894 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:11:21.6722393] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_IMAGEM_SP - Pedido: $354529 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:11:42.4081639] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_SETELAN - Pedido: $1382891 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:11:56.0294196] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $718831 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:12:10.0375440] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72216745,"dt_importado":"2024-08-07T10:27:45.973","nom_cliente":"renata clemente lima","ddd":16,"num_telefone":982065756,"num_documento":"14657802704","dt_servico":"2024-08-07T10:27:45.973","nom_plano":"TIM PRÉ TOP","SerialId":451201,"imei":null,"valor_aparelho":10.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":10.00,"cod_aut_1":199519,"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-07-31T00:00:00","dt_sellout":null,"vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"","num_dsf":"85190","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T11:12:08.54","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"642452","custcode_nivel_75":"SP10_MGRIBI_PT0298_A006","Serial_Acessorio":"","ICCID":"89550320000491061520","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_JUFAP_PR","tipo":"Venda","idpedido_origem":642452,"retorno_json":"[{\"cod_importacao\":72216745,\"imei\":null,\"num_telefone\":982065756,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 1090) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:a91ec094-e673-4847-807b-9689a3920139 Error Number:1205,State:52,Class:13 [11:12:21.9828531] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JUFAP_PR - Pedido: $642484 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:12:25.3932141] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $718827 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:12:28.3539727] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $718811 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [11:12:41.0137358] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72216790,"dt_importado":"2024-08-07T10:41:40.98","nom_cliente":"ELISANGELA SILVA DOS SANTOS","ddd":0,"num_telefone":0,"num_documento":"30852839863","dt_servico":"2024-08-07T10:41:40.98","nom_plano":"","SerialId":141681,"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":null,"qtde_parc_1":null,"vl_cartao_credito_1":null,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"0.00","nom_tipo_negociacao":"","vl_pre_tabela":0.00,"dt_sellin":"2024-06-11T00:00:00","dt_sellout":"2024-08-07T11:11:59","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"41240820654202000830550010000154131012265363","num_dsf":"85019","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-07T11:12:35.83","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"277134","custcode_nivel_75":"TS40_TSAGCI_RV0328_A004","Serial_Acessorio":"","ICCID":"89550448000008977678","Fidelizacao":"NÃO","item_juros":"NÃO","database_name":"DTS39_TIM_LEMAR_PR","tipo":"Venda","idpedido_origem":277134,"retorno_json":"[{\"cod_importacao\":72216790,\"imei\":null,\"num_telefone\":0,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): A transação (ID do processo 2362) 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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:84cdae3f-41fd-4cb4-8a8e-d043966e2a18 Error Number:1205,State:52,Class:13 [11:13:07.6167955] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FACELL_RN - Pedido: $621598 - 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 F:\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 F:\Jenkins\workspace\DATASYS - WSCAIXA - PROD\Banco\Integracoes.cs:line 193