This article applies to Microsoft Dynamics AX for all regions.
Symptoms
Consider the following scenario in Microsoft Dynamics AX 2012 Retail:
-
One computer has the head-office side Store Connect component installed.
-
Another computer has the store side Store Connect component installed.
-
Different date formats are set on the two computers.
-
You run a job to transfer some data from the head-office side to the store side.
In this scenario, the job fails. Additionally, you receive the following error message:
System.FormatException: String was not recognized as a valid DateTime.
Resolution
To resolve this problem, you must follow these steps after you apply this hotfix:Note You must follow these steps for each store that uses a date format which differs from the date format on the head-office side.
-
On the store side, check the locale settings for the store, and then locate the ISO code for the locale according to the List of ISO country and region codes page.Note You do not have to update the store instance of Store Connect.
-
On the head-office side, set up a new instance of Store Connect.
-
For the new instance, add the ForceLocale parameter to the SCAXRequestHandler node in the "Store Connect configuration" file (DBServer.exe.config) as follows:
<?xml version="1.0" encoding="utf-8" ?><configuration> <!-- NOTE: "configSections" must be the first child of "configuration". Do not move around. --> <configSections>... <!-- Config settings for AX/SQL request handler bundled with this version of Store Connect. Hot modification is supported: they can be changed and will take effect without restarting Store Connect service --> <SCAXRequestHandler ReadByJoinThreshold="100" ForceLocale=”<ISO Code>” /> <SCSQLRequestHandler SqlCommandTimeout="1200" /></configuration>
Note The <ISO Code> placeholder represents the ISO code that you located in step 1.
-
Set up a new Store Connect profile for the new instance.
-
Set up a new AOS profile for the locale and select the Store Connect profile that was generated in step 4.
-
Start the Store Connect service for the new instance, if it is not running.
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
If you have customizations for one or more of the methods or the tables that are affected by this hotfix, you must follow these steps:
-
Review the changes that are documented in the .xpo file.
-
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 Microsoft Dynamics AX 2012 Retail installed to apply this hotfix.
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.
|
File name |
File version |
File size |
Date |
Time |
Platform |
|---|---|---|---|---|---|
|
Aximpactanalysis.exe |
Not applicable |
60,280 |
22-May-2012 |
02:09 |
x86 |
|
Axupdate.exe |
Not applicable |
60,264 |
22-May-2012 |
02:09 |
x86 |
|
Clientoba32.msp |
Not applicable |
21,237,760 |
23-Aug-2012 |
11:33 |
Not applicable |
|
Clientoba64.msp |
Not applicable |
21,237,760 |
23-Aug-2012 |
11:33 |
Not applicable |
|
Components32.msp |
Not applicable |
18,477,056 |
23-Aug-2012 |
11:33 |
Not applicable |
|
Components64.msp |
Not applicable |
35,733,504 |
23-Aug-2012 |
11:33 |
Not applicable |
|
Helpserver64.msp |
Not applicable |
901,120 |
23-Aug-2012 |
11:33 |
Not applicable |
|
Objectserver32.msp |
Not applicable |
7,286,784 |
23-Aug-2012 |
11:33 |
Not applicable |
|
Objectserver64.msp |
Not applicable |
9,248,768 |
23-Aug-2012 |
11:33 |
Not applicable |
|
Retaildatabaseutility.msp |
Not applicable |
421,888 |
23-Aug-2012 |
11:33 |
Not applicable |
|
Retailheadquarters32.msp |
Not applicable |
806,912 |
23-Aug-2012 |
11:33 |
Not applicable |
|
Retailheadquarters64.msp |
Not applicable |
806,912 |
23-Aug-2012 |
11:33 |
Not applicable |
|
Retailpos.msp |
Not applicable |
2,994,176 |
23-Aug-2012 |
11:33 |
Not applicable |
|
Retailposplugins.msp |
Not applicable |
299,008 |
23-Aug-2012 |
11:33 |
Not applicable |
|
Retailstoreconnect32.msp |
Not applicable |
450,560 |
23-Aug-2012 |
11:33 |
Not applicable |
|
Retailstoreconnect64.msp |
Not applicable |
450,560 |
23-Aug-2012 |
11:33 |
Not applicable |
|
Retailtransactionservice.msp |
Not applicable |
122,880 |
23-Aug-2012 |
11:33 |
Not applicable |
|
Setupsupport32.msp |
Not applicable |
11,804,672 |
23-Aug-2012 |
11:33 |
Not applicable |
|
Setupsupport64.msp |
Not applicable |
19,091,456 |
23-Aug-2012 |
11:33 |
Not applicable |
|
Traceparser.msp |
Not applicable |
442,368 |
23-Aug-2012 |
11:33 |
Not applicable |
|
Axsetupsp.exe |
6.0.1108.1871 |
1,378,528 |
15-Aug-2012 |
11:19 |
x86 |
|
Axutillib.dll |
6.0.1108.806 |
821,480 |
06-Aug-2012 |
13:07 |
x86 |
|
Microsoft.dynamics.servicing.operations.dll |
6.0.888.436 |
35,752 |
22-May-2012 |
02:09 |
x86 |
|
Axsetupsp.resources.dll |
6.0.947.491 |
382,848 |
22-May-2012 |
02:09 |
x86 |
|
Axsetupsp.resources.dll |
6.0.947.491 |
370,560 |
22-May-2012 |
02:09 |
x86 |
|
Axsetupsp.resources.dll |
6.0.947.491 |
374,656 |
22-May-2012 |
02:09 |
x86 |
|
Axsetupsp.resources.dll |
6.0.947.491 |
374,656 |
22-May-2012 |
02:09 |
x86 |
|
Axsetupsp.resources.dll |
6.0.947.491 |
370,560 |
22-May-2012 |
02:09 |
x86 |
|
Axsetupsp.resources.dll |
6.0.947.491 |
378,752 |
22-May-2012 |
02:09 |
x86 |
|
Axsetupsp.resources.dll |
6.0.947.491 |
370,560 |
22-May-2012 |
02:09 |
x86 |
|
Axsetupsp.resources.dll |
6.0.947.491 |
374,656 |
22-May-2012 |
02:09 |
x86 |
|
Axsetupsp.resources.dll |
6.0.947.491 |
370,560 |
22-May-2012 |
02:09 |
x86 |
|
Axsetupsp.resources.dll |
6.0.947.491 |
374,656 |
22-May-2012 |
02:09 |
x86 |
|
Axsetupsp.resources.dll |
6.0.947.491 |
370,560 |
22-May-2012 |
02:09 |
x86 |
|
Axsetupsp.resources.dll |
6.0.947.491 |
407,424 |
22-May-2012 |
02:09 |
x86 |
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.
