This article applies to Microsoft Dynamics AX for Retail 2012 for all regions.

Note Depending on which POS hotfixes you have previously installed, this hotfix may require an upgrade of the Microsoft Dynamics AX for Retail POS database. To upgrade the database, follow these steps:

  1. Do the following before you install the hotfix:

    1. Make a backup of your existing store database.

    2. In SQL Management Studio, view the current database version (DBversion) by running the follow SQL statement:

      select * from POSISINFO
  2. Do the following after you install the hotfix:

    1. Start Retail Database Utility.

    2. In the Retail POS configuration dialog box, enter information into the fields under Store database and under Identification, and then click Continue. This executes the script, if available, to upgrade your database.
      Retail POS configuration dialog box

    3. In SQL Management Studio, run the SQL Statement again to verify that the database version has changed.

Symptoms

Assume that you use Microsoft SQL Server Express for Microsoft Dynamics AX for Retail 2012 POS. The transaction data in POS store databases grows large to approach or exceed the Microsoft SQL Server Express database size limitation. You expect to clean out the data in the RetailTransactionTableEx5 table and older transactions in the store database. This problem occurs in the following products:

  • Microsoft Dynamics AX for Retail 2012 R2

  • Microsoft Dynamics AX for Retail 2012 R1

Resolution

Hotfix information

A supported hotfix is available from Microsoft. There is a "Hotfix download available" section at the top of this Knowledge Base article. If you are encountering an issue downloading, installing this hotfix, or have other technical support questions, contact your partner or, if enrolled in a support plan directly with Microsoft, you can contact technical support for Microsoft Dynamics and create a new support request. To do this, visit the following Microsoft website:

https://mbs.microsoft.com/support/newstart.aspx You can also contact technical support for Microsoft Dynamics by phone using these links for country specific phone numbers. To do this, visit one of the following Microsoft websites:

Partners

https://mbs.microsoft.com/partnersource/support/Customers

https://mbs.microsoft.com/customersource/support/information/SupportInformation/global_support_contacts_eng.htmIn special cases, charges that are ordinarily incurred for support calls may be canceled if a Technical Support Professional for Microsoft Dynamics and related products determines that a specific update will resolve your problem. The usual support costs will apply to any additional support questions and issues that do not qualify for the specific update in question.

Installation information

Important To take advantage of this hotfix, you must enter the number of days that transactions should be preserved in the POS database in the Days transactions exist field in the functionality profile for each store. You must make sure that you run P jobs more frequently than the number of days that you fill into the Days transactions exist field. If you do not do this, the transactions that have not yet been pulled into Microsoft Dynamics AX will be deleted. We suggest that you run P jobs daily and delete only those transactions that are older than 30, 60, or even 90 days.

Note Depending on other hotfixes installed, you might have to upgrade the Retail POS database after you install this hotfix. If database upgrade is required, you will see a message when you run Retail POS that says the database versions do not match

If you have customizations for one or more of the methods or the tables that are affected by this hotfix, you must apply these changes in a test environment before you apply the hotfix in a production environment.
For more information about how to install this hotfix, click the following article number to view the article in the Microsoft Knowledge Base:

893082 How to install a Microsoft Dynamics AX hotfix

Prerequisites

You must have one of the following products installed to apply this hotfix:

  • Microsoft Dynamics AX for Retail 2012 R2

  • Microsoft Dynamics AX for Retail 2012 R1

Restart requirement

You must restart the Application Object Server (AOS) service after you apply the hotfix.

The global version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.
Microsoft Dynamics AX for Retail 2012 R2

File name

File version

File size

Date

Time

Platform

Service branch

Aximpactanalysis.exe

Not applicable

61,136

20-Nov-2012

17:59

x86

Not applicable

Axupdate.exe

Not applicable

61,120

20-Nov-2012

17:59

x86

Not applicable

Clientoba32.msp

Not applicable

