Microsoft Dynamics Axapta Technical,Functional Coverage

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

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.

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

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.

Super() is used together with inheritance. Calling Super() means calling a method with the same name in parent class. The parent can be a normal class in X++, or it can be a kernel call.

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.

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.