Microsoft Dynamics AX 2009 AOS Troubleshooting tips, AOS Troubleshooting Tips and Techniques in Microsoft Dynamics AX 2009

Microsoft Dynamics AX 2009 AOS Troubleshooting tips, AOS Troubleshooting Tips and Techniques in Microsoft Dynamics AX 2009

·         AOS Configuration

·         Best Practices

·         Troubleshooting AOS issues

·         Finding Sessions and SPIDS

·         AOS Crash Maintenance

·         Tools for Troubleshooting AOS issues

AOS Configuration

·         Application Object Server Configuration

·         Database Tuning Tab

·         Tracing Tab

·         Performance Tab (Dynamics AX 2009)

·         Dynamics AX Server Configuration Utility

·         Configuration stored in Registry:

o   HKLM\SYSTEM\CurrentControlSet\Dynamics Server\4.0\instance\config name

·         Multiple AOS instances and configurations

Server Configurations

·         Each AOS instance listed

·         Each AOS has configurations

Application Object Server Tab

·         Configuration command to run at startup

·         Allowing clients to print from AOS printers

·         Enabling breakpoints

·         Fatal error reporting

·         Load Balancing

AOS Load Balancing

·         Number of client sessions

·         What is a load balancer

·         How connections work when using load balancing

·         Factors when deciding if you need a load balancer

·         Provides fail over ability

·         Balances number of clients between AOS’

·         Control the number of clients per AOS

AOS without clustering

·         With no options marked in the load balancing section each client will connect to the AOS in their client configuration

Each AOS balancing load
As a client connects to an AOS that AOS queries the database to determine which AOS the client will connect to

      AOS as Load Balancer

·         The load balancer makes the connection to the database and determines which AOS the client will connect to

·         This AOS will not accept any client connections nor do any processing

·         This AOS does not count against your AOS licenses

     AOS Load Balancer - Client Configuration

·         In the Dynamics AX 4.0/5.0 Configuration utility you will want to specify the machine name and port number for the AOS load balancer instance

·         Add AOS member instances after the load balancer

      If you do not use a load balancer then you specify all the AOS member instances in your client configuration.  If you do used the load balancer then specify the load balancer first and then the AOS member instances in case your load balancer AOS fails. 

      Database Tuning Tab

·         Max open cursors

·         Max buffer size

·         Allow index hints in queries

    Tracing Tab – Server Settings

·         SQL Statements

o   Queries issues to the SQL Database

·         Bind variables

o   Parameters specified for each of the SQL queries

·         Row fetch

o   Number of rows returned by SQL

·         Row fetch summary

o   Same as row fetch, and includes timing information

·         Connect and disconnect

o   Connections and disconnections to SQL

·         Transactions: TTSBegin, TTSCommit, TTSAbort

o   Transaction statistics, not necessary if X++ method tracing is enabled

    Tracing Tab – SQL Settings

·         RPC round trips to server

o   Remote Procedure Calls between Client and Server

·         X++ method calls

o   Method calls within the X++ language

·         Function Calls

o   X++ built in functions such as int2str

·         Number of nested calls

o   Depth of the X++ call stack when collecting traces

    Dynamics AX 2009 features

·         Performance tab

·         64 bit

·         Batching

·         Time Zones

   Best Practices

·         Separate AOS’

·         Separation of environments

·         Monitoring performance

·         Code deployment

·         Applying latest Kernel hotfixes

   Separate AOS’

·         Consider separating out the following processes / components  based on load

o   Additional Dynamics AX components

o   Third Parties

o   Batch

   Separate out environments

·         Servers for production environment should be on dedicated boxes

o   Server resources dedicated to production performance

o   Reduce risk of development code utilizing majority of Servers resources

o   Application of hotfixes

o   Additional components that need .Net BC

   AOS Baselines

·         Performance Monitor

o   Memory

o   CPU

·         Memory usage

o   Different times of day

o   When specific processes run

    Note:

    On Dynamics AX 4 memory limitation of 2 Gig for each AX32serv.exe process

•       If AX32serv.exe consistently around 1.5 gig of memory start evaluating processes and consider adding another AOS

•       If AX32serv.exe reaches 1.8 gig of memory you will likely see user connections to the AOS denied and possibly AOS crashes

   On Dynamics AX 2009 if running on Windows Server 64 bit editions the limitation is based on memory in server.

   Proper code deployment

·         Code promotion schedule

·         Promote code during down time

·         Determine if you will use XPO’s or layers to move code from development/test to production

·         Test code in environment that matches production before deploying   

   Apply Kernel Hotfixes

·         Improved Stability

·         Apply on all machines with a Dynamics AX components

o   Dynamics AX client

o   Enterprise Portal

o   SSRS machine

