Skip to main content

Notifications

Microsoft Dynamics RMS forum

Item Lookup in Store Ops POS keeps freezing

Posted on by Microsoft Employee

A few times a day, one of our client will run into an issue where the lookup function in Store Operations POS will become unresponsive. None of the buttons or scrollbar work and you cannot click on any items in the list. The only way to fix it is to hit escape to close the window, and restart POS at which point it will work again, but only for a short time until it stops working. Is there any solution to this? They are running Store Operations version 2.0.2000 and are on the latest service pack and this is brand new hardware (replaced within the past month).

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item Lookup in Store Ops POS keeps freezing

    Mabuhay!

    I think the solution of Sir Arif will help. Truncating the log file, reindexing and checking DB will help your transaction to run smooth. But unfortunately you still encounter this error.

    Have you tried making inactive items which is not use anymore? To lessen your skus values?

    Or have you tried doing an offline POS lane so you can check even of its ofline state error still appears? If error still appear have you tried unsintall OPOS and RMS? and fresh install it? And have you tried replacing your offline database? But be sure to back up it so for the worst scenario you can still recover their offline data.

    Chris

  • Steve Beach Profile Picture
    Steve Beach 20 on at
    RE: Item Lookup in Store Ops POS keeps freezing

    We have the same exact issue with the item lookup screen on multiple registers. Also version 2.0.2000.

    Did anyone find a fix?

    Might be a coincidence, but we also installed the RR RMS Shift4 add-on this week.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item Lookup in Store Ops POS keeps freezing

    Hi,

    I was wondering if there was ever a fix for this? we also have a few clients experiencing this exact issue. we have checked all the communication between server and POS and everything looks good.

  • Dave Durrenberger Profile Picture
    Dave Durrenberger 1,620 on at
    RE: Item Lookup in Store Ops POS keeps freezing

    Arthur,

    We have a solution. The Item and Picture Drill Down allows you to rapidly locate and select items. You can read more about it or watch a demo on this link: www.syssolutionsllc.com/.../ItemPictureDrillDown. If you have questions about it, please feel free to contact us at sales@syssolutionsllc.com

    -The System Solutions Team 

  • Suggested answer
    arishi Profile Picture
    arishi 740 on at
    RE: Item Lookup in Store Ops POS keeps freezing

    there is a possibility that the server do not have enough resources

    what is the specs on the server with OS, HDD free space, Memory?

    try this on all PC including server

    open SO Manager --> Items -->edit Items (see how much time it takes to display all items) if it's preforming slow

    also make sure you have enough space for SQL Database, copy this script in Administrator --> query --> run

    SELECT

         database_name = DB_NAME(database_id)

       , log_size_mb = CAST(SUM(CASE WHEN type_desc = 'LOG' THEN size END) * 8. / 1024 AS DECIMAL(8,2))

       , row_size_mb = CAST(SUM(CASE WHEN type_desc = 'ROWS' THEN size END) * 8. / 1024 AS DECIMAL(8,2))

       , total_size_mb = CAST(SUM(size) * 8. / 1024 AS DECIMAL(8,2))

    FROM sys.master_files WITH(NOWAIT)

    WHERE database_id = DB_ID() -- for current db

    GROUP BY database_id

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item Lookup in Store Ops POS keeps freezing

    Is there any kind of netdisplay enabled? Maybe it's pulling an html that is causing an issue.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item Lookup in Store Ops POS keeps freezing

    Yes I tried all those things and the problem happens on every register.

  • arishi Profile Picture
    arishi 740 on at
    RE: Item Lookup in Store Ops POS keeps freezing

    did you do DataBase Check and Reindex?

    did you check POS station for performance?

    did you try on the other register if the same problem appears?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item Lookup in Store Ops POS keeps freezing

    Has anyone found a solution for this yet?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item Lookup in Store Ops POS keeps freezing

    They have two registers, one of which they don't use, and a server in the back office. They are networked via a switch and router.

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

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,129 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans