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

Not Answered This post has 0 verified solutions | 4,034 Views | 8 Replies | 2 Followers

10 Posts
57 Points
Joined: 2011-12-25
Last Online:
2012-1-2 12:25
Location: CIV
combese agha posted on 2011-12-25 22:09 rated by 0 users

 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,341 Posts
19,352 Points
Joined: 2011-9-5
Last Online:
2016-2-12 23:29
Location: United States

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/

  • | Post Points: 6
10 Posts
57 Points
Joined: 2011-12-25
Last Online:
2012-1-2 12:25
Location: CIV

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.

  • | Post Points: 6
10 Posts
57 Points
Joined: 2011-12-25
Last Online:
2012-1-2 12:25
Location: CIV

Pranav,

Can we contact u through Phone or email?

regards,

 

  • | Post Points: 5
Male
1,341 Posts
19,352 Points
Joined: 2011-9-5
Last Online:
2016-2-12 23:29
Location: United States

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/

  • | Post Points: 6
10 Posts
57 Points
Joined: 2011-12-25
Last Online:
2012-1-2 12:25
Location: CIV

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.

 

  • | Post Points: 6
Male
1,341 Posts
19,352 Points
Joined: 2011-9-5
Last Online:
2016-2-12 23:29
Location: United States

 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/

  • | Post Points: 5
10 Posts
57 Points
Joined: 2011-12-25
Last Online:
2012-1-2 12:25
Location: CIV

Dear Pranav,

Thank you very much for your assistance.

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

 

Regards,

 

  • | Post Points: 6
2 Posts
11 Points
Joined: 2011-12-2
Last Online:
2015-2-25 12:02

What is retail R2 Buld 1032

  • | Post Points: 5
Page 1 of 1 (9 items) | Get this RSS feed