o   Any machine with .Net Business Connector

Troubleshooting AOS errors

·         Application event log

·         RPC errors

·         Connection issues

·         AOS Crashing

Application event log

·         Windows default event logging tool

·         Different types of events

o   AOS starting

o   User errors

o   Cache flushing

o   Crashes

Events related to connection

·         Lost connection to AOS

·         Cannot or lost connection to SQL

·         Lost connection to the AOS

Connection to AOS

·         Object Server 01: RPC error: Client provided an invalid session ID 75

o   This error message indicates that the AOS has crashed.  After the AOS crashed a client that was open when the crash occurred tried to connect to the AOS.  Since the AOS was restarted it does not recognize the existing client connection.

o   To resolve this issue the client has to be shut down and restarted

• Object Server 01: No ping from 77. Terminating the session.
• This error message indicates that the end user ended the client session before the AOS could return the requested results to the client. 
• To prevent this error message end users shouldn’t end task (ctrl –alt – delete) their Dynamics AX session.  Instead an end user should contact their AX administrator and have them end their session from the online users form.
• Object Server 01: SPID 57 for Session Id 77, is still present in the database. Please delete the SPID from the database.
• This indicates that the end user shut down their Dynamics AX client before SQL  finished processing the request.
• You can delete the SPID or let SQL finish processing
• If you don’t clean up the SPID it could cause issues such as blocking transactions, and open transactions which may lead to transaction log backup failures.

Connection to SQL

·         Object Server 03: Fatal SQL condition during login. Error message: "[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'Corp\axadmin'.“

• This typically indicates the AOS service account does not have permissions to the database.
• Object Server 03: SQL diagnostics: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'Corp\axadmin'.. Connect information was: Userid = [], Database = [DAX_Prod], Server = [server1], DSN = [], Other = []
• This is caused by insufficient SQL permissions.

·         Object Server 03: Internal Error occurred executing stored procedure when creating session for the AOS.

o   This indicates the AOS Service account does not have adequate permissions to the stored procedures in the database.

Connection to application files

·         Error in file: C:\Program Files \DynamicsAX\ Application\appl\prod \axsys.aod while reading in record 215B1D0
Windows Error: =  Error Code: 64 = The specified network name is no longer available.
Try again?

o   This error indicates the AOS has lost connection to the Application files.

o   To resolve this error message you need to restart the AOS.

Step by Step installation of AX 2009 on Stand Alone System

Step by Step installation of AX 2009 on Stand Alone System/PC/Laptop or on VMs.

Prerequisites are:


Prerequisites Software:

 VMware Work Station or Microsoft Virtual PC 2007.
 Image Burn (To create the ISO files from .exe or .msi files) SetupImgBurn_2.5.7.0
 Virtual Drive(To read the files from ISOs) SetupVirtualCloneDrive5450
 Microsoft Dynamics AX 2009 DVD or ISO
 Microsoft Windows Server 2003 or Microsoft Windows Server 2008 R2 DVD or ISO.
 Microsoft SQL Server 2005 or Microsoft SQL Server 2008 DVD or ISO.
 Microsoft Active Directory (This is with Server 2003 and 2008, runs on command as dcpromo).
 Microsoft Windows XP or Microsoft Windows Vista or Microsoft Windows 7 DVD or ISO.
 Microsoft SharePoint 2007 or 2010 DVD or ISO.
 Microsoft SQL Server Reporting Services and Microsoft SQL Server Analytical Services.
(While installation of SQL, these are the SQL components)
 Microsoft Internet Information Services (Part and package of Server 2003 and 2008).
 Windows SharePoint Services 3.0 Service Pack 1 (SP1) for EP (Enterprise Portal)


Prerequisites Hardware:

 Laptop/Desktop with Microsoft Windows XP or Microsoft Windows Vista or Windows 7.
 Internet Connection (for Online Training and Software or patch download).
 Headphones with microphone.
 Recommend RAM from laptop or PC: More than 3 GB.
 Recommend HDD from laptop or PC: More than 40 GB.
 Recommend Processor from laptop or PC: More than Dual Core (Intel or AMD)


Case One:

I have Laptop, I need to format and I have Windows Server 2003, need to install the AX 2009 over it.

Well in this case first Install the Windows Server 2003. Change the computer/server name to "AX2009" Once you installation is done and you see the computer name is "AX2009", go to run and type dcpromo to create the AD on the same system, since AX 2009 need AD for authentication.

Type domain name as corp.daxadmin.com as FQDN or normal daxadmin.com

If this not support, try to put on your internet connection via dongle. or if you LAN then it would be a great thing just have static IP.

Now once its done with AD for user Administrator  you need to input some complex password like p@ssw0rd.

