AX2012 DB restore

List of table in AX 2012 should be backuped while restoring the database

List of table in AX 2012 should be taken backup while restoring the database
Like from Production DB to UAT DB. 
Or might be Production DB to SIT DB. 

Important Table Names:
You may add more table name or drop some which are not needed. 
Might be case like ISV bottom-line or Cincom. 

For DMF setting export DMFParameters this table as well.

How to restore the DB Form Source to 

Destination in Microsoft Dynamics AX 2012 R3

Objective: Main Objective is to save the system tables/settings

Like EP, BI, SSRS, User Info and Etc…

Step 1: Open Source Environment Database via SSMS

Step 2: Create a Local folder to store the DB files

Step 3: Backup Source Environment Database

• ·         Stop AOS (Backup can also be taken without stopping the AOS)
• ·         Perform full database backup via SQL

Step 4: Backup Destination Environment Database

• ·         Stop AOS (Backup can also be taken without stopping the AOS)
• ·         Perform full database backup via SQL

Step 5: Backup System Configuration Tables in the destination environment

Select the database MicrosoftDynamicsAX

Select > Tasks > Export data

Follow this:

Select the Server Name here in our case LocalServer

 Choose Destination Database (create new database) click New>

Type database name and click OK. 

This database will contain the backup of the tables which are needed to be backed up for the destination environment.

Click OK>

Click Next>

Click Next>

Select all the tables needed> Use Page down Key from your keyboard.

Select all the system tables from the list below and then click Next>

Full list of system tables for AX2012 R3 (include or exclude user-related tables – marked as Optional – depending on whether you want to keep the user setup or not):

Click Next and Finish

Note: 11 Total may not be as per your need.

Step 6: Restore source database backup to the destination database

Database restore from a backup (WITH REPLACE)

Note: ensure data and log file names are correct.

Step 7: Import data from the new database created in Step 5

Select the database MicrosoftDynamicsAX and click Tasks > Import data

Select the Server Name as LocalServer.

Select System Parameter form the Database Drop down and click Next>

Choose destination (select destination environment database) and click Next>

Click Next>

Just Check the Database Name is correct or not.

Next>

Select the Tables from top> all will be selected automatically>

Select Edit Mappings> Check Delete option> Click Ok.

Click Next> Next> Finish!

Click Close

Step 8: Start and synchronise

·         Start the AOS

·         Open the AOT Synchronise dictionary in the destination environment.

OOriginal Post: http://msdynamicsaxtips.blogspot.ae/2013/11/list-of-table-in-ax-2012-should-be.html

Microsoft Dynamics AX 2012 Performance monitoring and Diagnostic Tools

Please find the below diagnostics tools for performance monitoring w.r.t AX 2012 and above>

