Skip to main content

Posts

Showing posts from April, 2014

Static Ip problem for sharepoint and database in MSD Axapta

case scenario, In share point service administration site is working and default database is connecting with static IP of sql database if user removed static ip of database server then sharepoint stop working.  I tried to change ip with pc name in sharepoint administration then still problem exists. Now timeout error is not coming but sometimes error is coming like “ share point issued an error please contact to system administration” from user side. This error is coming for only one ep page. On sql event log error. Unknown SQL Exception 10054 occured. Additional error information from SQL Server is included below. A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) Please share your views for the same Possible solution: Remove static Ip of database from sharepoint administration after that is Site stop working then re-configure share

Timeout error for EP page in MSD axapta

Eventlog error details. The Execute method of job definition Microsoft.SharePoint.Search.Administration.SPSearchJobDefinition (ID f563b66c-e273-42f4-b0db-4106a63f0a83) threw an exception. More information is included below. Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. EP Page is being timeout. Possible solution: Increase time out on IIS for website, increase time out at web.config files.

Sharepoint error in eventlog for MSD axapta EP

I am facing this error on event log. I checked that EP and sharepoint site is working fine but still this error is coming after re installation of EP The description for Event ID 27745 from source Windows SharePoint Services 3 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer. If the event originated on another computer, the display information had to be saved with the event. The following information was included with the event: #50071: Unable to connect to the database SharePoint_Config on xxxx.xx.xx.xxx.  Check the database connection information and make sure that the database server is running. the message resource is present but the message is not found in the string/message table

What is the solution of faulting error in MSD axapta

I am facing this error in eventlog. could anyone advice the reason and solution for this error. Faulting application SAPISSVC.EXE, version 7.0.0.1, time stamp 0x4f27b98d, faulting module kernel32.dll, version 6.0.6001.18538, time stamp 0x4cb73957, exception code 0xc0000142, fault offset 0x00000000000b1b48, process id 0x2804, application start time 0x01cf55faf48cdb27.

Difference between Primary and Cluster index in Axapta

Primary index uniquely identifies records in any given table. Each unique combination of Primary Key fields uniquely identifies only one record in the table. There can only be one primary key per table. Cluster Index is the physical order in which records are stored in the table. Cluster Indexes do not have to be unique.

Difference between Index and Index hint in MSD Ax

What is the difference between Index and Index hint? Index is used to give the control to the database for optimization. AX Kernel will add an OrderBy with all the fields of the index. Index Hint tells the database to use specified index and no other one. All Tables should have at least one find method that selects and returns one record method should be a Boolean variable called method; from the table that matches the unique index specified by the input parameters.

Definition and use of Maps in MSD axapta

Definition and use of Maps, how AddressMap (with methods) is used in standard AX Maps can unify the access to similar columns and methods that are present in multiple tables. Maps are elements that wrap table objects at run time. We can associate a map field with a field in one or more tables. This association enables to use the same field name to access fields with different names in different tables. Map methods enable us to Create or Modify methods that act on the map fields

Question and answers on Reports in MSD axapta

Q)what are the important methods on report? Ans: fetch, send, dialog, getfromdialog, pack, unpack programmable section - control number - we can execute the ps with e element.execute(controlNumber) in the fetch method Q)What is the difference between auto-design and generated design? Ans: Generate design will not give the printing options of print totals, print grand totals Q) How to create a Report template ? Ans: You can refer to existing templates and can replicate the logic pageno - element.page(),companyname

Some important question and answers on forms in MSD axapta

Q)when you open the form - what methods/calling sequences ? Ans:init(), run(), executequery() Q)When you close the form? Ans:canclose()- boolean, close() Ok command buton - closeok(), canclose(), close() Q)when you create a new record? Ans:Ctrl + n, create of ds, initvalue() of ds, initvalue() of table Q)how do you do filteraions on the forms? Ans: Executequery and use queryBuildRange Q)Enabling and  disabling controls ?   Ans:active method of data source Q)How  do you link the datasources on the form?? Ans: join source and link type property Q )How many link types are available on the datasource?? Ans:delayed, active, passive, inner join, exists join, non exists join, outer join Splitters [sysformsplitter_x, y, z] Q )How  to you pass values from one form to another form - Ans: menuitemButton - Args[formrun] Q )what is args class?? Ans:Args is arguments class which will help to pass values from one form to another, object to obj

Interview question and answer for Data dictionary in MSD Axapta

Table - collection of rows and columns EDT(Extended datatype) - Inheritance, code easy readability, lookups,- 2 RELAtions [Normal and RFF [where clause] example : select * from custtable - is normal select * from custtable where gender == female is RFF How to add columns to the Lookups [Index, Titlefield1, 2 or autolookups] Q) How to get lookups?? In 3 ways - EDT, AutoLookup,Relations Q) what is base enum??? Set of literals or constants which will never change - example [week - s,s,m,t,....] enums are stored as integers and max - 250 can be accessed by using :: [scope resolution] Indexes why do we use index ?- faster performance in select queries Not to allow duplicates FieldName Followed by Idx = AccountNoIdx Field groups: Autoreport - ctrl + p Autolookup almost all the fields should fall under a fieldgroup - on the forms - field groups will form as Group control Relations on table : How one table is related or linked to another Normal -

Some interview question and answer for classes in MSD axapta

1) ACCESS Modifiers [Public, private, protected, static, display] 2) Is multiple inheritance possible in AX?? No It can be achived through interfaces. Interfaces : It does not have method definition] void calculate() {} class classz implements interface void calculate() { a +b; } 3) Is method overloading possible, or function overloading possible in AX ??? No - it does not allow to create another method with same name 4)Abstract and final key words abstract - no need to create object, y?? when we know that we have to create object of child classes only, I will make the class as abstract and i use the concept of constructor controlled inheritance construct(str _bankName) { swtich() {} }

Why You selected Ax for your career MSDAX

AX is a very good ERP which I heard and it supports Tier1 to Tier3 companies It can easily integrate with all other Technologies[sql server, biztalk, ssis, ssrs, MS office] Programming seems to be very similar to .net and I feel very comfortable Also, AX is easy on customization. AX is pretty reasonable when compared with other ERP's. Its good user friendly. It support re-usability means you can develop scenario to implement same things in different clients. 

SSRS Report deployment Error in MSD Axapta EP

I am getting following error on report (SSRS) in EP for axapta. Deployment failed un xpectedly with the message: Invalid URI: The format of the URI could not be determined. See the log file for further details. The deployment log file can be found at My Observation. In AOS there is both sql 2005 reporting service and 2008(Database in sql 2008) exists As per my views if We remove installation of sql 2005 reporting service then problem can be resolve. Please give your comment on this latest error. The deployment log file details are as below Could not load file or assembly 'Microsoft.Dynamics.AX.Fim.PaymentService, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.   at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)