This article applies to Microsoft Dynamics AX 2012 R2 for all regions.
Symptoms
Consider the following scenario:
-
You start Microsoft Excel and add the CustTable table in Microsoft Dynamics AX 2012 R2 as a data source for a workbook.
-
You bind several fields on Sheet 1 such as the following fields:
-
Currency
-
Customer account
-
Customer group
-
Name.PartyId
-
Credit limit
-
-
You create a new matrix field by using the following information:
-
Name: Total
-
Measure: Credit limit
-
-
You bind several fields on Sheet 2 such as the following fields and then close the field chooser:
-
Customer group
-
Total
-
-
You have the focus on a field that was bound on Sheet 2 and then you click the Add Row button. Only the Customer group field is displayed in the Add Row dialog box.
-
You set a value for the Customer group field in the Add Row dialog box, and then click OK.
In this scenario when you click Publish, you receive the following error message:
There are incomplete records in your worksheet. All records must contain valid keys in order for the workbook to be closed or published. Continuing will cause these incomplete records to be discarded. Do you wish to continue?
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, go to the following Microsoft website:
https://mbs.microsoft.com/support/newstart.aspxYou can also contact technical support for Microsoft Dynamics by telephone by using these links for country specific telephone numbers. To do this, go to one of the following Microsoft websites: Partners
https://mbs.microsoft.com/partnersource/supportCustomers
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
We recommend that you apply the hotfix 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 go to the article in the Microsoft Knowledge Base:893082 How to install a Microsoft Dynamics AX hotfix
Prerequisites
You must have Microsoft Dynamics AX 2012 R2 installed to apply this hotfix.
Restart requirement
You must restart the Application Object Server (AOS) service after you apply this hotfix.
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.
File name |
File version |
File size |
Date |
Time |
Platform |
---|---|---|---|---|---|
Aximpactanalysis.exe |
Not Applicable |
61,136 |
20-Nov-2012 |
14:35 |
x86 |
Axupdate.exe |
Not Applicable |
61,120 |
20-Nov-2012 |
14:35 |
x86 |
Licensetermsar.rtf |
Not Applicable |
2,173 |
20-Nov-2012 |
14:35 |
Not Applicable |
Licensetermscs.rtf |
Not Applicable |
91,247 |
20-Nov-2012 |
14:35 |
Not Applicable |
Licensetermsda.rtf |
Not Applicable |
101,181 |
20-Nov-2012 |
14:35 |
Not Applicable |
Licensetermsde.rtf |
Not Applicable |
116,642 |
20-Nov-2012 |
14:35 |
Not Applicable |
Licensetermsen.rtf |
Not Applicable |
102,374 |
20-Nov-2012 |
14:35 |
Not Applicable |
Licensetermses.rtf |
Not Applicable |
96,985 |
20-Nov-2012 |
14:35 |
Not Applicable |
Licensetermset.rtf |
Not Applicable |
102,895 |
20-Nov-2012 |
14:35 |
Not Applicable |
Licensetermsfi.rtf |
Not Applicable |
106,101 |
20-Nov-2012 |
14:35 |
Not Applicable |
Licensetermsfr.rtf |
Not Applicable |
130,011 |
20-Nov-2012 |
14:35 |
Not Applicable |
Licensetermshu.rtf |
Not Applicable |
93,010 |
20-Nov-2012 |
14:35 |
Not Applicable |
Licensetermsis.rtf |
Not Applicable |
36,458 |
20-Nov-2012 |
14:35 |
Not Applicable |
Licensetermsit.rtf |
Not Applicable |
115,086 |
20-Nov-2012 |
14:35 |
Not Applicable |
Licensetermsja.rtf |
Not Applicable |
105,917 |
20-Nov-2012 |
14:35 |
Not Applicable |
Licensetermslt.rtf |
Not Applicable |
122,674 |
20-Nov-2012 |
14:35 |
Not Applicable |
Licensetermslv.rtf |
Not Applicable |
105,401 |
20-Nov-2012 |
14:35 |
Not Applicable |
Licensetermsnb-no.rtf |
Not Applicable |
115,700 |
20-Nov-2012 |
14:35 |
Not Applicable |
Licensetermsnl.rtf |
Not Applicable |
110,040 |
20-Nov-2012 |
14:35 |
Not Applicable |
Licensetermspl.rtf |
Not Applicable |
116,322 |
20-Nov-2012 |
14:35 |
Not Applicable |
Licensetermspt-br.rtf |
Not Applicable |
101,514 |
20-Nov-2012 |
14:35 |
Not Applicable |
Licensetermsru.rtf |
Not Applicable |
148,577 |
20-Nov-2012 |
14:35 |
Not Applicable |
Licensetermssv.rtf |
Not Applicable |
115,453 |
20-Nov-2012 |
14:35 |
Not Applicable |
Licensetermsth.rtf |
Not Applicable |
153,768 |
20-Nov-2012 |
14:35 |
Not Applicable |
Licensetermszh-hans.rtf |
Not Applicable |
99,245 |
20-Nov-2012 |
14:35 |
Not Applicable |
Clientoba32.msp |
Not Applicable |
16,863,232 |
29-Jan-2013 |
23:11 |
Not Applicable |
Clientoba64.msp |
Not Applicable |
16,871,424 |
29-Jan-2013 |
23:11 |
Not Applicable |
Commercedataexchangereal-timeservice.msp |
Not Applicable |
49,152 |
29-Jan-2013 |
23:11 |
Not Applicable |
Commercedataexchangesynchservice32.msp |
Not Applicable |
122,880 |
29-Jan-2013 |
23:11 |
Not Applicable |
Commercedataexchangesynchservice64.msp |
Not Applicable |
122,880 |
29-Jan-2013 |
23:11 |
Not Applicable |
Components32.msp |
Not Applicable |
352,256 |
29-Jan-2013 |
23:11 |
Not Applicable |
Components64.msp |
Not Applicable |
352,256 |
29-Jan-2013 |
23:11 |
Not Applicable |
Objectserver32.msp |
Not Applicable |
446,464 |
29-Jan-2013 |
23:11 |
Not Applicable |
Objectserver64.msp |
Not Applicable |
6,336,512 |
29-Jan-2013 |
23:11 |
Not Applicable |
Retaildatabaseutility.msp |
Not Applicable |
516,096 |
29-Jan-2013 |
23:11 |
Not Applicable |
Retailheadquarters32.msp |
Not Applicable |
2,748,416 |
29-Jan-2013 |
23:11 |
Not Applicable |
Retailheadquarters64.msp |
Not Applicable |
2,748,416 |
29-Jan-2013 |
23:11 |
Not Applicable |
Retailonlinechannel.msp |
Not Applicable |
2,732,032 |
29-Jan-2013 |
23:11 |
Not Applicable |
Retailpos.msp |
Not Applicable |
3,747,840 |
29-Jan-2013 |
23:12 |
Not Applicable |
Retailposplugins.msp |
Not Applicable |
47,878,144 |
29-Jan-2013 |
23:12 |
Not Applicable |
Axsetupsp.exe |
6.2.139.8316 |
1,390,784 |
20-Nov-2012 |
14:35 |
x86 |
Axutillib.dll |
6.2.120.0 |
929,472 |
29-Jan-2013 |
23:20 |
x86 |
Microsoft.dynamics.servicing.operations.dll |
6.2.73.8303 |
37,168 |
02-Nov-2012 |
11:31 |
x86 |
Axsetupsp.resources.dll |
6.2.147.8303 |
387,288 |
29-Jan-2013 |
23:20 |
x86 |
Axsetupsp.resources.dll |
6.2.147.8303 |
375,000 |
29-Jan-2013 |
23:20 |
x86 |
Axsetupsp.resources.dll |
6.2.147.8303 |
375,000 |
29-Jan-2013 |
23:20 |
x86 |
Axsetupsp.resources.dll |
6.2.147.8303 |
379,096 |
29-Jan-2013 |
23:20 |
x86 |
Axsetupsp.resources.dll |
6.2.147.8303 |
379,096 |
29-Jan-2013 |
23:20 |
x86 |
Axsetupsp.resources.dll |
6.2.147.8303 |
370,904 |
29-Jan-2013 |
23:20 |
x86 |
Axsetupsp.resources.dll |
6.2.147.8303 |
375,000 |
29-Jan-2013 |
23:20 |
x86 |
Axsetupsp.resources.dll |
6.2.147.8303 |
383,192 |
29-Jan-2013 |
23:20 |
x86 |
Axsetupsp.resources.dll |
6.2.147.8303 |
395,480 |
29-Jan-2013 |
23:20 |
x86 |
Axsetupsp.resources.dll |
6.2.147.8303 |
375,000 |
29-Jan-2013 |
23:20 |
x86 |
Axsetupsp.resources.dll |
6.2.147.8303 |
379,096 |
29-Jan-2013 |
23:20 |
x86 |
Axsetupsp.resources.dll |
6.2.147.8303 |
387,288 |
29-Jan-2013 |
23:20 |
x86 |
Axsetupsp.resources.dll |
6.2.147.8303 |
375,000 |
29-Jan-2013 |
23:20 |
x86 |
Axsetupsp.resources.dll |
6.2.147.8303 |
375,000 |
29-Jan-2013 |
23:20 |
x86 |
Axsetupsp.resources.dll |
6.2.147.8303 |
375,000 |
29-Jan-2013 |
23:20 |
x86 |
Axsetupsp.resources.dll |
6.2.147.8303 |
379,096 |
29-Jan-2013 |
23:20 |
x86 |
Axsetupsp.resources.dll |
6.2.147.8303 |
379,096 |
29-Jan-2013 |
23:20 |
x86 |
Axsetupsp.resources.dll |
6.2.147.8303 |
379,096 |
29-Jan-2013 |
23:20 |
x86 |
Axsetupsp.resources.dll |
6.2.147.8303 |
395,480 |
29-Jan-2013 |
23:20 |
x86 |
Axsetupsp.resources.dll |
6.2.147.8303 |
375,000 |
29-Jan-2013 |
23:20 |
x86 |
Axsetupsp.resources.dll |
6.2.147.8303 |
415,960 |
29-Jan-2013 |
23:20 |
x86 |
Axsetupsp.resources.dll |
6.2.147.8303 |
370,904 |
29-Jan-2013 |
23:20 |
x86 |
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.