Showing posts with label AX 2012. Show all posts
Showing posts with label AX 2012. Show all posts

Thursday, 17 July 2014

Dynamics AX 2012 R3 Demo database restore/ Contoso DB restore in Dynamics AX 2012 R3


1)      Download demo data from partner source
2)      Extract It,  at some location let’s assume our path to extract it is C:\R3DemoData
3)      As It will get extracted it will created a subfolder, under directory which is specified in step#2 i.e. C:\R3DemoData \DynamicsAXR3DemoData\
It will take almost 15 GB to expand/ extract
4)      Download Test Data transfer Tool from information source; here goes the path for it.
5)      Install this tool i.e. Test Data transfer Tool
6)      Open Dynamics AX and Press Ctrl+D to Open AOT. Remember if you do not have license file you would not be able to open AOT. It’s must to load license file and sync DB, before you can access AOT.
7)      Import an XPO File, named as MetadataXMLGenerator.xpo
This file can be found at the installation location of Test Data transfer Tool. Commonly under normal circumstances it would be available at following path
C:\Program Files (x86)\Microsoft Dynamics AX 2012 Test Data Transfer Tool (Beta)
8)      After you import the XPO, go to Jobs, you will see a job created, in the AOT. The name of job will be MetadataXMLGenrator. Run this job and wait until you get an info message like this
“Metadata xml file is created and here is full path to filec:\UsersSMCSER\AppData\Local\Temp\MetaData.xml”

Copy the whole message of infolog and paste it somewhere in notepad etc. It’s important
9)      Stop Dynamics AOS Service.
10)   Copy a file on following path
File Name: MetaData.xml
File from: path mentioned in step#8
File to: Test Data transfer Tool installation path\List
Typically as C:\Program Files (x86)\Microsoft Dynamics AX 2012 Test Data Transfer Tool (Beta)\[Lists]
11)   Open CMD, and Run as Administrator
12)   Run the following command
DP.exe IMPORT “PATH  OF EXTRATCED DB WHICH IS DISCUSSED IN STEP 2 AND 3. USE PATH OF STEP 3; SEE EXAMPLE BELOW” MicrosoftDynamicsAx
DP.exe IMPORT “C:\R3DemoData \DynamicsAXR3DemoData\” MicrosoftDynamicsAx

Note: if you are getting connection error for database, try command as under
dp.exe import C:\R3DemoData \DynamicsAXR3DemoData\ MicrosoftDynamicsAX
 
13)   That’s all, it may ask you some option, as Y/Y and n/N. and it will keep on showing you status that how many tables are remaining and how many got error during import, as shown below. At this moment you may have rest or coffee until it’s done :)

               

Wednesday, 21 May 2014

Language specific versions of a report


In Dynamics ax most of the text comes via labels. For understanding of non-technical person Labels are code like @SYS68462, and each code can refer to some text like as under:

Label [Saved in ax]
language
Text [Displayed on report]
@SYS68462
En-US (English US)
Discount
@SYS68462
ar (Arabic)
خصم

To overcome geographical cultural and language challenges, Microsoft Dynamics AX supports labels, i.e. by using on code/label, information may be conveyed in any language.

Normally:
Whenever a report is opened, at run-time labels are converted to some language. In other words labels are resolved at runtime so this run-time conversion takes time, which may make report slow.

Alternatively:
There is something called, language specific versions of the reports, is available in Microsoft Dynamics AX.  In these kin of reports labels are not resolved at runtime. Instated labels are resolved at time of deployment only. That means, system do not resolves the labels into text at run time, which makes report execution faster. A language-specific version of a report is designed to render quickly.
(For Developers: if you deploy a report and later change a label, the updated label is not displayed on the report. In this scenario, you must redeploy the report to view the updated label.)

 What we need to do to get language specific reports?

Go to File >> Tools >>Business Intelligence (BI) Tools >> Report Deployment Settings



 a screen will appear as under:


In order to deploy any report Language specific version do following

·         Click New
·         Select Report Name
·         Select Report Design Name
·         Mark the ‘Use static report design’ check box
·         Re-deploy/deploy the report using Command or AOT.

Monday, 15 July 2013

APPLICATION OBJECT SERVER (AOS) TOPOLOGIES


Microsft Dynamics AX consists of two major parts.
1)  AOS 
2) Client. 

AOS stands for Application object Server

Usually, for a typical and simplest installtion of AX, one instance of AOS is installed and N number of clients are installed. Here N can be any number of clients. For each user/ computer one instance of client is installed. All clients connect to same AOS Server.


