Posts

Showing posts from March, 2012

Optimistic Concurrency Control (OCC) Property in Dynamics Axapta

Definition Optimistic Concurrency Control (OCC) helps increase database performance. Pessimistic Concurrency Control locks records as soon as they are fetched from the database for an update. However, Optimistic Concurrency only locks records from the time when the actual update is performed. Pessimistic concurrency was the only option available in Microsoft Axapta 3.0 (now a part of Microsoft Dynamics). You can now choose which concurrency model to use—optimistic or pessimistic. RecVersion is a 32-bit signed INTEGER. But it will never get a negative  value assingned through the AOS. Advantages Fewer resources are used to hold the locks during the update process. Records are locked for a shorter length of time. Records remain available for other processes to update if they have been selected from the database but haven't yet been updated. Disadvantages The disadvantage of using OCC is that the update can fail if another process updates the same record. I

Visual Studio 2008 does not contain the Dynamics AX EP Template

Once we installed the Visual Studio 2008 and AX Enterprise Portal Development tools in the Dynamics Ax 2009 Web server, we still cannot find any Dynamics AX template in the Visual Studio 2008 if we are using other accounts. The issue is caused by the AX template that is not deployed in Visual Studio 2008. The solution to fix that issue is to check the Application Data folder in the account which we are using to develop AX EP. In Windows 2003, we need to check those folder in the beneath: C:\Documents and Settings\usersaccount\Application Data\Microsoft\VisualStudio\9.0\ItemTemplatesCache\Visual Web Developer\CSharp C:\Documents and Settings\usersaccount\Application Data\Microsoft\VisualStudio\9.0\ProjectTemplatesCache\Visual Web Developer\CSharp\ If there are no folders or files in those two folder, we need to copy from the account who installed the Visual Studio 2008. The other issue is that we cannot see all the Dynamics AX control in the VS2008 Dynamics Ax tool box. The solution to