AX Retail POS becomes very slow when pos invoice lines exceed ten lines !!

Latest Axapta / Dynamics AX FAQ Pages

Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
Newsletter Subscription Center
page a complete list of our different newsletters.

Not Answered This post has 0 verified solutions | 8 Replies | 2 Followers

10 Posts
92 Points
Joined: 2011-12-25
Last Online:
2012-1-2 12:25
Location: CIV
combese agha posted on 2011-12-25 22:09

 Environment : DAX2009SP1RU7 + AX Retail R2

OS : WIN2003SERVER R2 + SQL2008SP2 32 bits

We have three POS terminals connected to a head quarter throu a LAN connection.

We have several hundreds of items and our database is still very small.

We have just finished installation + setup and configuration. All parts HQ + Scheduler+POS are working properly. data is replicated correctly and we are able to generate and post daily statements.

At the 3 POS machines we are facing a common problem: When POS transaction exceeds several lines lets say 10 lines,

the POS machaine start getting slower. It takes 3 seconds to disply the item line on the screen after scanning it. If we reach for example, 30 lines, the POS becomes very slow ( 20-30 seconds to disply the line item).

As we do not think that this is normal , we tried to find out  the reason for the slowness using sql profiler, and performance monitor, but we could not notice anything.

I downloaded and installed the hotfix of kb/2448842     which talk about slowness in POS due to TAX issues.. . But with

no use.

Did anybody there experience such a problem... please advise

 

All Replies

Male
1,234 Posts
22,100 Points
Joined: 2011-9-5
Last Online:
2014-7-31 1:17
Location: United States
Pranav Kumar replied on 2011-12-26 7:41

Hi,

Have you done any customization for the POS??

What is the configuration of POS machine? And does all the three POS has its own database??

 

We didn't faced this problem during our implementation. Even we used more than 40 items in a single transaction. We weren't using scan gun to read bar codes.

Pranav...

-- 

Expect the best, plan for the worst and prepare to be surprised

http://pranavkumaar.wordpress.com/

10 Posts
92 Points
Joined: 2011-12-25
Last Online:
2012-1-2 12:25
Location: CIV
combese agha replied on 2011-12-26 8:04

1) No customisation to the POS application.

2) each POS is 2GB of RAM, 300+GB HHD and Intel 1.3MHz

3) Three POS machines are connected to a shared store db server through a LAN. No databases

     on the POS machines.

10 Posts
92 Points
Joined: 2011-12-25
Last Online:
2012-1-2 12:25
Location: CIV
combese agha replied on 2011-12-26 8:06

Pranav,

Can we contact u through Phone or email?

regards,

 

Male
1,234 Posts
22,100 Points
Joined: 2011-9-5
Last Online:
2014-7-31 1:17
Location: United States
Pranav Kumar replied on 2011-12-26 9:41

Hi Combese,

You need to test one more scenario. Install the POS on a local machine with its own DB(sqlexpress).

Run the POS with standard database and make the same transactions. Check the timings in this case.

I hope you are using Windows7 OS on the machine. I can be reached at pranav.2204@gmail.com

 

Pranav...

-- 

Expect the best, plan for the worst and prepare to be surprised

http://pranavkumaar.wordpress.com/

10 Posts
92 Points
Joined: 2011-12-25
Last Online:
2012-1-2 12:25
Location: CIV
combese agha replied on 2011-12-26 10:27

We tried to run the POS application on the store db it self, when we run it we always get the error that user id is not valid . The screen where we enter the user id and password is opened, showing the name of the user, but when we enter user id and password, it gives the error that the user is is not valid.

 

Male
1,234 Posts
22,100 Points
Joined: 2011-9-5
Last Online:
2014-7-31 1:17
Location: United States
Pranav Kumar replied on 2011-12-26 10:43

 In this case, you need to replicate RBOSTORETABLE and RBOSTAFF table. I may be wrong in the names of table but run the scheduler job for staff and store for the concerned location.

 The error is coming becuase on the local POS machine, there is some problem with staff table. Check in the table whether staff id as present in the db or not.

-- 

Expect the best, plan for the worst and prepare to be surprised

http://pranavkumaar.wordpress.com/

10 Posts
92 Points
Joined: 2011-12-25
Last Online:
2012-1-2 12:25
Location: CIV
combese agha replied on 2011-12-28 14:05

Dear Pranav,

Thank you very much for your assistance.

The problem is solved when we upgraded to retail R2 refresh build 1032

 

Regards,

 

2 Posts
16 Points
Joined: 2011-12-2
Last Online:
2013-10-11 13:52
mbasharat23 replied on 2012-6-15 14:02

What is retail R2 Buld 1032

Page 1 of 1 (9 items) | Get this RSS feed | Bookmark and Share