Microsoft Dynamics AX 2012 Data Migration Framework Beta 2.0 is now available on Information source
Microsoft Dynamics AX 2012 Data Migration Framework Beta 2.0 is now available on Information source.
Besides the already rich feature set, some of the key new features which have been added in this release are below -
- ODBC as Source – with this it is possible to import data using ODBC.
- AX as Source – It supports export/import , copy company for Data migration Framework entities.
- New entity types – Direct Table and Composite Entity.
- Parallel execution support from Staging to Target.
- Service Interface – DMF can be executed by external applications
- Error handling enhancements – skipping error rows, and detailed logs.
- Number sequence support.
- Removed requirement to install SSIS on AOS .
- SQL 2012 support
I will add details on the above feature set soon.
Comments
Anonymous
October 22, 2012
Hi Mudit,Thanks for the info, appreciate your valuable effort.I wanted to check if the DMF now supports SQL 2012 or not?.Anonymous
October 22, 2012
Thanks! Yes SQL 2012 support is added in this version.Anonymous
October 23, 2012
Hi Mudit,I’m getting “One or more conflicting model elements already exists in an installed model.” While importing model(beta 2)?ThanksAnonymous
October 23, 2012
Hi SriniCan you please use /conflict:Push option with axutil? We have moved DMF from USR to FPK layer. Looks like you are installing on feature pack , we are planning to have different model files per Ax version , at the mopment the above workarround would move conflicted objects to patch layerAnonymous
October 23, 2012
Thanks for the quick reply. Now getting "The model contains a customization of a configuration key. the model cannot be imported because you can overlayer a configuration key from the patching layer only".Anonymous
October 23, 2012
Hi Srini,we faced similar issues. I had to delete the configuration key, do a Axutil delete /model:DMF, and recreate all SQL Tables to get it running.@Mudit: thx for the update. the error handling is much better!looking forward to the documentation. I am eager to knowhow to " export/import , copy company for Data migration Framework entities" what to do with the new entity types how to use ODBC as Source !Anonymous
October 23, 2012
Where does it state that SQL 2012 is supported?Anonymous
October 23, 2012
Hi DerekYes i can confirm SQL 2012 is supported, once you install you will notice that as it would explicitly ask for SQL 2008 or SQL 2012.Anonymous
October 31, 2012
Hi Iam getting this error while installing a Data Migration Framework Beta in shell "The pipeline has been stopped."Anonymous
November 01, 2012
Hi Hari, you need to use the /conflict:Push option with axutil or -conflict push with powershell as described above by Mudit.Anonymous
November 01, 2012
Hi,During the installation process, I got the "Conflicting issue" as almost everybody, issue which can be solved using the workaround /conflict:PushHowever, I'm noticing in the installed models window 2 lines concerning DMF:FPP Data Migration Frame (Conflict 1) 1.0.0.0 FPK Data Migration Framework 1.0.0.5Please advice?Anonymous
November 01, 2012
Hi,when I install the DMF Service on a standalone SQL Server 2012 with SSIS installed (not VPC image), i'll get at least the error message "There is a problem with this installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor."So, in this situation what is to do??Anonymous
November 02, 2012
Hi AdilThe conflicted objects are related to Menu,etc. As i said in previous post we would be shipping multiple models with different versions of Ax, so that issue would be resolved then.Anonymous
November 02, 2012
The comment has been removedAnonymous
November 05, 2012
Hi,I'm getting the following error when trying to preview my source file (demo files):"DMF service is unavailable. Please contact the system administrator."However, my DMF service is running correctly on the SQL Server side ...Am I missing something?Thanks for your helpAnonymous
November 05, 2012
The comment has been removedAnonymous
November 05, 2012
Hello,The CIL compilation is showing these errors:Finished pass 1 at 06/11/2012 10:16:41Error when loading the method. Type: CustomerTransaction_CustSettlementLine, Method: newSystem.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.Dynamics.Ax.Xpp.ILGenerator.BuildConstructor(TypeBuilder typeBuilder, XmlNode methodNode) at Microsoft.Dynamics.Ax.Xpp.ILGenerator.BuildMethod(TypeBuilder typeBuilder, XmlNode methodNode) at Microsoft.Dynamics.Ax.Xpp.ILGenerator.LoadMethods(XmlNode classNode, TypeBuilder typeBuilder) at Microsoft.Dynamics.Ax.Xpp.ILGenerator.GenerateXppModule()... the same withError when loading the method. Type: CustomerTransaction_CustSettlement, Method: newError when loading the method. Type: CustomerTransaction_CustTransOpenLine, Method: newError when loading the method. Type: CustomerTransaction_CustTransOpen, Method: newError when loading the method. Type: CustomerTransaction_CustTrans, Method: newError when loading the method. Type: CustomerTransaction, Method: newErrors: 6Warnings: 0Anonymous
November 05, 2012
Hi Steve,This is an error regarding to Public Sector. The DMF axmodel overwrites the macro "DataContainerTypes". Just compare the macro with fpk and fpp layer and take the following code into var or usr layer://<PubSect>#AxdCustomerTransactionDCT#AxdAdvancedLedgerEntryDCT//</PubSect>Just compile and generate CIL - it should work.Anonymous
November 07, 2012
Yes you are right, also after bringing the macro to upper layer, right click on each object thatthe error is showing and compile them individually, and also delete the CIL failed log files present in C:Program FilesMicrosoft Dynamics AX60ServerMicrosoftDynamicsAX1binXppIL following path and do full CIL, this has to workThanks.Anonymous
November 08, 2012
The comment has been removedAnonymous
November 08, 2012
Hi Christian,This error might arise due to improper database synchronization, re synchronize the database from System Administration->Database->Sql Administration after synchronizing close and open the client and then try. and there is a possibility that if the database synchronization is not done after deleting the old modelfile and befor importing the new model file this sought of errors will arise.Thanks.Anonymous
November 14, 2012
Hi All,Has anyone explored on creating Table Entity/Composite Entitys's with DMF 2.0, n also like to know how ti import data with ODBC as a source.Thanks.Anonymous
November 15, 2012
First of all we are very pleased with the new Data Migration Framework Beta 2.0. We see a lot of opportunities to use this tool in the future.A lot of our customers in the Food Industry work with batch numbers (inventBatchId) and pallet-ID’s (wMSPalletID) in order to store and track & trace their inventory. We therefore would like to have the possibility to migrate an inventory file were batch numbers and pallet-ID’s are included, and subsequently generated automatically in AX 2012 if not already present.For batch numbers we would like to have the opportunity to define the production date, shelf advice date, best before date and expiration date in the inventory file. We would also like to have the possibility to leave these fields blank, in that case AX 2012 should take the transaction date as the production date and calculate the other dates with the setup of the item on the item card. For pallet-ID’s we would like to have the opportunity to define the pallet-ID number and pallet type.For both batch numbers and pallet-ID’s we would like to generate numbers automatically if they are not defined.My collegue Ernest Wensink has already spoken with Mudit Mittal (solution architect) regarding this topic on the Dynamics AX Technical conference 2012, and he told him to add these extra fields.Anonymous
November 20, 2012
Hi,Any clue if we can import dimension now, like color , size and configuration?RegardsAnonymous
November 22, 2012
Hi,Hoping someone might be able to help. I have a test instance of AX 2012 (kernel 6.0.1108.670, application 6.0.1108.670, solution 6.0.1108.670). I am trying to install DMF beta 2 and successfully used the /conflict:Push option with axutil to import the axmodel file.Everything completed successfully in the upgrade checklist until attempting the Compile into .NET Framework CIL which failed with 6 errors. The Compiler output error description was the same for each error being: "CIL generation: Object reference not set to an instance of an object"Path = XppILMethod/Property name = XppILDiagnositc ID = Err:351Infolog returned the error message "The CIL generator found errors and could not save the new assembly"Any assistance would be most appreciated.Anonymous
November 26, 2012
When i press the button "Preview Source File " i get this error: Could not create object CLRObjectAny idea?ThanksAnonymous
November 26, 2012
Hi,In another ambient, when i press the button "Preview Source File " i get this error: Could not load file or assembly 'Microsoft.SqlServer.DTSRuntimeWrap, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.I have DMF beta 2Any idea?ThanksAnonymous
November 28, 2012
Hi Oscar,In the DMF module got setup->Data Migration Framework parameters-> and select a directory on which the dmf service installed or the directory that has service access and try again this should workThanksAnonymous
November 28, 2012
Hi Oscar,The Assembly missing error might be due to improper installation of the .exe setup that you installed for DMF 2.0 and also there is a possibilty that if you already installed DMF Previous Version, you should Uninstall the previous DMF software and then install DMF 2.0 .exe setup.Anonymous
November 28, 2012
Hi John ChristianAustralia,This is an error regarding to Public Sector. The DMF axmodel overwrites the macro "DataContainerTypes". Just compare the macro with fpk and fpp layer and take the following code into var or usr layer://<PubSect>#AxdCustomerTransactionDCT#AxdAdvancedLedgerEntryDCT//</PubSect>after bringing the macro to upper layer, right click on each object thatthe error is showing and compile them individually, and also delete the CIL failed log files present in C:Program FilesMicrosoft Dynamics AX60ServerMicrosoftDynamicsAX1binXppIL following pathJust compile and generate Full CIL - it should work.Anonymous
December 09, 2012
What are the benefits, if I use DMF instead of Excel add-ins??Anonymous
December 16, 2012
Am trying to import items using the new tool and using odbc/sql source tableWould be great if we could start with a working example source table record - nightmare trying to create one with valid data items that workAnonymous
December 21, 2012
I have the same issue as JohnChristianAustralia and have not been able to resolve it with any of the tips. Has any one experienced and resolved this issue?Anonymous
December 31, 2012
The comment has been removedAnonymous
January 30, 2013
The comment has been removedAnonymous
February 19, 2013
We have installed DMF.DMF was working fine,CIL generation is also done successful.Now it started throughing error with creditcardnumber table,were that table is changed into del_creditcardtable.please suggest us any problem related DMF tool version related to AX2012 R2.Anonymous
February 20, 2013
Hi all, excellent blogging! I have the same problem as John ChristianAustralia. I am new to Dynamics AX 2012 R2. Could someone help explain HariKiran Varre's recommendation to compare the macro fpk to fpp layer? What I tried was to remove the public sector key as this client doesn't need this configuration. That didn't help.Anonymous
February 20, 2013
I should mention that I did run a FULL CIL compile.Anonymous
February 22, 2013
Hi all, I am trying to allocate path for Data Migration Frame work in parameters setting but i was stopped with the following error 's.->Assembly containing type Microsoft.Dynamics.AX.DMF.DriverHelper.DMFOdbcDriver is not referenced.->Object 'CLRObject' could not be createdcould some one help me in solving this,Thanks in advanceAnonymous
February 25, 2013
The comment has been removedAnonymous
February 25, 2013
Regarding DMF Beta 2.0 compatibility with AX R2. DMF as a framework works with all versions of AX 2012. However the model file for DMf was released before R2, so you would see overlayering and entity schema issues. There are ways to workaround those issues, however we are working on next release which will have official model for DMF R2.Anonymous
February 26, 2013
When using an ODBC data source (sql 2012), all of the source columns are listed as type "string" and I cannot map any price/cost fields.Anonymous
February 27, 2013
Hi everyone.I'm installing DMF on a Windows Server 2008 R2 Standard Service Pack 1 and using Dynamics AX 2012 R2 and DMF Beta 2.After installing, and restarting the service, and the AOS, the client isn't compiling. The screen freezes showing the compilation options before I even try to tell it to Compile and Sinchronize.I did whats posted everywhere else, verified the service is running, and also that the DLLs are present. I even register the DLLs again just in case and everything went normal but still I am not able to compile and screen freezes before choosing from compilation options. Any help will be so much appreciated.Anonymous
February 28, 2013
The comment has been removedAnonymous
March 04, 2013
I have same problem with Teja_M"the following error appear while setup share directory" anyone can help ?->Assembly containing type Microsoft.Dynamics.AX.DMF.DriverHelper.DMFOdbcDriver is not referenced.->Object 'CLRObject' could not be createdAnonymous
March 12, 2013
We just released the RTM version for DMF, name has been changed to Microsoft Dynamics AX 2012 Data Import/Export Framework.blogs.msdn.com/.../microsoft-dynamics-ax-2012-data-import-export-framework-old-name-data-migration-framework-is-now-available-on-information-source.aspxAnonymous
March 22, 2013
Hi Mudit,I imported the R2 model fileto one of my R2 Ax instance, but found the labels description has not come up kindly let me know how could i solve thisAnonymous
March 24, 2013
Hi Mudit,I attended your session on the Data Import/Export Framework at Convergence this year and was very impressed with the tool. I am excited to get started with the tool. I am running into a problem with the installation, during the prerequisite check:Gacutil utility four registering .NET 4.0 assembly missingI have done some web searching and one possible solution seems to be to install Visual Studio on my SQL Server, which I am not totally on board with. Any other suggestions?ThanksSteveAnonymous
March 26, 2013
Hi SteveThe VS workarround was for Beta 2.0 version, for RTM version you dont need. Please install windows 7 SDK and windows 8 SDK ( in sequence). Depending on your OS and SQL version, it needs to register using gacutil. Please share SQL version and OS details, so i can tell you exactly what is missing.Anonymous
March 26, 2013
Hi HariKiranFor label issue on R2, I tried but i am unable to repro. Could be related to your environment. Can you try cleaning the old ALD files before importing the model?Anonymous
March 27, 2013
In DMF parameters , when click validate button for the directory i have a an error like this.->Assembly containing type Microsoft.Dynamics.AX.DMF.DriverHelper.DMFOdbcDriver is not referenced.->Object 'CLRObject' could not be createdanyone knows why? Please help....Anonymous
March 31, 2013
Problem -Hi Probobab/Teja,Assembly containing type Microsoft.Dynamics.AX.DMF.DriverHelper.DMFOdbcDriver is not referenced.->Object 'CLRObject' could not be createdTested solution-I have also faced similar kind of issue. This is due to installation of DMF tool in multiple AOS scenerio in single physical server.Generally in one AOS it will run fine, and you will face issue in another AOS.You have to go to the C:Program FilesMicrosoft Dynamics AX60ServerDynamicsAXbin folder of your 2nd AOS(DMF giving error) and search for all DMF dlls; it will not be there.You have to copy from the C:Program FilesMicrosoft Dynamics AX60ServerDynamicsAXbin folder of 1st AOS(all DMF.dll files)and drop into the 2nd AOS specific folder--->AOS restart.Now it will validate the shared folder and dMF will work.Hope it solves your issue.community.dynamics.com/.../195791.aspxPrasenjitAnonymous
March 31, 2013
also pls dont forget to restart the dmf service in serverprasenjitAnonymous
March 31, 2013
also copy the dmfconfig and dmfclientconfig file from the 1st aos C:Program FilesMicrosoft Dynamics AX60ServerDynamicsAXbin folder to the 2nd one and restart AOS.Anonymous
April 01, 2013
Support for multiple AOS is there in the last release, you dont need to copy files manually. Please make sure you use the latest release.Anonymous
April 26, 2013
Hi Mudit,Gacutil utility four registering .NET 4.0 assembly missing- My OS is Windows server 2008 R2 and SQL Server is 2012.Please let me know what is the workaround for this problem.I am installing the RTM version of DMF tool in production environment.PrasenjitAnonymous
April 30, 2013
@Prasenjit - can you please confirm if you have windows SDK 7.1 installed? Also , if it is English OS?Anonymous
June 23, 2013
Hi Mudit,can you tell me any benchmark that we have for importing the product with variant using the DMF.thanks.Anonymous
August 08, 2013
I have read that this tool is the best option to copy a "template configured company" to another company. An example: I have completely configured the finance modules for one company and now I need to close this template company to 40 other companies. How can I use the DMF tool without creating custom entities for the parameter settings and other tables in each modules? Any guidance would be appreciated.ThanksAnonymous
September 26, 2013
I want to install DMF in multiple instance in ax2012 r2 is it that possible...Anonymous
March 13, 2014
Hi Mudit,I am using AX 2012 R2 CU7. During excel import , I am getting the following errorThe version of Microsoft Excel is not supported.-The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.Any suggestion.Regards,RanjanAnonymous
April 09, 2014
The comment has been removedAnonymous
June 05, 2014
The comment has been removedAnonymous
July 07, 2014
Hi Mudit,I am running AX2012 R2 CU7, and it is missing entities, I believe there should be 150 entities, however, my DMFEntity table contains only 71 records. Is there some form of regeneration that needs to take place?Thank youAnonymous
August 08, 2014
The comment has been removedAnonymous
November 30, 2014
Hi Mudit,When importing data through excel using DMF(Ax 2012 R2), i am getting below error when doing a preview file."The version of Microsoft excel is not supported".I have MS Excel 2010(32 bit installed) and I have installed 64 bit supported driver. Also created the user DSN for 32 bit as well 64 bit. Previously i was getting the same error during generate source mapping but after doing the 64 bit supported driver installation it got resolved. But now i am stuck with preview file.Please help.ThanksPradhanAnonymous
January 27, 2015
The comment has been removed