Now you can enter the laptop or server with domain\user.
In your case it should be corp\administrator or daxadmin\administrator and the password you chose.

Now if all things are well and if you are able to get into the desktop view, now install the SQL 2003 or SQL 2008 R2.

Once done Install the AX 2009 with Microsoft AX 2009 Install documents.

Create user groups in AX 2009

Create user groups in AX 2009

In Microsoft Dynamics AX, permissions and user rights are granted to user groups. By adding a user to a user group, you grant the user all the permissions and user rights assigned to that user group. Before a user can access the product, he or she must be added to the list of product users and added to at least one Microsoft Dynamics AX user group.

By creating users and user groups, you establish who can access Microsoft Dynamics AX and what permissions users have when they are working in the application. Microsoft Dynamics AX requires that all users be listed in Active Directory directory services on your domain controller before they can be enabled on the User form. If a user is not enabled on this form, they cannot access Microsoft Dynamics AX. For more information, see Working with users from Active Directory.

Default

An administrator user and an administrator user group are created the first time Microsoft Dynamics AX is run. The user who opens the first client to connect to an Application Object Server (AOS) instance after installation is set to the Administrator user. The Administrator user is added to the Administrators user group. Administrators have complete access to all forms, menus, tables, reports, the Application Object Tree (AOT), and all security keys.

By default, Microsoft Dynamics AX also creates a Guest user account. The guest user does not have any permissions in the system, and is designed to give access to a public Enterprise Portal site. For detailed information, see Give users access to an Enterprise Portal Internet site in the Enterprise Portal Administration Guide.

Note:

Restrict the number of users who are members of the Administrators user group, which has access to all fields, tables, reports, and modules in Microsoft Dynamics AX by default. If users are made members of the Administrators user group, they can potentially view reports or data that they should not be able to see or change configurations and business logic in the system. Ideally, only those individuals who will configure and administer Microsoft Dynamics AX should be members of the Administrators user group. To further limit this vulnerability, you can create domain administrators, who have administrator rights only to their respective domains. For more information about domain administrators, see Create domain administrators.

Deciding on the structure of your user groups

The groups you create and the permissions you assign to user groups should reflect the structure of your organization. For example, you may want to create groups for Human Resources, Finance, Sales, and Production to name a few, and then set the appropriate permissions for these groups. Create user group names that describe the permissions granted for that group, such as Finance - Full, General ledger - Read Only, Accounts payable - Edit. In this manner you avoid confusion if you have to create additional groups.

Note:

When a user is a member of more than one group and the group permissions overlap (for example, a user is a member of two groups that have access to the General Ledger module), the user inherits the highest permission level between the two groups.

When you are setting permissions for each group, work with business decision makers in each department to determine what permissions each group needs and who should be included in each group.

We recommend that as a security best practice, you create a Developers user group to help minimize the number of users in the Administrators user group. By default, only members of the Administrators user group can make changes in Application Object Tree (AOT), the central repository for classes, tables, and other development elements in Microsoft Dynamics AX. Give the Developers user group access permission to make changes in AOT. Restrict the number of users in the Developers group.

To create a group and add users to that group

The following procedure describes how to add users to a group at the time that the group is created. You do not have to add users to a group when it is created. You can add users to a group later on the User form (see Create new users).

1. From a Microsoft Dynamics AX client, click Administration > Setup > User groups.
2. On the Groups tab, create a new group.
3. Enter an identification in the Group column (required). For example, Fin for Finance or HR for Human Resources.
4. Enter a name in the User group name column (required). For example, Finance Department or Human Resources Department.
5. Click the Users tab.
6. Select users in the Remaining users list and then click the left-arrow button (<) to move the selected users into the Selected users list. All users moved into theSelected users list are added to the current group.
7. Press CTRL+S to save changes.

Now that you have created one or more groups, you are ready to assign permissions. For information about how to assign permissions, see Manage security permissions for user groups and domain combinations.

Thanks & Regards,

Umesh Pandit

B.Sc.,MCA,MCP

Microsoft Dynamics AX Consultant

http://msdynamicsaxtips.blogspot.in/

Skype ID: pandit.umesh

How to Create a New Role Center in Dynamics AX 2009

How to Create a New Role Center in Dynamics AX 2009

One of the most talked about features of AX 2009 is Role Centers... I thought Microsoft did a
phenomenal job by packaging SharePoint and AX in one box... which resulted in really cool
technology.
As complex as they might seem role centers are actually very simple to use.. and its actually even
simpler to create new one..
This is a step by step guide to help users/developers to create and deploy new role centers..
In this example we are going to create a Merchandiser Role Center

Step 1:
Log in as an Admin and open up EP in internet explorer..

Well you actually don't need to be an admin.. but you need site creation rights in SharePoint and also access
to the AOT in AX.

