Jul 14, 2016

Setting Hyper-v for AX7 AX7


Prerequisites :

1.Drive size : 150GB
2.RAM: 12GB(16GB recommended
3.OS: windows 8/8.1/10(PRO) or windows server 2012/2012R2
4.Office365 account

 Step 1: Run application, that extracts remaining zips, constitute to 113GB

Step 2:
1) Enable Hyper-v .
2) Search "windows Features" enable Hyper-V.
3) For Server Click on "Add roles and Features"



Step 3: Search "Hyper-V management"
Create Virtual switch network




Step 4:Create New virtual Machine





RAM size should be min 8GB, So better to enter 8000MB


 Provide the location of extracted (VHD file location)

Step 5: After successful creation of VM,

Search Hyper-V
Click connect and start
password:pass@word1

Step 6: Click on the below Icon to register User against 'Admin'

Step 7: Enter your Office 365 account ID and wait for confirmation dialogue
 
Step 8: Enter below link in browser in hyper-V and login with office365 account
https://usnconeboxax1aos.cloud.onebox.dynamics.com
 

 

Jan 29, 2016

The version of MS Excel is not supported - DMF Error

The version of MS Excel is not supported ............ DMF Error on validation.



By default we may not have 64-bit Microsoft Excel Driver installed on the local machine which causes this issue even though you may have 32-bit Microsoft Excel Driver in place. 

To resolve this we have to  install 64-bit Microsoft Excel Driver on 64-bit machine (OS) with 'Microsoft Access Database Engine 2010 Redistributable' (AccessDatabaseEngine_x64.msi) by using "/passive" argument.
 

DMF error " Exception from HRESULT: 0xC0048021 "

When I try to import the excel data by using DMF ..on "Preview source file" button click got the below error .

Exception from HRESULT: 0xC0048021  at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFEntity.ShowPreview(Boolean isComposite)  at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelperService.Service.ServiceHelper.ShowPreview(DMFEntity entity)
 
To resolve this we need to modify DMFConfig file like below ...
 
Go to " C:\Program Files\Microsoft Dynamics AX\60\DataImportExportFramework"
 
Replace the values of
 
PipelineComponentInfo_Multicast
as {33D831DE-5DCF-48F0-B431-4D327B9E785D}
 
PipelineComponentInfo_ExcelSource
as  {9F5C585F-2F02-4622-B273-F75D52419D4A}
 
PipelineComponentInfo_ExcelDestination
as  {90E2E609-1207-4CB0-A8CE-CC7B8CFE2510}
 
 
 and save the file. ... :)