Local: PDVServico Mensagem: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. The statement has been terminated. Instrucao SQL Truncate Table tbTabelaPrecoProdutoItemPDV ; Insert Into tbTabelaPrecoProdutoItemPDV (tpv_CodigoEmpresa, tpv_CodigoTabelaPrecoProduto, tpv_CodigoProduto, tpv_Preco, tpv_PrecoPromocao) Select tpi_CodigoEmpresa, tpi_CodigoTabelaPrecoProduto, tpi_CodigoProduto, Case When isnull(prl_PrecoLoja, 0) = 0 Or isnull(tpi_TipoAlteracaoPreco, 'M') <> 'L' Then tpi_Preco When isnull(tpi_TipoAlteracaoPreco, 'M') = 'L' And isnull(prl_PrecoLoja, 0) > isnull(tpi_Preco, 0) And isnull(tpi_PctMaximaPermitidoLojaAlteraPreco, 0) = 0 Then prl_PrecoLoja When isnull(tpi_TipoAlteracaoPreco, 'M') = 'L' And isnull(prl_PrecoLoja, 0) > isnull(tpi_Preco, 0) And isnull(tpi_PctMaximaPermitidoLojaAlteraPreco, 0) > 0 And Convert(decimal(10,2),(tpi_Preco + ((tpi_Preco * isnull(tpi_PctMaximaPermitidoLojaAlteraPreco, 0)) /100))) <= isnull(prl_PrecoLoja, 0) Then prl_PrecoLoja When isnull(tpi_TipoAlteracaoPreco, 'M') = 'L' And isnull(tpi_PctMinimoPermitidoLojaAlteraPreco, 0) = 100 Then prl_PrecoLoja When isnull(tpi_TipoAlteracaoPreco, 'M') = 'L' And isnull(tpi_PctMinimoPermitidoLojaAlteraPreco , 0) = 0 And isnull(prl_PrecoLoja, 0) < isnull(tpi_Preco, 0) Then tpi_Preco When isnull(tpi_TipoAlteracaoPreco, 'M') = 'L' And isnull(tpi_Preco, 0) = 0 Then isnull(prl_PrecoLoja, 0) When isnull(tpi_TipoAlteracaoPreco, 'M') = 'L' And isnull(prl_PrecoLoja, 0) < isnull(tpi_Preco, 0) And isnull(tpi_PctMinimoPermitidoLojaAlteraPreco, 0) > 0 And isnull(tpi_PctMinimoPermitidoLojaAlteraPreco, 0) < 100 And Convert(decimal(10,2),(tpi_Preco - ((tpi_Preco * isnull(tpi_PctMinimoPermitidoLojaAlteraPreco, 0)) /100))) <= isnull(prl_PrecoLoja, 0) Then prl_PrecoLoja Else tpi_Preco End as tpi_Preco, tpi_PrecoPromocao From tbTabelaPrecoProdutoItem (NOLOCK) Inner Join tbTabelaPrecoProduto (NOLOCK) On tpp_CodigoEmpresa = tpi_CodigoEmpresa And tpp_Codigo = tpi_CodigoTabelaPrecoProduto And tpp_Ativo = '1' Inner Join tbTabelaPrecoProdutoLoja (NOLOCK) on ppl_CodigoEmpresa = tpi_CodigoEmpresa And ppl_CodigoTabelaPrecoProduto = tpi_CodigoTabelaPrecoProduto And ppl_Principal = '1' Inner Join tbProduto (NOLOCK) ON pro_CodigoEmpresa = tpi_CodigoEmpresa And pro_Codigo = tpi_CodigoProduto And pro_Ativo = 1 And isnull(pro_DataProdutoDescontinuacao, getdate()) >= getdate() Left Join tbProdutoLoja (NOLOCK) on prl_CodigoEmpresa = tpi_CodigoEmpresa And prl_CodigoProduto = tpi_CodigoProduto And prl_CodigoLoja = 438 Where tpp_CodigoEmpresa = 6 And ppl_CodigoLoja = 438 And Convert(DATE, tpp_InicioVigencia, 23) <= Convert(DATE, getdate(), 23) And Convert(DATE, isnull(tpp_TerminoVigencia, '2200-01-01'), 23) >= Convert(DATE, getdate(), 23) ; Stack Trace: at ideologica.IdeoFramework.BancoDadosSQL.GerarExcecaoComando(SqlCommand comando, Exception innerException) at ideologica.IdeoFramework.BancoDadosSQL.Executar(SqlCommand comando) at ideologica.clsBD_TabelaPrecoProduto.MontaTabelaPDVLoja() at ideologica.basPDVServicoEProduto.SetaTabelaPrecoProdutoPrincipal() at ideologica.frmAbertura.frmAbertura_Load(Object sender, EventArgs e) at System.Windows.Forms.Form.OnLoad(EventArgs e) at System.Windows.Forms.Form.OnCreateControl() at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl() at System.Windows.Forms.Control.WmShowWindow(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ScrollableControl.WndProc(Message& m) at System.Windows.Forms.Form.WmShowWindow(Message& m) at System.Windows.Forms.Form.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. Operation cancelled by user. The statement has been terminated. 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) 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 ideologica.IdeoFramework.BancoDadosSQL.Executar(SqlCommand comando) 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: SFFUTURO Memória: 7,69 GB Sistema Operacional: Microsoft Windows 11 Pro Processador: Intel(R) Core(TM) i5-14500T (1690Mhz) Usuário: SFFUTURO\bruno 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 26200: ) (Hypervisor) Versão exe: 7.0.0, Computador: SFFUTURO