Skip to main content

Posts

Showing posts with the label synchronize the database

SQL Error can not select record from table abc in MSD axapta

Some times we face this error which is SQL Error " can not select record from table abc " in axapta application. This error comes due to some index problem or record duplication in table to resolve this problem we can do following. 1. Find index which creating problem you can re index that index. 2. Restore table using right click on table restore option. 3. Synchronize table if problem still not resolved. 4. If problem still not resolved then try to synchronize whole data dictionary in AOT. 5. If you are facing problem due to duplication of records then try to delete duplicate records. By using above steps I hope your problem will resolve.

How to Transfer of Modifications in axapta application in MSDAX

Use the following process to transfer modifications: 1. All AOS instances accessing the application in the source and destination environment must be shut down. 2. The files that contain modifications of application objects (aod) and labels (ald) are copied from the development environment to the destination environment. 3. Delete the .ali files associated with the label files that you are copying. 4. When the AOS is restarted on the destination application, the system will rebuild index files. The file axapd.aoi is the application object index file. This takes a few minutes to be rebuilt. The .ali files deleted in the previous step will also be rebuilt. 5. Open an AX Client, synchronize the database and re-compile the whole application.