Then click on ‘Site Actions’ and select the ‘Create’ option

Step 2: select Basic Page..

Note: you might be better of select ‘Web Part Page’.. as a basic page would not have any web parts
on it... all the standard role center pages are Web part pages... I will show you both examples in
this article .. hence I started with the basic page. (see the Additional info section below)
Also I like the basic page because it loads up a lot faster!

 Step 3: in the next page, type in the Name of the Page (please use good Naming Convention
Standard)... also make sure that the Document Library is set to Enterprise Portal

Step 4: as I choose to create a Basic Page a Text editor will pop up. if I would choose the Web
Part pages option then this editor would not appear.

Simply type something and click Save... now you would be directed to the new page.

Step 5: open the AOT in AX and browse down to the Web Menu Item Node .. right click and
select New URL.

Step 6: Give the URL a name and a Label (please follow std naming conventions) and then click
on the brose icon on the URL Property (the browse icon is represented by 3 dots).. as shown in
picture

Then expand the Enterprise Portal folder and find the new Page you created. Select and click OK

Step 7: make sure that you set the Home Page Property to Yes..
If you dont set this to yes, then the page will not be available is the role canter page list on the
User profile form (next step)

Save and close the AOT.

Step 8: in AX browse to Administration > Setup > User profiles
Create a new record, set the Profile name and description and then select the new Page as the role
centre page
Assign users to the role and your done.

Additional Info:
 You can also export the role centre (user Profile > Export and Export AOT).. the export
AOT options make the role centre a part of the AOT resource node.. this is helpful if you
want to migrate the role centre from say a dev environment to a Test Environment.
 To create a Web Part Role centre

Rather than selecting the Basic page option ..select the Web Part page option

Then give a name and select EP as the Document Library
Notice I choose to overwrite the role page .. this way I dint have to change my url to
point to the Web part page.

References: http://msdn.microsoft.com/en-us/library/cc558235.aspx

Microsoft Dynamics AX (Microsoft Axapta)

Microsoft Dynamics AX (Microsoft Axapta)

Microsoft Dynamics AX is a multi-language, multi-currency, industry-specific global enterprise resource planning (ERP) software product.

Microsoft Dynamics AX supports operational and administrative processes for organizations in manufacturing, retail,
service industries and the public sector. Among its capabilities are financial management, human resource management (HRM),
manufacturing, supply chain management (SCM), project management and accounting, retail and business intelligence (BI) reporting.

Microsoft Dynamics AX is part of the Microsoft Dynamics family which also includes:

Microsoft Dynamics GP (aimed at mid-market companies)
Microsoft Dynamics NAV (aimed at small companies)
Microsoft Dynamics SL (aimed at small and medium-sized companies)

Microsoft Dynamics AX 4.0 Implementation Guide

Microsoft Dynamics AX 4.0 Implementation Guide

Microsoft Dynamics AX 4.0 Implementation Guide

View or Download Microsoft Dynamics AX 4.0 Implementation Guide here!

http://1drv.ms/1DqX2bT

Thanks & Regards,

Umesh Pandit

B.Sc.,MCA,MCP

Microsoft Dynamics AX Consultant

http://msdynamicsaxtips.blogspot.in/

Skype ID: pandit.umesh

Microsoft Dynamics AX Interview Questions with Answers

Microsoft Dynamics AX Interview Questions with Answers

1. Can we 2-tier / 3 tier thick deployment of Dynamics AX is possible?

ANS: No, Only Option available is 3 tier configurations with a thin client.

2. What type of changes are there in Axapta3.0 and AX4.0 related to recid?

ANS: Axapta3.0 recid is 32 bit. Ax4.0 recid is 64 bit.

3.  Can we specify the type of operation a user can perform on table depending upon user’s permission in Dynamics Ax 4.0?

ANS: Yes using AOS Authorization table property.

4.    What is unit testing framework in Dynamics Ax 4.0?

ANS: Microsoft Dynamics AX now has an integrated Unit Test Framework built into the MorphX development environment. Unit tests are made as individual test cases. Each test can include a number of tests in the form of assertions. Test cases can be contained within test suite classes or as part of a project in MorphX. Testing can be done from the Unit Test toolbar from which individual test cases, test suites, or test projects can be executed. Test results can be viewed from the Unit Test toolbar that indicates the test passed or failed state, per case and test, and can even include code coverage measures for the classes and methods that are tested.

5.    What is the difference in Cross Reference of Ax 3.0 and Ax 4.0?

ANS: Cross-references to other Microsoft Dynamics AX objects are now name-based and no longer ID-based. If you rename an object, you need to update all the references to it.

6.    What is the difference in Layers of Ax 3.0 and Ax 4.0?

