Saturday, April 12, 2014

Static Ip problem for sharepoint and database in 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 sharepoint site using share point wizard configuration.

Timeout error for EP page in 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 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 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.

super method in Axapta

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.

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 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 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

Popular Posts

Active Search Results Technology Blogs