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 pea_CodigoPecaFamilia,pea_Codigo,pea_Nome,pea_QuantidadeImpressos,svr_Codigo,svr_Nome,svr_PossuiSubItem,sgr_Cor,sgr_Nome,sgr_CodigoImagem,sgr_ExigeLacre, sgr_PermiteDiversos, sgr_SequenciaExecucao,svr_CodigoServicoGrupo,Case When isnull(evl_PrecoLoja, 0) = 0 Or isnull(tsi_TipoAlteracaoPreco, 'M') <> 'L' Then tsi_Preco When isnull(tsi_TipoAlteracaoPreco, 'M') = 'L' And isnull(evl_PrecoLoja, 0) > isnull(tsi_Preco, 0) And isnull(tsi_PctMaximaPermitidoLojaAlteraPreco, 0) = 0 Then evl_PrecoLoja When isnull(tsi_TipoAlteracaoPreco, 'M') = 'L' And isnull(evl_PrecoLoja, 0) > isnull(tsi_Preco, 0) And isnull(tsi_PctMaximaPermitidoLojaAlteraPreco, 0) > 0 And Convert(decimal(10,2),(tsi_Preco + ((tsi_Preco * isnull(tsi_PctMaximaPermitidoLojaAlteraPreco, 0)) /100))) <= isnull(evl_PrecoLoja, 0) Then evl_PrecoLoja When isnull(tsi_TipoAlteracaoPreco, 'M') = 'L' And isnull(tsi_PctMinimoPermitidoLojaAlteraPreco, 0) = 100 Then evl_PrecoLoja When isnull(tsi_TipoAlteracaoPreco, 'M') = 'L' And isnull(tsi_PctMinimoPermitidoLojaAlteraPreco , 0) = 0 And isnull(evl_PrecoLoja, 0) < isnull(tsi_Preco, 0) Then tsi_Preco When isnull(tsi_TipoAlteracaoPreco, 'M') = 'L' And isnull(tsi_Preco, 0) = 0 Then isnull(evl_PrecoLoja, 0) When isnull(tsi_TipoAlteracaoPreco, 'M') = 'L' And isnull(evl_PrecoLoja, 0) < isnull(tsi_Preco, 0) And isnull(tsi_PctMinimoPermitidoLojaAlteraPreco, 0) > 0 And isnull(tsi_PctMinimoPermitidoLojaAlteraPreco, 0) < 100 And Convert(decimal(10,2),(tsi_Preco - ((tsi_Preco * isnull(tsi_PctMinimoPermitidoLojaAlteraPreco, 0)) /100))) <= isnull(evl_PrecoLoja, 0) Then evl_PrecoLoja Else tsi_Preco End as tsi_Preco, tsi_PrecoPromocao,tsi_TipoAlteracaoPreco,tsi_TipoMedida,tsi_AreaMinima,tsi_CodigoTabelaPrecoServico,pea_CodigoImagem,svr_CodigoImagem,pfa_CodigoImagem,evl_TempoPrazoExecucao,evl_PrazoExecucao,evl_TempoPrazoCliente,evl_PrazoCliente,evl_Terceirizado,evl_Dificuldade,evl_VisitaTerceiro1,evl_VisitaTerceiro2,evl_TempoEntregaTerceiro,pgu_Nome,pfa_Nome,pfa_Cor,tsi_Padrao, isnull(for_PermiteDuplicarLacre,0) As for_PermiteDuplicarLacre, Peca.ict_Codigo As CodigoInformacaoCondicionalPeca, Peca.ict_Nome As NomeInformacaoCondicionalPeca, Servico.ict_Codigo As CodigoInformacaoCondicionalServico, Servico.ict_Nome As NomeInformacaoCondicionalServico, Familia.ict_Codigo As CodigoInformacaoCondicionalPecaFamilia, Familia.ict_Nome As NomeInformacaoCondicionalPecaFamilia, Grupo.ict_Codigo As CodigoInformacaoCondicionalServicoGrupo, Grupo.ict_Nome As NomeInformacaoCondicionalServicoGrupo, sgr_Codigo, svr_CodigoServicoSubgrupo, tsi_CodigoFatorDificuldade , isnull(pcj_PercentualOcupacao,0) As PercentualOcupacao,pcj_CodigoEstoquePecaLoja As CodigoEstoquePecaLoja, ssg_Nome, pea_CodigoPecaGrupo From tbTabelaPrecoServicoPeca (NOLOCK) Inner Join tbTabelaPrecoServico (NOLOCK) On tsi_CodigoEmpresa = tps_CodigoEmpresa And tsi_CodigoTabelaPrecoServico = tps_Codigo Inner Join tbPeca (NOLOCK) On tsi_CodigoEmpresa = pea_CodigoEmpresa And tsi_CodigoPeca = pea_Codigo Left Join tbTabelaPrecoServicoPecaOrdenacao (NOLOCK) On tsi_CodigoEmpresa = otp_CodigoEmpresa And tsi_CodigoTabelaPrecoServico = otp_CodigoTabelaPrecoServico And tsi_CodigoPeca = otp_CodigoPeca Left Join tbTabelaPrecoServicoServicoOrdenacao (NOLOCK) On tsi_CodigoEmpresa = ots_CodigoEmpresa And tsi_CodigoTabelaPrecoServico = ots_CodigoTabelaPrecoServico And tsi_CodigoServico = ots_CodigoServico Left Join tbPecaFamilia (NOLOCK) On pea_CodigoEmpresa = pfa_CodigoEmpresa And pea_CodigoPecaFamilia = pfa_Codigo Left Join tbTabelaPrecoServicoPecaFamiliaOrdenacao (NOLOCK) On tsi_CodigoEmpresa = ofp_CodigoEmpresa And tsi_CodigoTabelaPrecoServico = ofp_CodigoTabelaPrecoServico And pfa_Codigo = ofp_CodigoPecaFamilia Left Join tbPecaGrupo (NOLOCK) On pea_CodigoEmpresa = pgu_CodigoEmpresa And pea_CodigoPecaGrupo = pgu_Codigo Inner Join tbServico (NOLOCK) On tsi_CodigoEmpresa = svr_CodigoEmpresa And tsi_CodigoServico = svr_Codigo Inner Join tbServicoGrupo (NOLOCK) On svr_CodigoEmpresa = sgr_CodigoEmpresa And svr_CodigoServicoGrupo = sgr_Codigo Left Join tbServicoSubgrupo (NOLOCK) On svr_CodigoEmpresa = ssg_CodigoEmpresa And svr_CodigoServicoSubgrupo = ssg_Codigo Inner Join tbTabelaPrecoServicoLoja (NOLOCK) On pvl_CodigoEmpresa = tsi_CodigoEmpresa And pvl_CodigoTabelaPrecoServico = tsi_CodigoTabelaPrecoServico And pvl_CodigoLoja = 248 Left Join tbPecaLoja (NOLOCK) On pea_CodigoEmpresa = pcj_CodigoEmpresa And pea_Codigo = pcj_CodigoPeca And pcj_CodigoLoja = 248 Left Join tbPecaServicoLoja (NOLOCK) On tsi_CodigoEmpresa = evl_CodigoEmpresa And pcj_CodigoLoja = evl_CodigoLoja And tsi_CodigoPeca = evl_CodigoPeca And pcj_CodigoPeca = evl_CodigoPeca And tsi_CodigoServico = evl_CodigoServico And evl_CodigoLoja = 248 Left Join tbTabelaPrecoTerceiro (NOLOCK) on tat_CodigoEmpresa = pea_CodigoEmpresa And tat_CodigoPeca = pea_Codigo And tat_CodigoServico = svr_Codigo Left Join tbFornecedor (NOLOCK) on tat_CodigoEmpresa = for_CodigoEmpresa And tat_CodigoFornecedor = for_Codigo And for_ForneceServicos = 1 Left Join tbInformacaoCondicionalTicket Peca (NOLOCK) on pea_CodigoEmpresa = Peca.ict_CodigoEmpresa And pea_CodigoInformacaoCondicionalTicket = Peca.ict_Codigo And Peca.ict_Ativo = 1 Left Join tbInformacaoCondicionalTicket Servico (NOLOCK) on svr_CodigoEmpresa = Servico.ict_CodigoEmpresa And svr_CodigoInformacaoCondicionalTicket = Servico.ict_Codigo And Servico.ict_Ativo = 1 Left Join tbInformacaoCondicionalTicket Familia (NOLOCK) on pfa_CodigoEmpresa = Familia.ict_CodigoEmpresa And pfa_CodigoInformacaoCondicionalTicket = Familia.ict_Codigo And Familia.ict_Ativo = 1 Left Join tbInformacaoCondicionalTicket Grupo (NOLOCK) on sgr_CodigoEmpresa = Grupo.ict_CodigoEmpresa And sgr_CodigoInformacaoCondicionalTicket = Grupo.ict_Codigo And Grupo.ict_Ativo = 1 Left Join ( Select tsi_CodigoPeca As CodigoPeca ,tsi_CodigoServico CodigoServico, tsi_CodigoEmpresa CodigoEmpresa From tbTabelaPrecoServicoPeca (NOLOCK) inner join tbPecaServicoLoja (NOLOCK) on evl_CodigoEmpresa = tsi_CodigoEmpresa And tsi_CodigoPeca = evl_CodigoPeca And tsi_CodigoServico = evl_CodigoServico Where isnull(tsi_ItemOpcionalPDV, '0') = '1' And isnull(evl_ItemInativoPDV, '0') = '1' And tsi_CodigoEmpresa = 2 And tsi_CodigoTabelaPrecoServico = 487 And evl_CodigoLoja = 248 Group By tsi_CodigoPeca,tsi_CodigoServico, tsi_CodigoEmpresa ) As TbItensInativados on TbItensInativados.CodigoEmpresa = tsi_CodigoEmpresa And TbItensInativados.CodigoServico = tsi_CodigoServico And TbItensInativados.CodigoPeca = tsi_CodigoPeca Where tsi_CodigoEmpresa = 2 And tsi_CodigoTabelaPrecoServico = 487 And pea_Ativo = 1 And svr_Ativo = 1 And pfa_Ativo = 1 And TbItensInativados.CodigoServico is null Order By tsi_CodigoTabelaPrecoServico,ofp_Ordenacao,otp_Ordenacao,ots_Ordenacao,pfa_Nome,pea_Nome,svr_Nome Stack Trace: at ideologica.IdeoFramework.BancoDadosSQL.GerarExcecaoComando(SqlCommand comando, Exception innerException) at ideologica.IdeoFramework.BancoDadosSQL.ExecutarParaDataTable(SqlCommand comando, String nomeTabela) at ideologica.clsBD_TabelaPrecoServico.CarregarItensPecasServicos(String CodigoTabelaPrecoServico, String Campos, String Condicao, String CodigoLojaEspecifica, String CondicaoIDPacote, String CondicaoCodigoTabelaPrecoServicoB2B, Boolean RemoverItensOcultosPDV) at ideologica.basPDVServico.CarregaTabelasPrecoPecaServico(String CodigoLoja, String CodigoTabelaPrecoServico, String CondicaoTabelaPrecoServico, String CondicaoIDPacote, String CondicaoIDTabelaPrecoServicoB2B) 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. 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.TrySetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo) 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 - Migracao\PDVServico.exe Versão: 7.0.0.1238 ====================== Informações da Máquina ====================== Nome da Máquina: WS0521 Memória: 7,69 GB Sistema Operacional: Microsoft Windows 11 Pro Processador: 12th Gen Intel(R) Core(TM) i5-1235U (2496Mhz) Usuário: IDEOLOGICA1\dante.borsari Resolução do Vídeo: 1920x1080 Versão SQL Server: Microsoft SQL Server 2019 (RTM-GDR) (KB5084817) - 15.0.2165.1 (X64) Mar 13 2026 19:23:51 Copyright (C) 2019 Microsoft Corporation Express Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 26200: ) (Hypervisor) Versão exe: 7.0.0, Computador: WS0521