AX 2012 R3 CU 8 Installation Step By Step

Hello Guys..!

Here I'm sharing steps how to install Ax 2012 R3 with CU8 by using slip stream

-> I wrote about this back in April - How to Install Ax 2012 CU-8 .
http://talasilarahuldaxing.blogspot.ae/2015/01/ax-2012-r3-cu8-installation-document.html

But by using the above process there is a problem with kernel version and application version matching problem.

->So there is other process called Slip stream to install AX 2012 R3 -CU8
    
->If you have customer/partner source Id please click on below link to download installation document.

To Download Installation Document
https://onedrive.live.com/redir?resid=518402d6c1a51c90%21149

->If you don't have customer/partner source id please click below links to download CU8- Slip stream and installation document.

To Download CU-8 Slip Stream
https://onedrive.live.com/redir?resid=518402D6C1A51C90%21148

To Download Installation Document
https://onedrive.live.com/redir?resid=518402d6c1a51c90%21146




@Rahul Talasila

Export list of model elements to Excel - Ax 2012

Hello Guys..!

Here I'm sharing code for export list of model elements to excel .


Step 1: Open "Microsoft Dynamics Ax management shell" from Administrator Tools.

Step 2 : paste the below code

(Get-AXModel -Model 'VAR Model' -Details).Elements | select path, elementtype | `
Export-Csv -NoTypeInformation -Delimiter ';' c:\varmodel.csv


Note : In this example I'm exporting VAR Model.
          Go to c:\varmodel.csv


That's it


@Rahul Talasila

Import - Export Of Model Store - Ax 2012

Hello Guys...!

Here I'm sharing steps for import and export a model store in ax 2012.

Step 1 :

Make sure the client configuration, in which environment you are going import / export model store.

Example : I'm exporting my development model store . So that should be active in Ax Client configuration.

Step 2 :

stop AOS

Step 3 :

On the Start menu, point to All Programs, point to Administrative Tools, and then click Microsoft Dynamics AX Management Shell.

 At the Windows PowerShell command prompt, PS C:\>, type the following command, and then press ENTER.

For Export
-----------------------

Export-AXModelStore -File <Filename> -Details
This command exports the model store to an .axmodelstore file.

Example :
Export-AXModelStore -File "C:\Rahul\R2ModelStore.axmodelstore" -Details

For Import
-----------------

Import-AXModelStore -File <Filename>

Example :

Import-AXModelStore -File "C:\DIXF\Rahul\2712\R2ModelStore.axmodelstore"

 

 

 

Press "Y" and Enter...


@Rahul Talasila

 

Database Entity Relationship Diagrams(ERD) For Tables - Axapta 2012 R2

Hello Guys..!

Here I'm sharing link from Ax 2012 R2 ERD diagrams.


http://www.microsoft.com/dynamics/ax/erd/ax2012r2/



@Rahul Talasila

Repeat Table Headers In SSRS Reports - AX 2012

Hello Guys..!

1. Select a drop-down arrow beside column groups and enable "Advanced Mode" by clicking on it.

2. Then under Row Groups, select the static row and choose properties or press F4.

3. Set the following attributes for the static header row:
RepeatOnNewPage : True
KeepWithGroup: None

@Rahul Talasila

 

CIL Generation Errors - Axapta 2012

Hello Guys ..!

Some times we get error while doing CIL compilation .

Here are some errors with solutions.

1.) "A parameter could not be serialized":
For a quick resolve: uncheck option "Execute business operations in CIL"  under Tools-> Options -> Development tab.

The reason is that you haven't been able to do a successful FULL CIL compile.
Run again and try to fix the error in CIL.

2.)"CIL generation: source array was not long enough...":

1. Stop the AOS.
2. Delete all of the source in the C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin\XppIL directory.
3. Start the AOS.
4. Perform a full CIL generation.
5.(Only do if errors are still there and you have no error when compile X++, just comment the code notice in Compiler output with /*..*/, recompile CIL and delete comment tag)

3.) "CIL generation error : The given key was not present in the dictionary":

1. Check the CIL log file, generally located at "C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin\XppIL\Dynamics.Ax.Application.dll.log"
2. You will find the AOT object for which the CIL generator found the error.
3. Compile that object, fix the error, or delete (if needed) and then regenerate the IL.
4. (Only do if errors are still there : Stop AOS > Delete the .auc file from users\\Appdata  folder > Restart AOS)

4.) DB synchronize error: "Field mismatch in union query. Field ... is not compatible with field ..."

Check your EDT concern to that field ( in query, table, view). They have different size.
So you just change the size to be the same.
Or check someone changed size of standard EDT. It's the reason cause this error

5.) "Duplicate type with name 'Dynamics.Ax.application.' in assembly 'Dynamics.Ax.application "

1. Stop the ax service.

2. Truncate the SysXPPAssembly in db model

3. Delete all the files in below directory in server where AOS hosted:

C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin\XppIL

4. Start the service

5. Compile full CIL

For the above post i have used this link.

http://axvuongbao.blogspot.com.tr/2013/12/fix-parameter-could-not-be-serialized.html


@Rahul Talasila
 

Microsoft Dynamics Axapta Database In Recover Mode

Hello Guys,...!

Issue :

Some time Axapta database will go into recovery mode if database restoring is not properly done.

Solution :

-> Open SQLmanagement studio

-> Open new query and paste the below code and change the database name and execute.


ALTER DATABASE MicrosoftDynamicsAX SET MULTI_USER;
GO

// Note : Here my database name is  MicrosoftDynamicsAX

-> After this refresh the database area


@Rahul Talasila