ANS: The GLS layer has now been merged into the SYS layer. A new SE layer has been introduced. The IDs for the SYS layer are now 1-14000. The IDs for the SE layer are 14001-16000.

7.    What is optimistic concurrency control? And how you can enable it for a table in Ax 4.0?

ANS:

•         The optimistic concurrency control is enabled for a table by setting the OccEnabled property on a table or calling the DictTable.occEnabledmethod.

•         When this mode is enabled, data is not locked from future modification when it is fetched from the database. Data is locked only when the actual update is performed.

8.    What type of communication is there between Client and Server in Ax4.0?

ANS: RPC where as in 3.0 it is socket programming.

9.    What type of changes are there in Axapta3.0 and AX4.0 related to recid?

ANS: Axapta3.0 recid is 32 bit. Ax4.0 recid is 64 bit.

10. What we need to consider at the time of installation when upgrading?

ANS: check box Start the AOS Windows service as part of installation should be unchecked.

11. Can I have 2-tier installation of AX?

ANS: No. Ax has only 3-tier installation whereas Axapta3.0 supports both 2-tier and 3-tier.

12. What type of communication is there between Client and Server in Ax4.0?

ANS: RPC where as in 3.0 it is socket programming.

13. What type of changes are there in Axapta3.0 and AX4.0 related to recid?

ANS: Axapta3.0 recid is 32 bit. Ax4.0 recid is 64 bit.

14. What are the 4 types of files we need to copy to the standard folder?

ANS: *.aod, *.ahd, *.ald, *.add, *.khd

15. Which file we delete from standard folder?

ANS: axapd.aoi file( Index file).

16. What is Enterprise portal?

ANS: Web enable part of Axapta is called enterprise portal.

17. What business connector enterprise portal uses to connect with SharePoint?

ANS: .Net business connector in AX4.0 COM business connector in 3.0.

18. What type of objects can I expose to enterprise portal?

ANS: Webforms, Webreports, AXreports, Classes. But not AXForms.

19. What are the two types of WebMenuItems in AX?

ANS: URLs and Actions.

20. What type of WebmenuItem we use for WebReports and WebForms?

ANS: URL type.

21. What are two types of WebContentItems in AX?

ANS: Display and Output.

22. Can we see the AX form in EP?

ANS: No. we can’t see the AX form in EP.

23. How many default templates are available for enterprise portal in SharePoint template picker?

ANS:  2 Templates.

•         Microsoft Dynamics Enterprise Portal

•         Microsoft Dynamics Public

24. Business connector proxy must be a member of which user groups in AD?

ANS: IIS_WPG, SPS_WPG

25. Action type WebmenuItem is used to refer what type of object in AX?

ANS: Classes and Jobs.

26. Output type webContent is used to refer what type of objects in AX?

ANS: Web reports and reports.

27. Display type webContent is used to refer what type of objects in AX?

ANS: Web Forms only.

28. Where can I register the site as EP site?

ANS: In administration->setup->Internet->Enterprise portal->Websites->register website button.

29. What type of weblet we use to display the Axreport or Webreport in EP?

ANS: WebReportweblet.

30. What type of weblet we use to display the Webforms in EP?

ANS: WebFormWeblet.

31. Name few of the Dynamics Ax Weblets.

ANS: WebReportweblet, WebFormWeblet, WebImageWeblet, PageTitleWeblet, WebMenuBoxWeblet, WebMenuWeblet.

32. Where can we find the AX weblets in sharepoint?

ANS: In virtual server gallery.

33. Why we use virtual companies?

ANS: Virtual company accounts contain data in certain tables that are shared by any number of company accounts. This allows users to post information in one company that will be available to another company.

34. To enable the Debugging of X++ what should we do?

ANS: Set the debug mode to “When break point” in Development tab in tools-> options.

Check “Enable breakpoints to debug X++ code running on this server” on the server configuration utility to debug the server code.

35. Can we debug the Business connector code running on the server?

ANS: Yes. By selecting the check box “Enable User break points to debug code running on the Business connector”.

36. What type of relationship we can define for an extended Data Type   (Multiple ANSwer)

ANS: Single Field Relationship, Conditions on a relationship

37. While implementing ax when it is advisable to setup the virtual companies?

ANS: If you would like to use virtual companies at some time in the future, it is best to set up the virtual companies from the beginning of the implementation of Microsoft Dynamics AX. This avoids problems with combining records into a shared table at some time in the future.

38. Before you can create or modify a virtual company account what must be established?

ANS:

•         The application object server that the administrator is connected to must be the only one running. All other application object servers must be shut down.

•         Only the administrator who is creating the virtual company account can be connected; only one active client connection is allowed.