19,152,896

02-Apr-2013

04:51

Not applicable

Not applicable

Clientoba64.msp

Not applicable

19,324,928

02-Apr-2013

04:51

Not applicable

Not applicable

Commercedataexchangereal-timeservice.msp

Not applicable

49,152

02-Apr-2013

04:51

Not applicable

Not applicable

Commercedataexchangesynchservice32.msp

Not applicable

122,880

02-Apr-2013

04:51

Not applicable

Not applicable

Commercedataexchangesynchservice64.msp

Not applicable

122,880

02-Apr-2013

04:51

Not applicable

Not applicable

Components32.msp

Not applicable

17,006,592

02-Apr-2013

04:51

Not applicable

Not applicable

Components64.msp

Not applicable

34,390,016

02-Apr-2013

04:51

Not applicable

Not applicable

Objectserver32.msp

Not applicable

6,811,648

02-Apr-2013

04:51

Not applicable

Not applicable

Objectserver64.msp

Not applicable

14,716,928

02-Apr-2013

04:53

Not applicable

Not applicable

Retaildatabaseutility.msp

Not applicable

524,288

02-Apr-2013

04:51

Not applicable

Not applicable

Retailheadquarters32.msp

Not applicable

2,834,432

02-Apr-2013

04:51

Not applicable

Not applicable

Retailheadquarters64.msp

Not applicable

2,834,432

02-Apr-2013

04:51

Not applicable

Not applicable

Retailonlinechannel.msp

Not applicable

2,740,224

02-Apr-2013

04:53

Not applicable

Not applicable

Retailpos.msp

Not applicable

4,358,144

02-Apr-2013

04:53

Not applicable

Not applicable

Retailposplugins.msp

Not applicable

47,906,816

02-Apr-2013

04:53

Not applicable

RETAILPOSP

Setupsupport32.msp

Not applicable

6,250,496

02-Apr-2013

04:53

Not applicable

Not applicable

Setupsupport64.msp

Not applicable

13,512,704

02-Apr-2013

04:53

Not applicable

Not applicable

Axsetupsp.exe

6.2.139.8316

1,390,784

20-Nov-2012

17:59

x86

Not applicable

Axutillib.dll

6.2.120.0

929,560

02-Apr-2013

05:21

x86

Not applicable

Microsoft.dynamics.servicing.operations.dll

6.2.73.8303

37,168

01-Nov-2012

20:18

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

387,368

02-Apr-2013

05:21

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

375,080

02-Apr-2013

05:31

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

375,080

02-Apr-2013

05:21

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

379,176

02-Apr-2013

05:21

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

379,176

02-Apr-2013

05:21

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

370,984

02-Apr-2013

05:21

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

375,080

02-Apr-2013

05:21

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

383,272

02-Apr-2013

05:21

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

395,560

02-Apr-2013

05:30

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

375,080

02-Apr-2013

05:32

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

379,176

02-Apr-2013

05:31

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

387,368

02-Apr-2013

05:24

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

375,080

02-Apr-2013

05:21

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

375,080

02-Apr-2013

05:29

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

375,080

02-Apr-2013

05:21

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

379,176

02-Apr-2013

05:30

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

379,176

02-Apr-2013

05:21

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

379,176

02-Apr-2013

05:21

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

395,560

02-Apr-2013

05:32

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

375,080

02-Apr-2013

05:26

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

416,040

02-Apr-2013

05:29

x86

Not applicable

Axsetupsp.resources.dll

6.2.147.8303

370,984

02-Apr-2013

05:30

x86

Not applicable

Microsoft Dynamics AX for Retail 2012 R1

File name

File version

File size

Date

Time

Platform

Service branch

Aximpactanalysis.exe

Not applicable

60,280

22-May-2012

19:06

x86

Not applicable

Axupdate.exe

Not applicable

60,264

22-May-2012

19:06

x86

Not applicable

Clientoba32.msp

