Local: PDVServico Mensagem: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Instrucao SQL Select tis_NomeServicoGrupo, Max(Data) Data, sum(Valor) Valor From( Select tis_NomeServicoGrupo, MAX(tck_DataEmissao) Data, SUM(isnull(tis_ValorUnitarioComAcrescimoDescontoTicket, 0) * tis_Quantidade) Valor From tbTicketPecaIndividualServico (NOLOCK) Inner Join tbTicket (NOLOCK) On tis_CodigoEmpresa = tck_CodigoEmpresa And tis_CodigoTicket = tck_Codigo And tis_CodigoLoja = tck_CodigoLoja Where tck_CodigoEmpresa = 2 And tck_CodigoLoja = 416 And tck_CodigoCliente = 5512 And tck_DataEmissao >= '2025-11-08' And tck_Ativo = 1 And tck_DataAnulacao Is null Group By tis_NomeServicoGrupo Union all Select sgr_Nome As tis_NomeServicoGrupo, MAX(tck_DataEmissao) Data, SUM(isnull(tql_ValorUnitarioComAcrescimoDescontoTicket,0)) Valor From tbTicketQuilo (NOLOCK) Inner Join tbTicket (NOLOCK) On tql_CodigoEmpresa = tck_CodigoEmpresa And tql_CodigoTicket = tck_Codigo And tql_CodigoLoja = tck_Codigoloja Inner Join tbQuilo (NOLOCK) On qlo_CodigoEmpresa = tql_CodigoEmpresa And qlo_Codigo = tql_CodigoQuilo Inner Join tbServico (NOLOCK) On tql_CodigoEmpresa = svr_CodigoEmpresa And tql_CodigoServico = svr_Codigo Inner Join tbServicoGrupo (NOLOCK) On sgr_CodigoEmpresa = svr_CodigoEmpresa And sgr_Codigo = svr_CodigoServicoGrupo Where tck_CodigoEmpresa = 2 And tck_CodigoLoja = 416 And tck_CodigoCliente = 5512 And tck_DataEmissao >= '2025-11-08' And tck_Ativo = 1 And tck_DataAnulacao Is null Group By sgr_Nome Union all Select 'PACOTE' As tis_NomeServicoGrupo, MAX(tck_DataEmissao) Data, SUM(tss_valor) Valor From tbTicketAssinatura Inner Join tbTicket (NOLOCK) On tss_CodigoEmpresa = tck_CodigoEmpresa And tss_CodigoLoja = tck_CodigoLoja And tss_CodigoTicket = tck_Codigo Where tck_CodigoEmpresa = 2 And tck_CodigoLoja = 416 And tck_CodigoCliente = 5512 And tck_DataEmissao >= '2025-11-08' And tck_Ativo = 1 And tck_DataAnulacao Is null ) TabelaUnion Group by tis_NomeServicoGrupo Stack Trace: at ideologica.IdeoFramework.BancoDadosSQL.GerarExcecaoComando(SqlCommand comando, Exception innerException) at ideologica.IdeoFramework.BancoDadosSQL.ExecutarParaDataTable(SqlCommand comando, String nomeTabela) at ideologica.clsBD_Cliente.CarregarHistoricoConsumoGrupoServico(String CodigoCliente, Int32 TempoParaConsiderarHistoricoConsumo) at ideologica.frmPDVServico.CarregaHistoricoConsumoCliente(String CodigoCliente, UltraGrid obj_grd) at ideologica.frmPDVServico.grdCliente_AfterRowActivate(Object sender, EventArgs e) at Infragistics.Win.UltraWinGrid.UltraGrid.OnAfterRowActivate() at Infragistics.Win.UltraWinGrid.UltraGrid.FireEvent(GridEventIds id, EventArgs e) at Infragistics.Win.UltraWinGrid.UltraGrid.OnActiveRowChange(UltraGridRow newActiveRow, Boolean scrollIntoView) at Infragistics.Win.UltraWinGrid.UltraGridBase.SetActiveRow(UltraGridRow row, Boolean scrollIntoView) at Infragistics.Win.UltraWinGrid.UltraGrid.EnsureTempActiveRowAssigned() at Infragistics.Win.UltraWinGrid.UltraGridBase.PaintTimer_Tick(Object source, EventArgs e) at Infragistics.Win.UltraWinGrid.RowScrollRegion.set_FirstRow(UltraGridRow value) at Infragistics.Win.UltraWinGrid.UltraGridLayout.ClearMainUIElement() at Infragistics.Win.UltraWinGrid.UltraGridBase.Set_ListManager(Object newDataSource, String newDataMember) at Infragistics.Win.UltraWinGrid.UltraGridBase.DataBind() at ideologica.frmPDVServico.Pesquisar(Boolean CargaDeTitulos, String CodigoClienteEspecifico) at ideologica.frmPDVServico.cmdPesquisar_Click(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at Infragistics.Win.Misc.UltraButtonBase.OnClick(EventArgs e) at Infragistics.Win.Misc.UltraButton.OnMouseUp(MouseEventArgs e) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) Local: .Net SqlClient Data Provider Mensagem: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at ideologica.IdeoFramework.BancoDadosSQL.ExecutarParaDataTable(SqlCommand comando, String nomeTabela) Mensagem: O tempo limite de espera foi atingido ========================= Informações do Aplicativo ========================= Arquivo: PDVServico.exe Caminho: C:\Allegro.IoT\PDVServico.exe Versão: 7.0.0.1238 ====================== Informações da Máquina ====================== Nome da Máquina: DESKTOP-P37F4QS Memória: 7,70 GB Sistema Operacional: Microsoft Windows 10 Pro Processador: 12th Gen Intel(R) Core(TM) i3-12100 (3302Mhz) Usuário: DESKTOP-P37F4QS\omoar Resolução do Vídeo: 1024x768 Versão SQL Server: Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.5026.0 (X64) Mar 18 2018 09:11:49 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 19045: ) Versão exe: 7.0.0, Computador: DESKTOP-P37F4QS