Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Store databases approach or exceed the Microsoft SQL Server Express database size limitation quickly in Microsoft Dynamics AX for Retail 2012

Store databases approach or exceed the Microsoft SQL Server Express database size limitation quickly in Microsoft Dynamics AX for Retail 2012

View products that this article applies to.

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.

↑ Back to the top

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

↑ Back to the top

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.htm
In 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.

↑ Back to the top

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.
File information
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 nameFile versionFile sizeDateTimePlatformService branch
Aximpactanalysis.exeNot applicable61,13620-Nov-201217:59x86Not applicable
Axupdate.exeNot applicable61,12020-Nov-201217:59x86Not applicable
Clientoba32.mspNot applicable19,152,89602-Apr-201304:51Not applicableNot applicable
Clientoba64.mspNot applicable19,324,92802-Apr-201304:51Not applicableNot applicable
Commercedataexchangereal-timeservice.mspNot applicable49,15202-Apr-201304:51Not applicableNot applicable
Commercedataexchangesynchservice32.mspNot applicable122,88002-Apr-201304:51Not applicableNot applicable
Commercedataexchangesynchservice64.mspNot applicable122,88002-Apr-201304:51Not applicableNot applicable
Components32.mspNot applicable17,006,59202-Apr-201304:51Not applicableNot applicable
Components64.mspNot applicable34,390,01602-Apr-201304:51Not applicableNot applicable
Objectserver32.mspNot applicable6,811,64802-Apr-201304:51Not applicableNot applicable
Objectserver64.mspNot applicable14,716,92802-Apr-201304:53Not applicableNot applicable
Retaildatabaseutility.mspNot applicable524,28802-Apr-201304:51Not applicableNot applicable
Retailheadquarters32.mspNot applicable2,834,43202-Apr-201304:51Not applicableNot applicable
Retailheadquarters64.mspNot applicable2,834,43202-Apr-201304:51Not applicableNot applicable
Retailonlinechannel.mspNot applicable2,740,22402-Apr-201304:53Not applicableNot applicable
Retailpos.mspNot applicable4,358,14402-Apr-201304:53Not applicableNot applicable
Retailposplugins.mspNot applicable47,906,81602-Apr-201304:53Not applicableRETAILPOSP
Setupsupport32.mspNot applicable6,250,49602-Apr-201304:53Not applicableNot applicable
Setupsupport64.mspNot applicable13,512,70402-Apr-201304:53Not applicableNot applicable
Axsetupsp.exe6.2.139.83161,390,78420-Nov-201217:59x86Not applicable
Axutillib.dll6.2.120.0929,56002-Apr-201305:21x86Not applicable
Microsoft.dynamics.servicing.operations.dll6.2.73.830337,16801-Nov-201220:18x86Not applicable
Axsetupsp.resources.dll6.2.147.8303387,36802-Apr-201305:21x86Not applicable
Axsetupsp.resources.dll6.2.147.8303375,08002-Apr-201305:31x86Not applicable
Axsetupsp.resources.dll6.2.147.8303375,08002-Apr-201305:21x86Not applicable
Axsetupsp.resources.dll6.2.147.8303379,17602-Apr-201305:21x86Not applicable
Axsetupsp.resources.dll6.2.147.8303379,17602-Apr-201305:21x86Not applicable
Axsetupsp.resources.dll6.2.147.8303370,98402-Apr-201305:21x86Not applicable
Axsetupsp.resources.dll6.2.147.8303375,08002-Apr-201305:21x86Not applicable
Axsetupsp.resources.dll6.2.147.8303383,27202-Apr-201305:21x86Not applicable
Axsetupsp.resources.dll6.2.147.8303395,56002-Apr-201305:30x86Not applicable
Axsetupsp.resources.dll6.2.147.8303375,08002-Apr-201305:32x86Not applicable
Axsetupsp.resources.dll6.2.147.8303379,17602-Apr-201305:31x86Not applicable
Axsetupsp.resources.dll6.2.147.8303387,36802-Apr-201305:24x86Not applicable
Axsetupsp.resources.dll6.2.147.8303375,08002-Apr-201305:21x86Not applicable
Axsetupsp.resources.dll6.2.147.8303375,08002-Apr-201305:29x86Not applicable
Axsetupsp.resources.dll6.2.147.8303375,08002-Apr-201305:21x86Not applicable
Axsetupsp.resources.dll6.2.147.8303379,17602-Apr-201305:30x86Not applicable
Axsetupsp.resources.dll6.2.147.8303379,17602-Apr-201305:21x86Not applicable
Axsetupsp.resources.dll6.2.147.8303379,17602-Apr-201305:21x86Not applicable
Axsetupsp.resources.dll6.2.147.8303395,56002-Apr-201305:32x86Not applicable
Axsetupsp.resources.dll6.2.147.8303375,08002-Apr-201305:26x86Not applicable
Axsetupsp.resources.dll6.2.147.8303416,04002-Apr-201305:29x86Not applicable
Axsetupsp.resources.dll6.2.147.8303370,98402-Apr-201305:30x86Not applicable
Microsoft Dynamics AX for Retail 2012 R1
File nameFile versionFile sizeDateTimePlatformService branch
Aximpactanalysis.exeNot applicable60,28022-May-201219:06x86Not applicable
Axupdate.exeNot applicable60,26422-May-201219:06x86Not applicable
Clientoba32.mspNot applicable31,145,98422-Mar-201319:24Not applicableNot applicable
Clientoba64.mspNot applicable31,363,07222-Mar-201319:24Not applicableNot applicable
Components32.mspNot applicable24,805,37622-Mar-201319:23Not applicableNot applicable
Components64.mspNot applicable42,381,31222-Mar-201319:23Not applicableNot applicable
Helpserver64.mspNot applicable929,79222-Mar-201319:24Not applicableNot applicable
Objectserver32.mspNot applicable14,114,81622-Mar-201319:24Not applicableNot applicable
Objectserver64.mspNot applicable16,076,80022-Mar-201319:24Not applicableNot applicable
Retaildatabaseutility.mspNot applicable491,52022-Mar-201319:24Not applicableNot applicable
Retailheadquarters32.mspNot applicable782,33622-Mar-201319:24Not applicableNot applicable
Retailheadquarters64.mspNot applicable782,33622-Mar-201319:24Not applicableNot applicable
Retailpos.mspNot applicable3,653,63222-Mar-201319:24Not applicableNot applicable
Retailposplugins.mspNot applicable421,88822-Mar-201319:24Not applicableRETAILPOSP
Retailstoreconnect32.mspNot applicable450,56022-Mar-201319:24Not applicableNot applicable
Retailstoreconnect64.mspNot applicable450,56022-Mar-201319:24Not applicableNot applicable
Retailtransactionservice.mspNot applicable122,88022-Mar-201319:24Not applicableNot applicable
Setupsupport32.mspNot applicable11,935,74422-Mar-201319:23Not applicableNot applicable
Setupsupport64.mspNot applicable19,234,81622-Mar-201319:24Not applicableNot applicable
Traceparser.mspNot applicable438,27222-Mar-201319:24Not applicableNot applicable
Axsetupsp.exe6.0.1108.41091,390,87212-Mar-201304:27x86Not applicable
Axutillib.dll6.0.1108.806821,48022-May-201219:06x86Not applicable
Microsoft.dynamics.servicing.operations.dll6.0.888.43635,75222-May-201219:06x86Not applicable
Axsetupsp.resources.dll6.0.947.491382,84822-May-201219:06x86Not applicable
Axsetupsp.resources.dll6.0.947.491370,56022-May-201219:06x86Not applicable
Axsetupsp.resources.dll6.0.947.491374,65622-May-201219:06x86Not applicable
Axsetupsp.resources.dll6.0.947.491374,65622-May-201219:06x86Not applicable
Axsetupsp.resources.dll6.0.947.491370,56022-May-201219:06x86Not applicable
Axsetupsp.resources.dll6.0.947.491378,75222-May-201219:06x86Not applicable
Axsetupsp.resources.dll6.0.947.491370,56022-May-201219:06x86Not applicable
Axsetupsp.resources.dll6.0.947.491374,65622-May-201219:06x86Not applicable
Axsetupsp.resources.dll6.0.947.491370,56022-May-201219:06x86Not applicable
Axsetupsp.resources.dll6.0.947.491374,65622-May-201219:06x86Not applicable
Axsetupsp.resources.dll6.0.947.491370,56022-May-201219:06x86Not applicable
Axsetupsp.resources.dll6.0.947.491407,42422-May-201219:06x86Not applicable

↑ Back to the top

Status

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

↑ Back to the top

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.

↑ Back to the top

Keywords: kbgraphxlink, kbnoloc, kbsurveynew, kbexpertiseinter, kbexpertisebeginner, kbexpertiseadvanced, kbmbspartner, kbmbsmigrate, kb, kbhotfixserver, kbautohotfix, kbqfe, kbmbsquickpub

↑ Back to the top

Article Info
Article ID : 2831335
Revision : 3
Created on : 2/17/2017
Published on : 2/17/2017
Exists online : False
Views : 316