Hi Oksana,
Good day :)
Here is the full error text:
Microsoft.Dynamics.Retail.Pos.Dialog.WinFormsTouch.frmJournal, Text: Show journal: System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
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)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
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.ExecuteReader()
at LSRetailPosis.DataAccess.JournalData.SearchOrders(SalesOrderSearchCriteria criteria, Int64 lastRowNumber, Int32 numberOfTransactions, String saleText, String paymentText, String salesOrderText, String salesInvoiceText, String customerOrderText, String incomeExpenseText, String safeDropText, String bankDropText, String tenderDeclarationText)
at Microsoft.Dynamics.Retail.Pos.Dialog.WinFormsTouch.frmJournal.GetSearchResults()
at Microsoft.Dynamics.Retail.Pos.Dialog.WinFormsTouch.frmJournal.btnSearch_Click(Object sender, EventArgs e)
ClientConnectionId:075317f3-cb5e-4228-8731-a5436158ea84
Error Number:-2,State:0,Class:11.
I hope you can help me with this.
Thanks,
Raph
