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:-
Do the following before you install the hotfix:
-
Make a backup of your existing store database.
-
In SQL Management Studio, view the current database version (DBversion) by running the follow SQL statement:
select * from POSISINFO
-
-
Do the following after you install the hotfix:
-
Start Retail Database Utility.
-
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.
-
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.