•         After you create or modify a virtual company account, you must restart the Microsoft Dynamics AX client in order to update the client with the new virtual company account information.

39. How u can check that for a particular SQL call RLS is applied or not?

ANS: Using Database trace. Database trace should be activated for this. For RLS applied statements it will show like this salesLine.select () (RLS)

40. What is the difference between the Client kernel and Business connector kernel?

ANS:

•         The Session Manager in the client kernel manages only a single instance--in the Business Connector kernel, it manages multiple instances.

•         The client kernel includes forms security, while the Business Connector kernel does not.

41. What Type of cache you will apply for most static data

ANS: Found

42. How can we cache a display method of a table?

ANS: By Using CacheAddMethod

43. When there are common methods across tables, which will be the best option to create?

ANS: Create a map and add those methods and corresponding tables

44. How can we restrict a class to be further extended?

ANS: using Final Keyword for ex: public final class <ClassName>

45. In Axapta can we use tables as classes?

ANS: Yes

46. If yes Then Can we extend the table as similar to class? If yes then how it is possible and if no then why?

ANS: No, Tables are by default Final.

47. What all are methods modifiers?

ANS: abstract, client, display, edit, final, public, private, protected, server, static.

48. I want to put final modifier to new and finalize methods? How can I do this where I need to right this keyword in method?

ANS: You cannot use Final modifiers for the New and Finalize methods.

49. What are optional parameters?

ANS: It is possible to initialize parameters in the method declaration. This makes the parameter an optional parameter. If no value is supplied in the method call, the default value is used.

50. What are local functions?

ANS: With X++, you can embed a function inside a method to create a local function (or local method). The local functions that you can create in X++ are only visible within the scope where they are defined.

51. How u can get the count of methods in a class?

ANS: Using DictClass methods: staticMethodCount and     objectMethodCount

52. Which class will be used for ODBC connection?

ANS: ODBCConnection

53. Which are classes are used for data import export?

ANS: SysDataImport and SysDataExport

54. Which is the base class for these two classes above mentioned?

ANS: SysDataImportBase and SysDataExportBase.

55. Which class will be used to get the object names, security key names / count, configuration key name/ count etc.?

ANS: Dictionary

56. Which is the class used for creating / opening files?

ANS: IO

57. How can we get the no of table available in Ax through code?

ANS: Using Dictionary class object tablecnt method.

58. Which class will be used to get the online users info?

ANS: SysUsersOnline

59. Which is the mandatory parameter needs to be passed while creating the ODBC connection class object?

ANS: LoginProperty class object.

60. Which all classes will be used to create a com object for excel application?

ANS: SysExcel, SysExcelApplication, SysExcelApplication_2000, SysExcelApplication_2007, SysExcelApplication_XP.

Note: There are related classes for opening the workbooks, worksheets, range, cells. For Ex:SysExcelCell, SysExcelCell_2000, SysExcelCell_XP, SysExcelCell_2007.

61. How can we get the client computer name through code?

ANS: Class xSession, Method: clientComputerName()

62. Do you know about List class in Dynamics Ax? Why it is used?

ANS: Lists are structures that can contain values of any X++ type. All the values in the list must be of the same type.

63. Which function is used to get current user name in Ax?

ANS: Curusrid();

64. Which function is used to change the company through code?

ANS: ChangeCompany(‘companyName’);

65. From which table u can get the user permissions stored in Ax?

ANS: AccessRightList table.

66. What is the use of VirtualDataAreaList table?

ANS: This table stores the list of virtual companies available in Dynamics Ax.

67. What all are aggregate functions available in select statement of X++?

ANS: sum | avg | minof | maxof | count