An Application Object Server (AOS) instance is a core component of your Microsoft Dynamics AX installation and is installed by using Setup. An AOS instance enforces security, manages connections between clients and the database, and provides the foundation where Microsoft Dynamics AX business
logic runs. Thus, installtion of AOS becomes most vital. 

Apart from topology as shown in image 1, above, there are two more suportted topolgies for installation of AOS. The topics in this section describe the various roles in which AOS can function. i.e. AOS Installation topologies. The other two topoligies are as under:
1)      AOS clusters without a dedicated load balancer
2)      AOS clusters with a dedicated load balancer


Lets talk about both of these how these work, practically and benefit/ loss of each toplogy.


1)      AOS CLUSTERS WITHOUT A DEDICATED LOAD BALANCER:



In this topology each AOS in the cluster acts independently. Each AOS has to be provided in the client configuration file for the client to connect. Based on a list of provided AOS servers in the client configuration file, the client will attempt to access each server in the order listed to find an available server. If a server's workload has reached its maximum level, then the client will simply attempt to connect to the next AOS.

·     When a Microsoft Dynamics AX client starts, the client reads the list of AOS instances that is specified in the Microsoft Dynamics AX 2012 Configuration utility. The client initiates a handshake with the first AOS instance in the list. If the first AOS instance does not respond, the client initiates a handshake with the next AOS instance in the list. The client continues in this manner until the handshake occurs.
·         The AOS instance that received the client request queries the database and all active AOS instances in the cluster. The AOS instance returns to the client a list of all active AOS instances in the cluster, sorted by workload. The server that has the smallest workload is at the top of the list. The workload is based on the number of connected clients, divided by the maximum number of clients that are allowed on the server.
·         The client attempts to connect to each AOS instance in the sorted list until a successful connection is established. The client then uses the AOS instance that it connected to for the whole session.


1)      AOS CLUSTERS WITH A DEDICATED LOAD BALANCER:  



Microsoft Dynamics AX provides the option to load balance two or more AOS's together. This is similar to how a web farm works for a SharePoint site. Alternatively, you may opt to use hardware or another software solution to load balance AOS access. It is recommended to have one AOS for no more than 50-60 users. In a load balanced cluster, one AOS is a dedicated load balancer, delegating client connections to the appropriate AOS. It is not directly used either for interactive purposes or for processing application code. Once a client is connected to the load balancer AOS, it will then determine which AOS it should connect to. If an AOS goes down, the load balancer AOS will automatically re-route clients to an active and available AOS without having to make any modifications to client configurations. Also, as a company grows and more users are needed, it is as simple as installing a new AOS and connecting it to the load balancer.

As previously mentioned, to set up load balancing, we must set up one AOS as the load balancer. Afterwards, each additional AOS in the load-balanced cluster will automatically listen for client connection requests from the Load Balancer AOS.
However, in order for an AOS to be a load balancer, it must first satisfy the
following criteria:
• Cannot be a Batch Server
• Must be an AOS that is active




·         When a Microsoft Dynamics AX client starts, the client reads the list of active AOS instances that is specified in the Microsoft Dynamics AX 2012 Configuration utility. The client initiates a handshake with the first AOS instance in the list. In this scenario, the administrator has configured the first AOS instance as a dedicated load balancer.
·         The load balancing AOS instance that received the client request queries the database and all active AOS instances in the cluster. The AOS instance returns to the client a list of all active AOS instances in the cluster, sorted by workload. The server that has the smallest workload is at the top of the list. The workload is based on the number of connected clients, divided by the maximum number of clients that are allowed on the server.
·         The client attempts to connect to each AOS instance in the sorted list until a successful connection is established. The client then uses the AOS instance that it connected to for the whole session.
·         An AOS instance that is configured as a load balancer does not accept any client connections as either an application server or a batch server. This AOS instance functions only as a load balancer.
·         A dedicated load balancer can be used only for remote procedure call (RPC) connections. To balance the load of connections for Application Integration Framework (AIF) and services, you must use Microsoft Network Load Balancing (NLB).
·         An AOS instance that is configured as a load balancer does not require an AOS license, because the server does not provide any application services to the clients.
·         If you configure an AOS instance as a dedicated load balancer, you do not have to update client configurations when AOS instances are added to or removed from the cluster.
·         A dedicated load balancer has lower hardware requirements than an AOS instance that functions as an application server, because the load balancer does not process application requests or business logic.
·         You can configure multiple AOS instances to function as dedicated load balancers. However, you must make sure that dedicated load balancers appear first in the list of active servers in the client configuration.

 
In order to configure any AOS as load balancing follow following path in AX

Company-Legal Entity/System administration/Setup/System/Cluster Configuration