August 06, 2014

Dynamics AX 2012 R3 Demo Data Installation

Dynamics AX 2012 R3 Demo Data Installation

Hi Friends,

Data importing is slightly different in AX 2012 R3, in earlier version can import data through SQL but now here is something new for us. 

Before performing below operation you should have following tools/Setups with you

1. Dynamics AX 2012R3 (of course it will be there :P )

2. Demo data file (downloadable from Partner source)
DynamicsAX2012R3DemoData.exe

3. Data transfer tool (downloadable from Partner source
AX2012TestDataTransferTool.msi

Ohk, now we have all the require setups with us, so let’s start now.

Step 1. Extract demo data file, run “DynamicsAX2012R3DemoData.exe

clip_image001
In this case I extract it on C drive.


Step 2. Run “AX2012TestDataTransferTool.msi” file.

clip_image002

It will create a new folder in under following path
C:\Program Files (x86)\Microsoft Dynamics AX 2012 Test Data Transfer Tool (Beta)

clip_image004

Step 3. Import “MetaDataXMLGenerator.xpo” , it will import a new job named “MetaDataXMLGenerator” in AOT, Run this job.

clip_image006

This operation will create a XML file names “MetaData.xml” under below path
(You can directly go this folder by using “%temp%” from run)
clip_image007

7/29/2014 5:00 PM - Screen Clipping
clip_image008

Step 4. Copy this file and paste is in “[List]” folder (where Test Data Transfer Tool has been extracted). If the file already exists, then overwrite the file. In this example path will be following
“C:\AX 2012 Test Data Transfer\[Lists]”

clip_image010

Step : 5 Close all AX instances and stop the AOS services.
Now you have all data and required files with you.

Step 6. Now run command prompt as administrator
Navigate to the directory where your “AX2012TestDataTransferTool” folder exist. In this case I have “C:\AX 2012 Test Data Transfer” (just copied from program files J )
clip_image012

Now the final stunt, Run following command
DP.exe IMPORT “C:\AXR3DemoData” AX2012R3DB
Pease note: Make sure all AX instance and AOS service are stopped.
Here
Ø “DP.exe” is executable file in “AX2012TestDataTransferTool” folder
Ø “C:\AX2012R3DemoData” is your demo data folder path
Ø “AX2012R3DB” is your AX database name
clip_image014
System will ask to your acceptance to import data, simply press “y/Y”


Note: Some time system will show below error

“Unhandled Exception: System.UnauthorizedAccessException: Access to the path ‘C:\Program Files (x86)\Microsoft Dynamics AX 2012 Test Data Transfer Tool (Beta)\DP Log.xml’ is denied.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, I
nt32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions o
ptions, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolea
n useLongPath, Boolean checkHost)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access,
FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean
bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access,
FileShare share, Int32 bufferSize, Boolean useAsync)
at System.Xml.XmlWriterSettings.CreateWriter(String outputFileName)
at System.Xml.Linq.XDocument.Save(String fileName, SaveOptions options)
at DP.Program.Execute(String currentDirectory, DataportDirection direction, S
tring directory, String database, String server, DataportAction action) in e:\bt
\110700\Source\DataPort\DP\Program.cs:line 182
at DP.Program.Main(String[] args) in e:\bt\110700\Source\DataPort\DP\Program.
cs:line 82


If you are facing the same error than try to run following command (Its same command as above without “ ”)
DP.exe IMPORT C:\AXR3DemoData AX2012R3DB
Now it will work J
As next, Below window will open
clip_image017
Here you done your part, now wait to complete this operation and open your AX client.


-Harry

1 comment:

  1. If images are not visible , Pl. click on the image and it will open in new window with better resolution.

    ReplyDelete

Thanks