Customers upgrading from Microsoft Dynamics AX 2009 will need to activate Multisite Inventory prior to upgrading to Microsoft Dynamics AX 2012. Some customers will have already setup their system for multisite in some of their companies and will be notified during the readiness checks that multisite must be activated in their remaining companies prior to upgrading. This activation is handled by the standard Multisite Activation Wizard found under Administration - Setup - Multisite activation.
Customers upgrading from Microsoft Dynamics AX 4.0 have no option within the core product to setup multisite inventory because that feature was not introduced yet. These customers will need to specify their multisite inventory settings as part of the data upgrade checklist. The validation message for this particular section is somewhat misleading, and the current Upgrade Guide PDF file has the wrong checklist menu item name.
There are three typical validation messages that can arise due to multisite activation, and two of the messages listed here require the user to go through the Configure site structure step within the Prepare application data for preprocessing section of the checklist. However, that checklist section doesn’t get activated right away which makes it seem like the user cannot take the right action.
The following message will appear if there are any custom tables in the system which use the InventDimID extended datatype.
The resolution in this case of custom inventDimID fields is very generic and misleading. Clicking on the Details button will display a list of all the new fields and the tables that contain those fields, and would appear something like this:
The correct resolution to the issue with new custom dimensions is to inspect the dimension ID fields that are presented and determine if those records should have the InventDimID values changed so that they now include a default site. Once the decision is made for the fields, the next step is to customize the methods which list all of the InventDimID fields in the system in either a process list or an ignore list. In Microsoft Dynamics AX 4.0, the methods are found here:
In Microsoft Dynamics AX 2009, the methods are found here:
In both cases, it is fairly easy to copy existing lines from the script and then add new lines at the end using the table name and field name for the custom InventDimID fields.
The two methods and messages which require the Configure site structure step are:
Both of those validation errors recommend to the user to "Complete the Configure site structure item in the Pre-upgrade checklist." In order to get the Configure site structure option enabled so this step can be completed, the user can press the Fix button in the bottom half of the window or wait until fixing all of the other validation errors and doing the steps in the Prepare application data section.
This walkthrough continues to outline how to finish multisite activation during the upgrade process.
If you carefully read the upgrade guide all the way through before you start the upgrade process, you may notice that it says to activate multi-site in AX2009 before loading the upgrade XPO or you will experience problems running the Multi-site activation wizard. That message isn't very descriptive, and the guidance the wizard gives you isn't of much help either - you get a message saying "The Multisite Activation Wizard is not up-to-date. Please run a best practice check to identify tables and fields for which activation scripts are missing.
To fix this problem caused by the UpgradeAX5.xpo, you can simply do the following steps:
Then compile the script and re-run the wizard and resolve any other errors.
If the error still persists, then you will want to set a breakpoint in the method Classes\InventSiteActivateDimFieldsCheck\validateInventDimIdImplementation at the line in the middle that says ok=false; (line 36 in SP1 code) Then run the wizard again, and when the breakpoint hits, you can look at the variables sysDictTable and sysDictField to find out which table and fields need to be added to either the notUpdatableFields or updateableFields methods depending on if you want the inventDimID value to get the new site or not.
We are upgrading from AX 2009 TO AX 2012 R3 . I am in process of activation of multisite in source environment. when we activate multisite the wizard keeps on running almost for 5 hours and still process has not completed . I checked batch thread and system is taking long time executing the method inventSiteActivateUpdRuleInvLoc.updateInventTrans();
So I checked number of transactions in inventTrans and found it is 20,00,000
I thought because of data volume system might be taking longer time , so opened another instance and done multisite activation for another company having 1,90,000 InventTrans records . But process is still running for more than 5 hours with no progress .
I seen people experienced high amount of performance issues with this activation tool.
My server configuration has 32 GB memory and enough space . even server utilization while the process is running is not more than 3GB.
Can you please guide .
Chetan - the process of activating multisite in an AX 2009 environment is one that can certainly take a long time to process, and should be executed in a testing system first to analyze how long it will take and if there are any possible index tuning that might help speed up the process.
Without more details about particular long running queries or consolidated performance data using SQL DMV information or using the Dynamics Performance Analyzer or Trace Parser, there isn't a lot of individual guidance that we can give you.
We are upgrading from AX 2009 TO AX 2012 R3 . I am in process of activation of multisite in source environment. when we activate multisite the wizart failed:
Cannot execute the required database operation.
The SQL database has issued an error.
Object Server 01: The database reported (session 3 (Admin)): [Microsoft][SQL Native Client][SQL Server]Subquery returned more than 1 value. This is not
permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an
expression.. The SQL statement was: "
UPDATE DBO.INVENTDIM SET INVENTSITEID =
(SELECT INVENTLOCATION.INVENTSITEID FROM DBO.INVENTLOCATION INVENTLOCATION
WHERE INVENTLOCATION.DATAAREAID = N'euro' AND INVENTLOCATION.INVENTLOCATIONID = INVENTDIM.INVENTLOCATIONID)
WHERE INVENTDIM.DATAAREAID = N'euro' AND INVENTDIM.INVENTLOCATIONID !=' ' AND INVENTDIM.INVENTSITEID = ' '
AND EXISTS (SELECT 1 FROM DBO.INVENTLOCATION INVENTLOCATION
WHERE INVENTLOCATION.DATAAREAID = N'euro' AND INVENTLOCATION.INVENTLOCATIONID = INVENTDIM.INVENTLOCATIONID
Source Environment: AX2009 SP1 Rollup 8
We are upgrading from ax3sp6 towards ax2009sp1 Activation of multisite is allready running 24 hrs. How can we see how far the process is? how many steps still to come. Is there a way to speed this up.
Is it possible to run the inventUnusedDimension before we start filling in all the site's specifications to clean up the inventdims?