Mostrar Print
Local: PDVServico Mensagem: There is already an open DataReader associated with this Command which must be closed first. Instrucao SQL Select 'A' TIPO,tck_Codigo,tck_DataEmissao,tck_NomeCliente From tbTicket (NOLOCK) Where tck_CodigoEmpresa = 1136 And tck_CodigoLoja = 106 And tck_DataEmissao Between '2026-05-08' And '2026-05-08 23:59' And tck_DataAnulacao is NULL And tck_Ativo = 1 Union All Select 'X' Tipo,tck_Codigo,tck_DataEmissao,tck_NomeCliente From tbTicket (NOLOCK) Where tck_CodigoEmpresa = 1136 And tck_CodigoLoja = 106 And tck_DataAnulacao Between '2026-05-08' And '2026-05-08 23:59' And tck_DataAnulacao is not NULL And tck_Ativo = 1 Union All Select 'E' Tipo,tck_Codigo,tck_DataEmissao,tck_NomeCliente From tbTicket (NOLOCK) Where tck_CodigoEmpresa = 1136 And tck_CodigoLoja = 106 And tck_DataEntregaUltimaPeca Between '2026-05-08' And '2026-05-08 23:59' And tck_DataAnulacao is NULL And tck_Ativo = 1 Union All Select 'O' Tipo,orc_Codigo,orc_DataEmissao,orc_NomeCliente From tbOrcamento (NOLOCK) Where orc_CodigoEmpresa = 1136 And orc_CodigoLoja = 106 And orc_DataEmissao Between '2026-05-08' And '2026-05-08 23:59' Order By tck_DataEmissao Desc Stack Trace: at ideologica.IdeoFramework.BancoDadosSQL.GerarExcecaoComando(SqlCommand comando, Exception innerException) at ideologica.IdeoFramework.BancoDadosSQL.ExecutarParaDataTable(SqlCommand comando, String nomeTabela) at ideologica.clsBD_Ticket.CarregarLancamentosDia(String Dia, String NomeEquipamento, String CodigoOperador, String TipoTicket, String StatusTicket) at ideologica.frmPDVServico.CarregaTicketsDia(String FiltroTipoTicketDia, String FiltroStatusDia) at ideologica.frmPDVServico.CarregaInformacoesDia() at ideologica.frmPDVServico.tabPDV_SelectedTabChanged(Object sender, SelectedTabChangedEventArgs e) at Infragistics.Win.UltraWinTabControl.UltraTabControlBase.OnSelectedTabChanged(SelectedTabChangedEventArgs e) at Infragistics.Win.UltraWinTabControl.UltraTabControlBase.RaiseEvent(UltraTabControlEventId id, EventArgs e) at Infragistics.Win.UltraWinTabControl.UltraTabControlBase.OnManagerSelectedTabItemChanged(Object sender, SelectedTabItemChangedEventArgs e) at Infragistics.Win.UltraWinTabs.TabManager.set_SelectedTabItem(ITabItem value) at Infragistics.Win.UltraWinTabs.TabManager.TabClick(ITabItem tab) at Infragistics.Win.UltraWinTabs.TabItemUIElement.OnMouseDown(MouseEventArgs e, Boolean adjustableArea, UIElement& captureMouseForElement) at Infragistics.Win.UIElement.OnMouseDown(MouseEventArgs e, Boolean adjustableArea, UIElement& captureMouseForElement) at Infragistics.Win.TextUIElementBase.OnMouseDown(MouseEventArgs e, Boolean adjustableArea, UIElement& captureMouseForElement) at Infragistics.Win.ControlUIElementBase.ProcessMouseDownHelper(Object sender, MouseEventArgs e) at Infragistics.Win.ControlUIElementBase.ProcessMouseDown(Object sender, MouseEventArgs e) at Infragistics.Win.Utilities.ProcessEvent(Control control, ProcessEvent eventToProcess, EventArgs e) at Infragistics.Win.UltraControlBase.OnMouseDown(MouseEventArgs e) at System.Windows.Forms.Control.WmMouseDown(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: System.Data Mensagem: There is already an open DataReader associated with this Command which must be closed first. Stack Trace: at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command) at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command) at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) 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) ========================= Informações do Aplicativo ========================= Arquivo: PDVServico.exe Caminho: C:\Allegro.IoT\PDVServico.exe Versão: 7.0.0.1193 ====================== Informações da Máquina ====================== Nome da Máquina: DESKTOP-84DSUIF Memória: 7,89 GB Sistema Operacional: Microsoft Windows 10 Pro Processador: Intel(R) Core(TM) i5-4570 CPU @ 3.20GHz (3193Mhz) Usuário: DESKTOP-84DSUIF\User Resolução do Vídeo: 1600x900 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
(Build 19045: ) Versão exe: 7.0.0, Computador: DESKTOP-84DSUIF