Ls Retail On Navision (need help)

hasan

when we use more than one user in one database using client-server (online architecture).what happens LS Retail on Navision (3.7) does not allow more than one transaction at a time, it shows the message "Lock by super/other user “.and automatically after the another transaction completed this transaction also complete but the screen become faded out/discolored/gray. (The main sale window) And the button does not work any more. It seems to system hung. But After pressing the mouse left button frequently several time, normal screen appear again. Any one has a clue about problem please reply.

i have notice that this fadness is related to system message like "searching transaction table". or "lock by super". by incrasing commit cache i can stop "searching transaction table" type message but i have nothing to do with "lock by super" type system message.

the same code i have not any problem in offline architecture. as a database has only one user here.
plz help me....

ara3n

time to archive your old transaction. Or if you really want to solve the problem, get a hold of your solution center to take a look at what causes the performance problem.

hasan

Thanks for your reply

I have not any problems with message because it shows only that the transactions are in queue. But why this faded out/discolored/grayness occurs?

Online Architecture is supported by LS and Navision. So I think it should be a known problem.
Other wise it is really awful for Navision or LS.

One more thing, this is also occurs in very small database too. So archiving is not a solution. Archiving help to decrease the “searching transaction table" type message. But “lock by super/user” is occurring for doing more than one transaction at time.

Hasan

David_Cox

It is a long time since I looked at LS Retail but how is your system setup?

All POS and Users looking at the one database?
If all POS tills are looking at the one database, then this could mean a lot of read / writes are taking place, how fast are the other processes like Item lookup running, and other POS functions?
Are any other non POS users using the database and running processes that affect these tables?.
The time to commit the sale should be quite fast, as it only updates a few tables.
Is this standard out the box or a modified version?

David

ara3n

online architecture, meaning you are using LS retail transaction server?

Basically the process for that is this. DD creates the packets for the order and sends it to HQ to be processed and waits while that is done. During that waiting time navision client cannot do anything, and thus the blank screen.

I'd suggest changing the replication method and go with offline mode and replicate the data asynchronous, that way when you post a transaction it doesn't have to wait for it to be processed at HQ.