Item Lookup in Store Ops POS keeps freezing

(0) Share

Report

Posted on by Community Member 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

All responses (15)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

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 20 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 1,620 on at

Like (0)

Report

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 740 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

RE: Item Lookup in Store Ops POS keeps freezing

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

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

RE: Item Lookup in Store Ops POS keeps freezing

Has anyone found a solution for this yet?
Community Member Microsoft Employee on at

Like (0)

Report

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.