1. Trace Parser (https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/perf-test/trace-parser)
2. Performance Monitor (https://technet.microsoft.com/en-us/library/cc961845.aspx)
3. AX Diagnostic Framework Tool (https://community.dynamics.com/ax/b/brandongeorge/archive/2013/01/08/microsoft-dynamics-ax-diagnostic-framework-beta)
4. Performance Analyzer for Microsoft Dynamics AX (DynamicsPerf) (https://blogs.msdn.microsoft.com/axinthefield/dynamicsperf-2-0-deployment-guide/)
5. Life Cycle Services (https://lcs.dynamics.com/Logon/Index)
6. Intelligent Data Management Framework (IDMF) (https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/lifecycle-services/ax-2012/overview-idmf)
7. System Center Operations Manager Monitoring Pack for Microsoft Dynamics AX 2012 (https://www.microsoft.com/en-in/download/details.aspx?id=26934)
8. Performance Analysis of  Logs (https://archive.codeplex.com/?p=pal )

On the SQL side, we can see

1. Activity Monitor
2. Extended Events
3. Management Data Warehouse

Windows Server Performance Tools

1. Disk Defragmentation
2. Disk Cleanup
3. Event Viewer
4. Memory Utilization
5. Performance monitor
6. Memory cleaner
7. Debugdiag
8. Windbg

Network Performance Tools

1. Packet analyzer
2. Performance monitor
3. Command Prompt
4. Firewall
5. Task Manager
6. Router & Switch
7. Network Monitoring
8. Wireshark (https://www.wireshark.org)
9. Fiddler

Original post: http://msdynamicsaxtips.blogspot.ae/2018/02/microsoft-dynamics-ax-2012-performance.html

Management reporter opens in webpage instead of Report designer

Once the Management reporter server and client is installed successfully, while we try to open Management reporter from AX you might got below errors.

Error:

Management Reporter has not yet been configured on the server. Contact your server administrator to publish the connection from within the Management Reporter Configuration Console.
                           

                                   (OR)

Management reporter opens directly in Webpage not in reporter designer

                                  (OR)

HTTP Error 503. The service is unavailable while accessing management reporter

Solution:

Open AOT>Table>go to> Ledger Parameter table Navigate to the field ManagementReporterURL and make Visible property as Yes and then save the changes as shown in the below screen shot.

URL would be like this 

mrd://?ServerConnection=http://Connectionstring/&Company=company name.

connection string= Servername:4712
company name = specify default company for the reporter if you have anything

Example: mrd://?ServerConnection=http://ax2012MRserver:4712/&Company=USMF.

Original post: http://msdynamicsaxtips.blogspot.ae/2015/07/management-reporter-has-not-yet-been.html 

INSTALLING MANAGEMENT REPORTER 2012 FOR AX2012

In this post I will go through the process of installing Management Reporter 2012 using its own Setup experience. I will also add a Data Mart for Dynamics AX 2012. You know you can install Management Reporter 2012 using Dynamics AX Setup, but you can also install it using the regular MR 2012 Setup. The Dynamics AX Setup experience is a bit easier because it hides some options which the regular installer doesn’t. Hence this little blog post.

Installing the Management Reporter Server

Start by downloading, extracting and running Management Reporter Setup.

When the binaries are installed, choose to let the Configuration Console open after pressing Finish.

In this example I will opt for only installing the Application Service and the Process Service. I could select the Dynamics AX Data Mart now, but I’ll set it up afterwards to keep this guide a bit simpler.

I don’t need the Access Database engine, so I’ll ignore this warning.

You need to define a service account for the service and I have already setup and defined an account in the Active Directory for this.

I will create a new database so I need to provide the SQL Server Instance, the name of the database, a passphrase for encrypting the content of the MR database and finally the account that will be automatically added as first admin of the Management Reporter installation.

By default, the Application Service will listen on 4712 by default. I’ll stick with the defaults for the sake of everyone’s sanity.

Grab yourself a cup of coffee and let it configure.

 When it is done, you have two running services but no configured applications yet. From File menu, choose Configure and run the Configuration wizard.

Choose the proper application, in my example the Dynamics AX 2012 Data Mart.

It will need information on how to connect to the right AOS, so provide the name and port for the AOS, and also the SQL Server instance and database name.

It also wants to know where it can put the Data Mart database. If you’re running this wizard in the context of a user that can create the necessary database artifacts you can simply let it do so using Windows authentication.

 When it is done, I recommend restarting both services from the Configuration Console.

You will notice a new task pops up in the Task List asking you to enable the integration.
Before doing so, you need to make sure the Management Reporter 2012 service account has the necessary permissions to Dynamics AX, so the recommended step is to add the service account to AX as a user with System Administrator permissions. Not only will it read out financial data, but also information about companies and users.

When clicking the “Enable Integration” you will be prompted for some credentials. If you user context has sufficient permissions to enable the integration, you can choose Use Windows authentication.

When the integration is enabled, it will immidiately start collecting data from the Dynamics AX database. The next important step is to install the client and apply the Management Reporter license. Otherwise, only two users will be able to play with the reporting.

Installing the client is super easy. The only thing you may need to know is what to put in as server connection for the client.

When you have installed the client, open the designer and open the Tools and Registration to paste in your license key.

Original post from: https://yetanotherdynamicsaxblog.wordpress.com/category/management-reporter/