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
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
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.
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.
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
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
Is there any kind of netdisplay enabled? Maybe it's pulling an html that is causing an issue.
Yes I tried all those things and the problem happens on every register.
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?
Has anyone found a solution for this yet?
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,802 Super User 2024 Season 2
Martin Dráb 229,129 Most Valuable Professional
nmaenpaa 101,154