[10:19:23.0673022] [TFP] [EnviaDadosTimCentralizado] Base: $COMERCIAL_TIM - Pedido: $175571 - Cancelamento: $False - Devolucao: $False - Sem TFP: $True: System.InvalidOperationException: The source contains no DataRows. at System.Data.DataTableExtensions.LoadTableFromEnumerable[T](IEnumerable`1 source, DataTable table, Nullable`1 options, FillErrorEventHandler errorHandler) at System.Data.DataTableExtensions.CopyToDataTable[T](IEnumerable`1 source) at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 145 [10:22:46.1373045] [TFP] [EnviaDadosTimCentralizado] Base: $COMERCIAL_TIM - Pedido: $175571 - Cancelamento: $False - Devolucao: $False - Sem TFP: $True: System.InvalidOperationException: The source contains no DataRows. at System.Data.DataTableExtensions.LoadTableFromEnumerable[T](IEnumerable`1 source, DataTable table, Nullable`1 options, FillErrorEventHandler errorHandler) at System.Data.DataTableExtensions.CopyToDataTable[T](IEnumerable`1 source) at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 145 [10:54:12.3733781] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JMXTELECOM_MG - Pedido: $178478 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Data.SqlClient.SqlException (0x80131904): Cannot continue the execution because the session is in the kill state. A severe error occurred on the current command. The results, if any, should be discarded. at wsCaixa.Banco.fnBanco.executeComTransacao(String stQuery, SqlConnection Conn, SqlTransaction Tran, Boolean throws) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Data.cs:line 113 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 140 ClientConnectionId:8e2366ad-9ab2-4a38-ac20-efc61f85a225 Error Number:596,State:1,Class:21 [10:54:13.8769934] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_JMXTELECOM_MG - Pedido: $178479 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Data.SqlClient.SqlException (0x80131904): Cannot continue the execution because the session is in the kill state. A severe error occurred on the current command. The results, if any, should be discarded. at wsCaixa.Banco.fnBanco.executeComTransacao(String stQuery, SqlConnection Conn, SqlTransaction Tran, Boolean throws) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Data.cs:line 113 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 140 ClientConnectionId:32f60413-100c-4ada-903a-452d124a4ee6 Error Number:596,State:1,Class:21 [10:59:39.3282685] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FORTTELECOM_CE - Pedido: $282595 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Data.SqlClient.SqlException (0x80131904): Cannot continue the execution because the session is in the kill state. A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) at wsCaixa.Banco.fnBanco.executeComTransacao(String stQuery, SqlConnection Conn, SqlTransaction Tran, Boolean throws) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Data.cs:line 113 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 140 ClientConnectionId:b42ed04a-fc52-43d8-90ab-5bc372ee9664 Error Number:596,State:1,Class:21 [11:11:54.9251373] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FORTTELECOM_CE - Pedido: $282598 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Data.SqlClient.SqlException (0x80131904): Cannot continue the execution because the session is in the kill state. A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) at wsCaixa.Banco.fnBanco.executeComTransacao(String stQuery, SqlConnection Conn, SqlTransaction Tran, Boolean throws) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Data.cs:line 113 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 140 ClientConnectionId:4bde860a-5c4c-4cbf-8d14-f57cca07711c Error Number:596,State:1,Class:21 [11:12:29.3978849] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FORTTELECOM_CE - Pedido: $282596 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Data.SqlClient.SqlException (0x80131904): Cannot continue the execution because the session is in the kill state. A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) at wsCaixa.Banco.fnBanco.executeComTransacao(String stQuery, SqlConnection Conn, SqlTransaction Tran, Boolean throws) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Data.cs:line 113 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 140 ClientConnectionId:f62e5b37-d4e1-46f4-b807-c45b94593d28 Error Number:596,State:1,Class:21 [11:12:35.6518902] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FORTTELECOM_CE - Pedido: $282599 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Data.SqlClient.SqlException (0x80131904): Cannot continue the execution because the session is in the kill state. A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) at wsCaixa.Banco.fnBanco.executeComTransacao(String stQuery, SqlConnection Conn, SqlTransaction Tran, Boolean throws) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Data.cs:line 113 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 140 ClientConnectionId:4705d8bd-db13-4c7a-8e51-1fd969d064c5 Error Number:596,State:1,Class:21 [11:53:05.5331375] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FORTTELECOM_CE - Pedido: $282612 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Data.SqlClient.SqlException (0x80131904): Cannot continue the execution because the session is in the kill state. A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) at wsCaixa.Banco.fnBanco.executeComTransacao(String stQuery, SqlConnection Conn, SqlTransaction Tran, Boolean throws) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Data.cs:line 113 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 140 ClientConnectionId:0ffaa1f0-d302-4552-b562-a6b37167ef59 Error Number:596,State:1,Class:21 [11:53:07.8981049] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FORTTELECOM_CE - Pedido: $282611 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Data.SqlClient.SqlException (0x80131904): Cannot continue the execution because the session is in the kill state. A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) at wsCaixa.Banco.fnBanco.executeComTransacao(String stQuery, SqlConnection Conn, SqlTransaction Tran, Boolean throws) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Data.cs:line 113 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 140 ClientConnectionId:74f4129d-65ce-4a0c-877f-8c95250c6c5f Error Number:596,State:1,Class:21 [11:53:08.3025055] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FORTTELECOM_CE - Pedido: $282607 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Data.SqlClient.SqlException (0x80131904): Cannot continue the execution because the session is in the kill state. A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) at wsCaixa.Banco.fnBanco.executeComTransacao(String stQuery, SqlConnection Conn, SqlTransaction Tran, Boolean throws) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Data.cs:line 113 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 140 ClientConnectionId:714cc8bb-42b6-4aad-99fe-2002f118a0d1 Error Number:596,State:1,Class:21 [11:56:40.3189146] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FORTTELECOM_CE - Pedido: $282613 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Data.SqlClient.SqlException (0x80131904): Cannot continue the execution because the session is in the kill state. A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) at wsCaixa.Banco.fnBanco.executeComTransacao(String stQuery, SqlConnection Conn, SqlTransaction Tran, Boolean throws) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Data.cs:line 113 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 140 ClientConnectionId:d205d15a-28fc-4c72-b533-51a3c19719c1 Error Number:596,State:1,Class:21 [18:22:07.8466371] [TFP] [SalvarDadosTimCentralizado/DTS_WSTIM] - [{"item":1,"cod_importacao":72497001,"dt_importado":"2024-08-28T18:06:09.593","nom_cliente":"Estefhane vitória Araújo borges","ddd":96,"num_telefone":981026561,"num_documento":"05025140277","dt_servico":"2024-08-28T18:06:09.593","nom_plano":"TIM CONTROLE SMART 6.0","SerialId":96646,"imei":353037555624654,"valor_aparelho":1099.00,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":164.85,"cod_aut_1":148330,"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":"600.00","nom_tipo_negociacao":"rebate","vl_pre_tabela":1699.00,"dt_sellin":"2024-08-07T00:00:00","dt_sellout":"2024-08-28T18:22:00","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"16240802254271000280550010000179911012244110","num_dsf":"71508","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04015989","dt_operacao":"2024-08-28T18:21:58.133","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"212549","custcode_nivel_75":"RN90_MGPMPI_PT0087_A006","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","database_name":"DTS39_TIM_SALINASSAR_AP","tipo":"Venda","idpedido_origem":212549,"retorno_json":"[{\"cod_importacao\":72497001,\"imei\":\"353037555624654\",\"num_telefone\":981026561,\"erro\":\"sem erro, importado com sucesso.\"}]"},{"item":2,"cod_importacao":null,"dt_importado":"2024-08-28T18:06:09.593","nom_cliente":"Estefhane vitória Araújo borges","ddd":96,"num_telefone":981026561,"num_documento":"05025140277","dt_servico":"2024-08-28T18:06:09.593","nom_plano":"TIM CONTROLE SMART 6.0","SerialId":88206,"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":164.85,"cod_aut_1":148330,"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-17T00:00:00","dt_sellout":"2024-08-28T18:22:00","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"16240802254271000280550010000179911012244110","num_dsf":"71508","sit_cliente_novo":true,"sit_aparelho_tim":false,"cod_tm":"","dt_operacao":"2024-08-28T18:21:58.133","nom_operacao":"venda","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"212549","custcode_nivel_75":"RN90_MGPMPI_PT0087_A006","Serial_Acessorio":"","ICCID":"89550297000006993604","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 108) entrou em deadlock em bloquear | buffer de comunicação recursos com outro processo e foi escolhida como a vítima do deadlock. Execute a transação novamente. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at wsCaixa.Banco.IntegracaoCaixaTim.SalvarDadosTimCentralizado(SqlConnection conn, SqlTransaction tran, DataRow dados, String stJsonEnvio, RetornoIntegracaoTim retorno) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 247 ClientConnectionId:a55aa454-20c9-4970-a897-c4535dfd8b0b Error Number:1205,State:52,Class:13