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 'P' TIPO, 0 Item, tpn_Codigo As TPN_CODIGO, tpn_Status As TPN_STATUS, tkp_NomePeca, tpn_Etiqueta, 1 As tkp_Quantidade,0.0 VALORUNITARIO, 0.00 As DESCONTOUNITARIO, 0.0 Preco, isnull(tkp_NomeCor1,'') + ' ' + isnull(tkp_NomeCor2,'') + ' ' + isnull(tkp_NomeCor3,'') Cor, tkp_NomeMarca,tkp_NomeEstampa,tkp_NomeTamanho,tkp_DataPrevistaEntrega AS TKP_DATAPREVISTAENTREGA, epc_Nome,epc_Cor As EPC_COR,tpn_PosicaoEstoquePeca, ISNULL(epc_Nome, '') LOCALESTOQUEPECA, tpn_DataEntrega,tpn_NomeOperadorEntregou, tpn_DataDisponibilizacao,tpn_NomeOperadorDisponibilizou,tkp_Sequencia As TKP_SEQUENCIA,tpn_Sequencia As TPN_SEQUENCIA, '' Imagens,'' Processos,0 POSSUIIMAGENS, 0 As TSS_REGRAASSINATURA, 0.0 As RESTANTE, getdate() TSS_DATAVENCIMENTO, tck_ValorTotalProdutos As TCK_VALORTOTALPRODUTOS, tck_DescontoTotalProdutos As TCK_DESCONTOTOTALPRODUTOS, tck_ValorTotalServicos AS TCK_VALORTOTALSERVICOS, tck_DescontoTotalServicos As TCK_DESCONTOTOTALSERVICOS, tck_ValorTaxaAdicional As TCK_VALORTAXAADICIONAL, tck_ValorNaoPago As TCK_VALORNAOPAGO, tpn_CodigoBarrasProcessoInterno,tpn_CodigoBarrasIntegracao,tck_QuantidadeTotalPecas AS TCK_QUANTIDADETOTALPECAS, tck_NumeroOS TCK_NUMEROOS, isnull(tck_DescontoTotalAposEmissao,0) TCK_DESCONTOTOTALAPOSEMISSAO, tkp_QuantidadeImpressos As TKP_QUANTIDADEIMPRESSOS, tck_ValorTotalAssinaturas AS TCK_VALORTOTALASSINATURAS, TPN_DATAPREVISTAEXECUCAO, tck_NomeOperadorEmitiu, tkp_ValorUnitarioComAcrescimoDescontoTicket AS VALORUNITARIODESCONTOACRESCIMO , tkp_ValorUnitario As PRECOIMPRESSAO, '' TIPOQUILOCESTO, TPN_CODIGOTICKETPECA, tkp_DataPrevistaEntrega AS DATAORIGINALPREVISTAENTREGA, TCK_VALORTAXAADICIONALAPOSEMISSAO From tbTicket (NOLOCK) Inner Join tbTicketPeca (NOLOCK) on tck_CodigoEmpresa = tkp_CodigoEmpresa And tck_CodigoLoja = tkp_CodigoLoja And tck_Codigo = tkp_CodigoTicket Left Join tbPeca (NOLOCK) on tkp_CodigoEmpresa = pea_CodigoEmpresa And tkp_CodigoPeca = pea_Codigo Inner Join tbTicketPecaIndividual (NOLOCK) On tkp_CodigoEmpresa = tpn_CodigoEmpresa And tkp_CodigoLoja = tpn_CodigoLoja And tkp_Codigo = tpn_CodigoTicketPeca Left Join tbEstoquePeca (NOLOCK) On tpn_CodigoEmpresa = epc_CodigoEmpresa And tpn_CodigoLoja = epc_CodigoLoja And tpn_CodigoEstoquePeca = epc_Codigo Where tkp_CodigoEmpresa = 6 And tkp_CodigoLoja = 432 And tkp_CodigoTicket = -1 Union All Select 'D' TIPO, 0 Item, tpr_Codigo * -1, '' tpn_Status,tpr_NomeProduto,'' tpn_Etiqueta,tpr_Quantidade,tpr_ValorUnitario ValorUnitario, isnull(tpr_DescontoUnitario, 0) DescontoUnitario,tpr_ValorUnitario - tpr_DescontoUnitario Preco, '' Cor, '' tkp_NomeMarca,'' tkp_NomeEstampa,'' tkp_NomeTamanho,NULL tkp_DataPrevistaEntrega, '' epc_Nome,NULL epc_Cor,NULL tpn_PosicaoEstoquePeca, '' LOCALESTOQUEPECA, NULL tpn_DataEntrega,NULL tpn_NomeOperadorEntregou, NULL tpn_DataDisponibilizacao,NULL tpn_NomeOperadorDisponibilizou, 9999 tkp_Sequencia, tpr_Sequencia, '' Imagens,'' Processos,0 PossuiImagens, 0 As tss_RegraAssinatura, 0.0 As Restante, getdate() tss_DataVencimento, tck_ValorTotalProdutos, tck_DescontoTotalProdutos, tck_ValorTotalServicos, tck_DescontoTotalServicos, tck_ValorTaxaAdicional, tck_ValorNaoPago, '' tpn_CodigoBarrasProcessoInterno,'' tpn_CodigoBarrasIntegracao,0 tck_QuantidadeTotalPecas, tck_NumeroOS TCK_NUMEROOS, isnull(tck_DescontoTotalAposEmissao,0) TCK_DESCONTOTOTALAPOSEMISSAO, 0 As TKP_QUANTIDADEIMPRESSOS, tck_ValorTotalAssinaturas AS TCK_VALORTOTALASSINATURAS, NULL TPN_DATAPREVISTAEXECUCAO, tck_NomeOperadorEmitiu, tpr_ValorUnitarioComAcrescimoDescontoTicket AS VALORUNITARIODESCONTOACRESCIMO , tpr_ValorUnitario - tpr_DescontoUnitario As PRECOIMPRESSAO, '' TIPOQUILOCESTO, '' TPN_CODIGOTICKETPECA, NULL AS DATAORIGINALPREVISTAENTREGA, TCK_VALORTAXAADICIONALAPOSEMISSAO From tbTicket (NOLOCK) Inner Join tbTicketProduto (NOLOCK) on tck_CodigoEmpresa = tpr_CodigoEmpresa And tck_CodigoLoja = tpr_CodigoLoja And tck_Codigo = tpr_CodigoTicket Where tpr_CodigoEmpresa = 6 And tpr_CodigoLoja = 432 And tpr_CodigoTicket = -1 Union All Select 'Q' TIPO, 0 Item, tql_Codigo * -1000, '' tpn_Status,tql_NomeQuilo,'' tpn_Etiqueta,tql_Peso,tql_ValorUnitario ValorUnitario, isnull(tql_DescontoUnitario, 0) DescontoUnitario,tql_ValorUnitario - isnull(tql_DescontoUnitario, 0) Preco, '' Cor, '' tkp_NomeMarca,'' tkp_NomeEstampa,'' tkp_NomeTamanho,NULL tkp_DataPrevistaEntrega, '' epc_Nome,NULL epc_Cor,NULL tpn_PosicaoEstoquePeca, '' LOCALESTOQUEPECA, NULL tpn_DataEntrega,NULL tpn_NomeOperadorEntregou, NULL tpn_DataDisponibilizacao,NULL tpn_NomeOperadorDisponibilizou, 8888 tkp_Sequencia, tql_Sequencia, '' Imagens,'' Processos,0 PossuiImagens, 0 As tss_RegraAssinatura, 0.0 As Restante, getdate() tss_DataVencimento, tck_ValorTotalProdutos, tck_DescontoTotalProdutos, tck_ValorTotalServicos, tck_DescontoTotalServicos, tck_ValorTaxaAdicional, tck_ValorNaoPago, '' tpn_CodigoBarrasProcessoInterno,'' tpn_CodigoBarrasIntegracao,0 tck_QuantidadeTotalPecas, tck_NumeroOS TCK_NUMEROOS, isnull(tck_DescontoTotalAposEmissao,0) TCK_DESCONTOTOTALAPOSEMISSAO, 0 As TKP_QUANTIDADEIMPRESSOS, tck_ValorTotalAssinaturas AS TCK_VALORTOTALASSINATURAS, NULL TPN_DATAPREVISTAEXECUCAO, tck_NomeOperadorEmitiu, tql_ValorUnitarioComAcrescimoDescontoTicket AS VALORUNITARIODESCONTOACRESCIMO , tql_ValorUnitario - tql_DescontoUnitario As PRECOIMPRESSAO, isnull(tql_Tipo, 'K') TIPOQUILOCESTO, '' TPN_CODIGOTICKETPECA, NULL AS DATAORIGINALPREVISTAENTREGA, TCK_VALORTAXAADICIONALAPOSEMISSAO From tbTicket (NOLOCK) Inner Join tbTicketQuilo (NOLOCK) on tck_CodigoEmpresa = tql_CodigoEmpresa And tck_CodigoLoja = tql_CodigoLoja And tck_Codigo = tql_CodigoTicket Where tql_CodigoEmpresa = 6 And tql_CodigoLoja = 432 And tql_CodigoTicket = -1 Union All Select 'ASSINATURA' Tipo, 0 Item, tss_Codigo, '' Status,tss_NomeAssinatura,'' tpn_Etiqueta, 1 Quantidade,tss_Valor As ValorUnitario, isnull(tss_DescontoUnitario, 0) DescontoUnitario,tss_Valor - isnull(tss_DescontoUnitario, 0) As Preco, '' Cor, '' NomeMarca,'' NomeEstampa,'' NomeTamanho,NULL DataPrevistaEntrega, '' epc_Nome,NULL epc_Cor,NULL tpn_PosicaoEstoquePeca,'' LOCALESTOQUEPECA, NULL tpn_DataEntrega,NULL tpn_NomeOperadorEntregou, NULL tpn_DataDisponibilizacao,NULL tpn_NomeOperadorDisponibilizou, tss_Sequencia, 999 tpr_Sequencia, '' Imagens,'' Processos,0 PossuiImagens, tss_RegraAssinatura, tss_QuantidadeItens - isnull(tss_SaldoSangradoTransferido, 0) + isnull(tss_SaldoDepositadoTransferido, 0) - isnull(tss_QuantidadeItensConsumido,0) As Restante, tss_DataVencimento, tck_ValorTotalProdutos, tck_DescontoTotalProdutos, tck_ValorTotalServicos, tck_DescontoTotalServicos, tck_ValorTaxaAdicional, tck_ValorNaoPago, '' tpn_CodigoBarrasProcessoInterno,'' tpn_CodigoBarrasIntegracao,0 tck_QuantidadeTotalPecas, tck_NumeroOS TCK_NUMEROOS, isnull(tck_DescontoTotalAposEmissao,0) TCK_DESCONTOTOTALAPOSEMISSAO, 0 As TKP_QUANTIDADEIMPRESSOS, tck_ValorTotalAssinaturas AS TCK_VALORTOTALASSINATURAS, NULL TPN_DATAPREVISTAEXECUCAO, tck_NomeOperadorEmitiu, tss_ValorUnitarioComAcrescimoDescontoTicket AS VALORUNITARIODESCONTOACRESCIMO , tss_Valor - tss_DescontoUnitario As PRECOIMPRESSAO, '' TIPOQUILOCESTO, '' TPN_CODIGOTICKETPECA, NULL AS DATAORIGINALPREVISTAENTREGA, TCK_VALORTAXAADICIONALAPOSEMISSAO From tbTicket (NOLOCK) Inner Join tbTicketAssinatura (NOLOCK) on tck_CodigoEmpresa = tss_CodigoEmpresa And tck_CodigoLoja = tss_CodigoLoja And tck_Codigo = tss_CodigoTicket Where tss_CodigoEmpresa = 6 And tss_CodigoLoja = 432 And tss_CodigoTicket = -1 Order By tkp_Sequencia,tpn_Sequencia; Select tis_CodigoTicketPecaIndividual AS TIS_CODIGOTICKETPECAINDIVIDUAL, tis_NomeServico + ' ' + isnull(tis_NomeServicoIndexador,'') As tis_NomeServico, tis_Status AS TIS_STATUS,tis_Quantidade, isnull(tis_ValorUnitario, 0) As ValorUnitario, isnull(tis_DescontoUnitario, 0) DescontoUnitario, tis_ValorUnitario-tis_DescontoUnitario As Preco, tis_DataPrevistaExecucao, tis_DataExecucao, tis_NomeOperadorExecutou, tis_DataAvaliacao, tis_NomeOperadorAvaliacao, tis_DataDisponibilizacao, tis_NomeOperadorDisponibilizou, tis_Medida1 As TIS_MEDIDA1, tis_Medida2 As TIS_MEDIDA2, tis_Medida3 As TIS_MEDIDA3, tis_TipoMedida As TIS_TIPOMEDIDA, tis_NomeAssinatura As TIS_NOMEASSINATURA, tis_ValorUnitarioAssinatura As TIS_VALORUNITARIOASSINATURA, tis_ValorUnitarioTabela AS TIS_VALORUNITARIOTABELA, '' As OrigemDesconto, tis_Codigo AS TIS_CODIGO, tis_TipoServico as TIS_TIPOSERVICO, TIS_VALORFATORMODIFICAPRECOUNITARIO, TIS_VALORDESCONTOPROGRESSIVOFORMATADOR, isnull(tis_NomeFatorPreco, '') As TIS_NOMEFATORPRECO, isnull(tis_NomeInformacaoCondicionalTicket, '') As TIS_NOMEINFORMACAOCONDICIONALTICKET, ISNULL(sgr_ImpressoraServicoGrupo, 0) As SGR_IMPRESSORASERVICOGRUPO, TIS_DIFICULDADE, TIS_NOMESERVICOGRUPO, isnull(tis_ValorUnitarioComAcrescimoDescontoTicket, 0) As tis_ValorUnitarioComAcrescimoDescontoTicket, tis_NomeSubItem1, tis_NomeSubItem2, tis_NomeSubItem3 From tbTicketPecaIndividualServico (NOLOCK) Inner Join tbTicketPecaIndividual (NOLOCK) On tpn_CodigoEmpresa = tis_CodigoEmpresa And tpn_CodigoLoja = tis_CodigoLoja And tpn_Codigo = tis_CodigoTicketPecaIndividual Left Join tbServicoGrupo (NOLOCK) On sgr_CodigoEmpresa = tis_CodigoEmpresa And sgr_Codigo = tis_CodigoServicoGrupo Inner Join tbTicketPeca (NOLOCK) On tkp_CodigoEmpresa = tpn_CodigoEmpresa And tkp_CodigoLoja = tpn_CodigoLoja And tkp_Codigo = tpn_CodigoTicketPeca Where tkp_CodigoEmpresa = 6 And tkp_CodigoLoja = 432 And tkp_CodigoTicket = -1 Order By tis_Sequencia; Select tpn_Codigo AS TPN_CODIGO,tpo_NomeObservacaoDefeito, tpo_Complemento From tbTicketPeca (NOLOCK) Inner Join tbTicketPecaIndividual (NOLOCK) On tkp_CodigoEmpresa = tpn_CodigoEmpresa And tkp_CodigoLoja = tpn_CodigoLoja And tkp_Codigo = tpn_CodigoTicketPeca Inner Join tbTicketPecaobservacaoDefeito (NOLOCK) On tkp_CodigoEmpresa = tpo_CodigoEmpresa And tkp_CodigoLoja = tpo_CodigoLoja And tkp_Codigo = tpo_CodigoTicketPeca Where tkp_CodigoEmpresa = 6 And tkp_CodigoLoja = 432 And tkp_CodigoTicket = -1 Order By tpo_Sequencia; Select distinct tis_Sequencia, ref_CodigoTicketPecaIndividualServico, ref_NomeJustificativa, ref_Data, tis_CodigoTicketPecaIndividual From tbLOG_Refazer (NOLOCK) Inner Join tbTicketPecaIndividualServico (NOLOCK) On ref_CodigoEmpresa = tis_CodigoEmpresa And ref_CodigoLoja = tis_CodigoLoja And ref_CodigoTicketPecaIndividualServico = tis_Codigo And ref_CodigoTicket = tis_CodigoTicket Inner Join tbTicketPecaIndividual (NOLOCK) On tpn_CodigoEmpresa = tis_CodigoEmpresa And tpn_CodigoLoja = tis_CodigoLoja And tpn_Codigo = tis_CodigoTicketPecaIndividual Where ref_CodigoEmpresa = 6 And ref_CodigoLoja = 432 And ref_Tipo = 'R' And ref_CodigoTicket = -1 Order By tis_Sequencia; Select distinct tis_Sequencia, ref_CodigoTicketPecaIndividualServico, ref_NomeJustificativa, tis_CodigoTicketPecaIndividual From tbLOG_Refazer (NOLOCK) Inner Join tbTicketPecaIndividualServico (NOLOCK) On ref_CodigoEmpresa = tis_CodigoEmpresa And ref_CodigoLoja = tis_CodigoLoja And ref_CodigoTicketPecaIndividualServico = tis_Codigo And ref_CodigoTicket = tis_CodigoTicket Inner Join tbTicketPecaIndividual (NOLOCK) On tpn_CodigoEmpresa = tis_CodigoEmpresa And tpn_CodigoLoja = tis_CodigoLoja And tpn_Codigo = tis_CodigoTicketPecaIndividual Where ref_CodigoEmpresa = 6 And ref_CodigoLoja = 432 And ref_Tipo = 'R' And ref_CodigoTicket = -1 Order By tis_Sequencia; Stack Trace: at ideologica.IdeoFramework.BancoDadosSQL.GerarExcecaoComando(SqlCommand comando, Exception innerException) at ideologica.IdeoFramework.BancoDadosSQL.ExecutarParaDataSet(SqlCommand comando) at ideologica.clsBD_Ticket.CarregarDetalhesPecasProdutosAssinaturas(String CodigoLoja, String CodigoTicket, String CodigoPeca, String CodigoPecaIndividual) at ideologica.frmVisualizarTicketServico.CarregaDetalhesTicket(String CodigoTicket) at ideologica.frmVisualizarTicketServico.Pesquisar(String CodigoTicket, String CodigoOrcamento, String OrdemServico, String Etiqueta) at ideologica.frmVisualizarTicketServico.InicializaJanela() at ideologica.frmPDVServico.cmdVisualizarTicket_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.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(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at ideologica.IdeoFramework.BancoDadosSQL.ExecutarParaDataSet(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: DESKTOP-AN5QNID Memória: 7,90 GB Sistema Operacional: Microsoft Windows 10 Pro Processador: Intel(R) Core(TM) i5-6500T CPU @ 2.50GHz (2496Mhz) Usuário: DESKTOP-AN5QNID\Dell 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-AN5QNID