Options = [(order by | group by) FieldIdentifier [ asc | desc ]

68. What is the use of update method?

ANS: Updates the current record with the contents of the buffer.

69. When one should use doUpdate?

ANS: The doUpdate method should be used when the update method on the table is to be bypassed.

70. What is the difference between X++ and SQL sort command in select statement?

ANS: X++ does not allow group by and order by clauses in the same select statement. This means that explicit sorting is not possible. SQL does allow group by and order by clauses to be in the same statement.

71. What should we use to increase performance while inserting, updating or deleting records from a table?

ANS:

•         RecordSortedList: Allows you to insert multiple records in one database trip. Use the RecordSortedList construct when you want a subset of data from a particular table, and when you want it sorted in an order that does not currently exist as an index.

•         RecordInsertList: Allows you to insert multiple records in one database trip. Use the RecordInsertList construct when you do not need to sort the data.

•         insert_recordset: Allows you to copy multiple records from one or more tables directly into another table on a single database trip.

•         update_recordset: Allows you to update multiple rows in a table on a single database trip.

•         delete_from Allows you to delete multiple records from the database on a single database trip.

72. Do forms support Inheritance?

ANS: No

73. What is must to be declared for a control to get accessed anywhere in the form?

ANS: In the control properties set the Auto declaration property to yes.

74. What should we do if we need last record to be active when a form is opened?

ANS: In properties of datasource table set the StartPosition property as last.

75. What are the different link types available?

ANS:

•         Active

•         Delayed

•         Passive

•         InnerJoin

•         OuterJoin

•         ExistsJoin

•         NotExistsJoin

76. What are the three basic nodes found in Forms Node?

ANS:

•         Methods

•         Data Sources

•         The Data source defines the interface between the form and the database.

•         Design

•         The design of the form defines the interface between the form and the user and controls the layout and presentation of the data.

77. What for Formrun Kernel class and FormDataSource Kernel Class are used?

ANS:

•         Formrun Kernel class is used to control the Startup and Shutdown of the    form.

•         FormDataSource Kernel Class contains the methods which are used for Displaying, Validating and Updating data in forms.

•         The objects for each data source and data fields defined are inherited form which kernel class?

•         (Data Source)FormDataSource which has methods related to displaying, validating, and updating data.

•         (Data Field)FormDataObject which has methods related to field specific navigation (filter, lookup, jump to main table etc.), validating and modifying the field.

78. What properties are to be used and set in a form for automatically creating a new record in it?

ANS:

•         Set the InsertIfEmpty Property to yes if the forms do not find any data

•         Set the InsertAtEnd Property to yes if the user browses past the last record in the data source

•         (Note: If the user browses past the last record in the data source)

79. Different Properties of a field.

ANS:

•         Allow Edit: This property specifies whether the field can be changed. This property can't remove a restriction imposed by the table field, security settings, or the data source.

•         Enabled: The enabled property specifies whether the user can access the control. If the field is disabled it will be grayed and the used can not give focus to the control.

•         Visible: This property can be used to remove a field from the user interface. The same property exists on the database field and should be specified here if the option should apply system wide.

•         Allow Edit: This property specified whether the field can be added to the design by the user. Because the default value is restricted, the default behavior of forms is set so that extra information cannot be added to the form.

In order to add a field to a design, two prerequisites must be met.

•         The AllowAdd property on the datasource field must allow the field to be added.

•         The container where the field is to be added must allow full user setup

Mandatory: This option determines if it is required to fill in data in this field. The same property exists on the database field and should be specified here if the option should apply system wide.

80. Which is the best practice followed for placing code?

ANS: To program system wide logic which is tight related to a record, we should place the logic in object methods on the table. The table which inherits from the kernel class xRecord has many events we can override and supplement with our logic.

If we are to put the X++ code in the form, try to avoid programming on the design and put our logic on the data source. Many events on the design are very dependant on exactly how the user is navigating the form. The programming on the controls does not take the user possibility to modify the contents of the form into account.

81. What does FormRun.Init method do?

ANS: This method initializes the form and its objects and is the first event we can override in connection with the start up of the form.

82. What is the importance of super call method in FormRun.Init?

ANS: Never remove the super () call from this method, as this removes the initialization of all the objects.

83. How to do manual initializations in FormRun.Init?

ANS: If you want to make some manual initializations this is typically placed in this method. This could include the following tasks:

•         Verification of the contents of the args-object received

•         Initialization of supporting classes

•         Dynamically changes to the design

84. What is FormRun.Close method used for?

ANS: This method shuts down the form. If we have some cleanup in connection with finishing the execution of the form, this will be the place.

85. What is FormDataSource.Init method used for?

ANS:

•         This method initializes the data source and is called from the super () of FormRun.Init (). The method will only be called once when the form is opened.

•         The main task for this method is to initialize the query used for fetching data.

•         If we want to modify or replace the query automatically created by the form, this should be done after the super () call of this method.

86. FormDataSource.InitValue Method?

ANS:

•         This method is used to initialize a new record with default values. The super () of this method calls the corresponding method on the underlying table, which in turn invokes the record template functionality.

•         If we have some initialization which should apply system wide, you should place the code on the table.

87. FormDataSource.Active Method?

ANS:

•         This event is called when a new record becomes active in the data source and is typically overridden to change properties which depend on the contents of the current record:

o    Modify access rights to the data source

o    Modify access rights to the fields

o    Enable/Disable buttons

88. Where is the specification of fields stored in report?

ANS: AutoDesignSpecs

89. How many generated designs we can have in a report design?

ANS: 1

90. What is the sequence of events while a report is generated?

ANS: Init, Run, Prompt, Fetch, Print

91. If AutoHeader property of the query is set to Yes, where will this get reflected?

ANS: Report

92. Through overriding of which method of report we can restrict the user to see only certain records which are not possible through the range method?

ANS: Fetch

93. Through overriding of which method we can hide the columns or parts of report?

ANS: Execute Section

94. If the design is similar for more than one report what is the best solution in developing such reports?

ANS: Use Report Templates.

95. What are query criteria operators?

ANS: = =,!=, >, <, ..(Range)

96. Name few X++ classes/Coreclasses related to Queries?

ANS:  Query, QueryRun, QueryBuildRange, QueryBuildDataSource, QueryBuildLink.

97. How many sorting fields we can add to a query?

ANS: we can add many. But adding many will slow down the query performance.

What else you need to download and keep it as pdf.

Download or view as pdf link::   http://1drv.ms/1MljGqm

Happy Infra!

Thanks & Regards,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit

Microsoft Dynamics AX 3.0;Microsoft Axapta 3;Axapta 3.0;Axapta Ver 3.0 Dynamics AX A Guide to Microsoft Axapta 3.0.pdf

Microsoft Dynamics AX 3.0; Microsoft Axapta 3; Axapta 3.0; Axapta Ver 3.0 Dynamics AX A Guide to Microsoft Axapta 3.0.pdf

Today I got mail from my connection in LinkedIn, so thought of sharing this book,

Microsoft Dynamics AX 3.0;Microsoft Axapta 3;Axapta 3.0;Axapta Ver 3.0

Happy Axapta!

Thanks & Regards,

Umesh Pandit

Microsoft Dynamics AX

http://msdynamicsaxtips.blogspot.in/

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit

How to set up the Business Connector proxy user in AX 4.0

How to set up the Business Connector proxy user in AX 4.0

The proxy is a Microsoft Windows domain account that enables Business Connector to “act on behalf” of Microsoft Dynamics AX users when authenticating with Application Object Server (AOS). You must set up and configure the proxy as described in this topic. If you do not set up and configure the proxy as described here, remote users cannot connect to Microsoft Dynamics AX using external Web application if the application depends on user impersonation in Business Connector.

Important

If a malicious user learns the Business Connector proxy credentials (name and password),
that user could gain unauthorized access to sensitive information. For this reason,
only Microsoft Dynamics AX administrators should know the proxy credentials.

To set up and configure the Business Connector proxy, you must:

1. Create the proxy account in Active Directory directory service.
2. Create the proxy account in the Microsoft Dynamics AX database.

Create the proxy account in Active Directory directory service

You must create a proxy account in Active Directory on your domain controller before Business Connector can "act on behalf" of remote users. If the proxy account does not exist in Active Directory, remote users cannot authenticate with Microsoft Dynamics AX.

To create the proxy account in Active Directory

1. Create a unique user in Active Directory in the form domain\username, for example, redmond\bcproxy. This user must not have the same name as an existing Microsoft Dynamics AX user. For the procedure to add a new user, see the Active Directory documentation.
2. Assign a password to the user.
3. Select the Password does not expire option.
4. Select the No interactive logon rights option.
5. Close Active Directory.

Set the proxy account in the Microsoft Dynamics AX database

After you created the proxy account in Active Directory, you must add the account to the Microsoft Dynamics AX database. By storing the proxy account in the database, multiple AOS instances can access the proxy and thereby authenticate multiple users.

To set the proxy account in the Microsoft Dynamics-AX database

1. From a Microsoft Dynamics AX Client, click Administration > Setup > Security > Business Connector Proxy.
2. In the Alias field, enter the name of the proxy user previously entered in Active Directory, for example, bcproxy.
3. In the Network domain field, enter the domain.
4. Click Apply.

See Also

Set up the Business Connector proxy user for Enterprise Portal

Install Business Connector to support a custom application

Manage a Business Connector non-interactive configuration

http://msdn.microsoft.com/en-us/library/aa496652(v=ax.10).aspx

List of Companies Working on AX (Axapta) in India,List of Companies Working on AX,List of Companies Working on Axapta

List of Companies working on AX in India and all the MNC working on AX.

As we all know AX or Axapta is an ERP from Microsoft!
More on AX at  Microsoft Dynamics AX

Updated List of Companies working on AX in India and all the MNC working on AX till date.

Please click on this link here

or View This:



Request all to comment if you want some company to be updated or Listed in this sheet.
We are a team of four Members updating this sheet as and when needed.

Contributors:

Umesh Pandit
Rohan Sodani
Gyan Chand Kabra
Aman Deep Singh Bhatia
Deep Vineet

Happy DAX Infra!

Thanks & Regards,

Umesh Pandit

B.Sc.,MCA,MCP,ITIL

Microsoft Dynamics AX Consultant

http://msdynamicsaxtips.blogspot.in/

Skype ID: pandit.umesh