Microsoft Dynamics AX 2012 R3 Training

On Channel 9 two good startup trainings available for Dynamics ax R3

1. Microsoft Dynamics AX 2012 R3 Training: (01) Transportation Management

2. Microsoft Dynamics AX 2012 R3 Training: (02) Warehouse Management

Custom workflow Participant Provider

Very good example on custom workflow Participant Provider on Ax 2009, similar implementation for Ax 2012 also.
In Microsoft Dynamics AX, there are four workflow provider types. In some cases, the instances of these providers may not meet …your application requirements. The following procedure describes the steps to implement a custom workflow provider.
You create a custom workflow provider by implementing a workflow provider interface. See Workflow Provider Interfaces for more information about the interface for each provider type. Choose the appropriate interface type for your custom provider, and implement the methods in a class using the following procedure

Maximum number of Tables in a Join error

You might encounter this error if you trying to make new relations with table that already have high number of relations defined on it Like “InventTable”. On showing the field to form you might see a warning message that “The table exceeds the max join limit…….”

Solution:

Maximum number of Tables in a Join defined in the Server Configuration (System Administration > Setup > System > Server Configuration). There you need to change the number to allow more join tables. After that you also need to restart the AOS service to reflect this change on tables.

ac004

There is performance factor also, which is explained well on the Brandon’s Blog

A CLR error occurred while invoking the scheduling engine

We came across this issue recently. When running the Production Job scheduling process you experience error

“A CLR error occurred while invoking the scheduling engine.” and the exception details look like this System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation —> Microsoft.Dynamics.AX.ManagedInterop.ContainerNotValidException The Microsoft Dynamics container being referenced is not valid at Microsoft.Dynamics.AX.ManagedInterop.Container.get_Count()

The issue in this was caused by the AOS Server configuration option “Enable the hot-swapping of assemblies for each development session” being enabled on the server. This option should NOT be activated on production environments.Disabling th eoption resolved the issue However there are other causes of production job scheduling issues, and this are mentioned in the Microsoft Dynamics AX 2012 Release Notes

Production Data export to import in Dev/Test environment made easy by Microsoft

A new tool is release Microsoft Dynamics AX 2012 Test Data Transfer Tool (beta) on InformationSource!
This command-line tool exports data from a Microsoft Dynamics AX 2012 business database like from Production systems, and imports it into a Microsoft Dynamics AX 2012 business database in a non-production environment like Dev/Test environment.

Syntax to run this tool

 DP.exe direction directory database server
   Parameter    Default value    Description
direction    EXPORT    Specify EXPORT to export data or IMPORT to import data.
directory    The current directory    Specify the directory from which the data should be exported or to which the data should be imported.
database    AXDB    The name of the database.
server    The current computer    Specify the computer name or instance name of the SQL Server computer that is hosting the Microsoft Dynamics AX database.

Installation is also very easy

Install the Test Data Transfer Tool (beta)

Download the tool, and extract it to a local folder.
Right-click AX2012TestDataTransferTool.msi, and then click Run as administrator.
In the Setup wizard, accept the license terms, and then select the location in which to install the binaries and files for the tool. By default, the tool is installed to %Program Files%/Microsoft Dynamics AX 2012 Test Data Transfer Tool (Beta).
For complete details about the tool anyone can follow the TechNet link  Or Information Source

Dynamics AX 2012: Job to create and sent outlook Tasks

Recently i got chance to work on AX integration project with OUTLOOK where i have to create the Tasks from dynamics ax in outlook and also email it to. check the job below that complete the requirements.

 static void OutlookAppointment(Args _args)  
 {  
   COM    sysOutlookCollection;  
   COM    receipiants;  
   COM    collection;  
   COMVariant comStartDate = new COMVariant();  
   COMVariant comEndDate  = new  
   COMVariant();  
   COM    c;  
   #SysOutLookCOMDEF  
   #define.mapi("MAPI")  
   #define.outlook("Outlook.Application")  
   COM    sysOutlook;  
   COM    sysOutlookNameSpace;  
   COM    sysOutlookMAPIFolder;  
   sysOutlook         = new COM(#outlook);  
   sysOutlookNameSpace     = sysOutlook.getNamespace(#mapi);  
   sysOutlookNameSpace.logon();    
   sysOutlookMAPIFolder    = sysOutlookNameSpace.getDefaultFolder(#OlDefaultFolders_olFolderTasks);  
   collection         = sysOutlookMAPIFolder.items();  
   c = collection.add();  
   comStartDate.date(today());  
   comStartDate.time(str2Time( "12:00:00"));  
   comEndDate.date(today());  
   comEndDate.time(str2Time( "12:45:00"));  
   c.subject("Meeting regd Microsoft Dynamics AX 2012");  
   c.body("Lets discuss on whats new in DAX 2012");  
   c.save();  
   if (c)  
   {  
     receipiants = c.Recipients();  
     receipiants.add("test@microsoft.com");  
     receipiants.ResolveAll();  
     c.assign();  
     //c.display();  
     c.send();  
     info("The action is created in Microsoft Outlook");  
   }  
   else  
   throw error("@SYS31969");  
   sysOutlookNameSpace.logoff();  
 }  

Dynamics AX 2012 Installation in silent Mode

There are two ways through which we can install dynamics ax in silent mode. 1) Through command prompt 2) Through Parameter file.

Installation parameters at the command prompt

Open a Command Prompt window.
At the command prompt, type the following information:<Path to DVD or shared directory>\Setup.exe parameter1=”valueparameter2=”value

When using multiple parameters, insert a single space between parameters.
If you enter duplicate parameters, Setup will fail silently.
After you have listed all parameters, press Enter.

Installation parameters using a parameter file

Create a text file that lists the appropriate installation parameters and their values. In the parameter file, the
Name=Value combination for each parameter must be on a separate line.

If you enter duplicate parameters, Setup will fail silently.
Do not include double quotation marks in parameter files. Because a line return is used as a delimiter in a parameter file, values that otherwise require the use of double quotation marks do not require them here.
To prevent a line in a parameter file from being read, type a number sign (#) before the line. The line will be treated as a comment rather than a command or parameter.
Open a Command Prompt window.
At the command prompt, type the following information:

<Path to DVD or shared directory>\Setup.exe ParmFile=<path to file\FileName.txt>

Press Enter.

Sample Parameter file

The following is an example of a parameter file that can be used to install the databases and the Application Object Server (AOS). Your parameter file will vary, based on the components that you are installing.

HideUI=1
AcceptLicenseTerms=1
DbSqlServer=SQLServerName
DbSqlDatabaseName=DatabaseName
InstallApplication=1
ApplicationInstanceName=ApplicationInstanceName
InstallAos=1
AosInstanceName=AOSInstanceName
AosApplicationPath=”C:\Program Files\Microsoft Dynamics AX\60″
AosReportErrors=0

Follow

Get every new post delivered to your Inbox.

Join 120 other followers

%d bloggers like this: