[15:49:27.7310738] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_MASTERCELLCOMERCIO_SC - Pedido: $403740 - 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 [15:49:56.0428625] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_MASTERCELLCOMERCIO_SC - Pedido: $404291 - 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 [16:50:59.5453227] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $880544 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 448 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [16:51:02.9639140] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $880543 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 448 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [16:51:33.7617101] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $880545 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 448 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [16:53:46.5050569] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $880291 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 448 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [16:53:49.0167056] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FACELL_RN - Pedido: $717969 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 448 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [16:57:08.6690970] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_FACELL_RN - Pedido: $717710 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 448 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [16:57:58.1238025] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $880532 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 448 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [17:15:33.4953318] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $880348 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 448 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [17:21:31.6770472] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_ALEGRIATELECOM_SP - Pedido: $0 - Cancelamento: $True - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 448 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [17:23:29.5309117] [TFP] [SalvarDadosTimCentralizado/Cliente] - [{"item":1,"cod_importacao":73700035,"dt_importado":"2025-01-02T10:03:18.69","nom_cliente":"ROSANGELA JUSTINO MENEZES","ddd":13,"num_telefone":997668656,"num_documento":"41281951897","dt_servico":"2025-01-02T10:03:18.69","nom_plano":"TIM BLACK PREMIUM","SerialId":593991,"imei":355367860706955,"valor_aparelho":4749.05,"val_entrada_dinh":null,"val_entrada_bol":null,"val_entrada_vouc":null,"val_entrada_pix":null,"val_entrada_deb":null,"cod_aut_1":0,"qtde_parc_1":12,"vl_cartao_credito_1":4749.05,"cod_aut_2":null,"qtde_parc_2":null,"vl_cartao_credito_2":null,"sit_fidelizacao":false,"vl_desconto":"3249.95","nom_tipo_negociacao":"rebate","vl_pre_tabela":7999.00,"dt_sellin":"2024-07-18T00:00:00","dt_sellout":"2025-01-02T18:57:49","vl_desconto_promo":0.00,"num_nf":0,"lk_nf":"35250121683365002777550010000132581017336668","num_dsf":"84053","sit_cliente_novo":true,"sit_aparelho_tim":true,"cod_tm":"04016294","dt_operacao":"2025-01-13T17:14:26.993","nom_operacao":"cancelamento","imei_novo":null,"desc_motivo":"","erro":"","vl_venda_acessorios":0.00,"nom_fornecedor":"CSJ SISTEMAS / DATASYS","cod_Protocolo_Venda":"870711","custcode_nivel_75":"SP10_MGCAMI_PT2899_A014","Serial_Acessorio":"","ICCID":"","Fidelizacao":"SIM","item_juros":"NÃO","database_name":"DTS39_TIM_ALEGRIATELECOM_SP","tipo":"Cancelamento","idpedido_origem":0,"retorno_json":"[{\"cod_importacao\":73700035,\"imei\":\"355367860706955\",\"num_telefone\":997668656,\"erro\":\"sem erro, importado com sucesso.\"}]"}]: System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. A instrução foi finalizada. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out 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 293 ClientConnectionId:b53fe332-8af8-426b-b265-595518928666 Error Number:-2,State:0,Class:11 [17:26:27.3764560] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_MASTERCELLCOMERCIO_SC - Pedido: $407219 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 448 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [17:27:56.4582725] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_MASTERCELLCOMERCIO_SC - Pedido: $407244 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 448 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193 [17:38:20.6827811] [TFP] [EnviaDadosTimCentralizado] Base: $DTS39_TIM_MASTERCELLCOMERCIO_SC - Pedido: $407226 - Cancelamento: $False - Devolucao: $False - Sem TFP: $False: System.Exception: Generic Exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. at wsCaixa.Banco.IntegracaoCaixaTim.ReprocessaPendenciaDocCenter(SqlConnection Conn, SqlTransaction Tran, Int64 idPedido) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 448 at wsCaixa.Banco.IntegracaoCaixaTim.EnviaDadosTimCentralizado(SqlConnection Conn, SqlTransaction Tran, String stNomeBase, Int64 idPedido, Boolean blCancelamento, Boolean blDevolucao, Boolean blSomenteItensSemTFP) in E:\jenkins\workspace\DATASYS WSCAIXA - PROD\Banco\Integracoes.cs:line 193