web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / The wait operation tim...
Microsoft Dynamics AX (Archived)

The wait operation timed out - Show Journal in POS

(0) ShareShare
ReportReport
Posted on by Community Member

Good day, Experts. 

I hope you are all doing well. May I seek your help with regards to my issue in searching/showing journal in Retail POS. I am trying to find some receipts and these error occurs: 

57762.1.PNG

51437.2.PNG

I hope you can give me some points to consider in fixing the issue. 

Thank you in advance. 

Regards, 

Raph

*This post is locked for comments

I have the same question (0)
  • Oksana Kovaliova Profile Picture
    Oksana Kovaliova 3,597 on at
    RE: The wait operation timed out - Show Journal in POS

    Hi Raph,

    Please, share full (not truncated) error text

    Regards,

    Oksana

  • Community Member Profile Picture
    Community Member on at
    RE: The wait operation timed out - Show Journal in POS

    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

  • Oksana Kovaliova Profile Picture
    Oksana Kovaliova 3,597 on at
    RE: The wait operation timed out - Show Journal in POS

    Hi Raph,

    Looks like your search query just needs more time to execute than defined in standard timeout.

    I would recommend to use SQL Tracer to find out what SQL query is executed, copy it and run in SQL Management Studio - this will help to measure time needed for execution and analyze how you can make the query faster.

    Also if you have huge number of transactions in store database, you can delete some old transactions from this database - so for old receipts POS will call AX to find a transaction; but for new receipts search will be done faster.

    Regards,

    Oksana

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans