In Ax upgradations we might get some DB synchronization issue like below errors:

Error :

Cannot select  a record in Global address book(some table name)

Sql error description: Invalid column name ‘XXXX’(some field name)

Below are the steps to follow:

–Step 1. To create a temptable and pass all records into temptable

SELECT * INTO DirPartyTable_Temp FROM DirPartyTable


–Step 2. Deleting the Main table

DROP TABLE DirPartyTable


–Step 3. Your Main table will get recreated after DB Sync

—perform you DB synchronization from AOT


–Step 4. Import data from DirPartyTable_Temp to DirPartyTable


SELECT * FROM DirPartyTable_Temp

If you face any error here like fields count is not matching then check some new fields are added in to Main table create same fields in temp table and run the above code again.


–Step 5. Drop your temp table created at stage 1.

DROP TABLE DirPartyTable_Temp

perform you DB synchronization from AOT


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s