Not applicable

31,145,984

22-Mar-2013

19:24

Not applicable

Not applicable

Clientoba64.msp

Not applicable

31,363,072

22-Mar-2013

19:24

Not applicable

Not applicable

Components32.msp

Not applicable

24,805,376

22-Mar-2013

19:23

Not applicable

Not applicable

Components64.msp

Not applicable

42,381,312

22-Mar-2013

19:23

Not applicable

Not applicable

Helpserver64.msp

Not applicable

929,792

22-Mar-2013

19:24

Not applicable

Not applicable

Objectserver32.msp

Not applicable

14,114,816

22-Mar-2013

19:24

Not applicable

Not applicable

Objectserver64.msp

Not applicable

16,076,800

22-Mar-2013

19:24

Not applicable

Not applicable

Retaildatabaseutility.msp

Not applicable

491,520

22-Mar-2013

19:24

Not applicable

Not applicable

Retailheadquarters32.msp

Not applicable

782,336

22-Mar-2013

19:24

Not applicable

Not applicable

Retailheadquarters64.msp

Not applicable

782,336

22-Mar-2013

19:24

Not applicable

Not applicable

Retailpos.msp

Not applicable

3,653,632

22-Mar-2013

19:24

Not applicable

Not applicable

Retailposplugins.msp

Not applicable

421,888

22-Mar-2013

19:24

Not applicable

RETAILPOSP

Retailstoreconnect32.msp

Not applicable

450,560

22-Mar-2013

19:24

Not applicable

Not applicable

Retailstoreconnect64.msp

Not applicable

450,560

22-Mar-2013

19:24

Not applicable

Not applicable

Retailtransactionservice.msp

Not applicable

122,880

22-Mar-2013

19:24

Not applicable

Not applicable

Setupsupport32.msp

Not applicable

11,935,744

22-Mar-2013

19:23

Not applicable

Not applicable

Setupsupport64.msp

Not applicable

19,234,816

22-Mar-2013

19:24

Not applicable

Not applicable

Traceparser.msp

Not applicable

438,272

22-Mar-2013

19:24

Not applicable

Not applicable

Axsetupsp.exe

6.0.1108.4109

1,390,872

12-Mar-2013

04:27

x86

Not applicable

Axutillib.dll

6.0.1108.806

821,480

22-May-2012

19:06

x86

Not applicable

Microsoft.dynamics.servicing.operations.dll

6.0.888.436

35,752

22-May-2012

19:06

x86

Not applicable

Axsetupsp.resources.dll

6.0.947.491

382,848

22-May-2012

19:06

x86

Not applicable

Axsetupsp.resources.dll

6.0.947.491

370,560

22-May-2012

19:06

x86

Not applicable

Axsetupsp.resources.dll

6.0.947.491

374,656

22-May-2012

19:06

x86

Not applicable

Axsetupsp.resources.dll

6.0.947.491

374,656

22-May-2012

19:06

x86

Not applicable

Axsetupsp.resources.dll

6.0.947.491

370,560

22-May-2012

19:06

x86

Not applicable

Axsetupsp.resources.dll

6.0.947.491

378,752

22-May-2012

19:06

x86

Not applicable

Axsetupsp.resources.dll

6.0.947.491

370,560

22-May-2012

19:06

x86

Not applicable

Axsetupsp.resources.dll

6.0.947.491

374,656

22-May-2012

19:06

x86

Not applicable

Axsetupsp.resources.dll

6.0.947.491

370,560

22-May-2012

19:06

x86

Not applicable

Axsetupsp.resources.dll

6.0.947.491

374,656

22-May-2012

19:06

x86

Not applicable

Axsetupsp.resources.dll

6.0.947.491

370,560

22-May-2012

19:06

x86

Not applicable

Axsetupsp.resources.dll

6.0.947.491

407,424

22-May-2012

19:06

x86

Not applicable


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×