CustGroup table is not synchronizing...

(0) Share

Report

Posted on by Community Member

CustGroup table is not synchronizing...

We have imported some fields into CustGroup table as part of customization and from then the CustGroup table is not synchronizing. so deleted the imported changes and tried and its giving an error..

Cannot execute a data definition language command on ().
The SQL database has issued an error.

SQL statement: ALTER TABLE CUSTGROUP DROP COLUMN OVER15UNITS, SERVICECHARGE, UPTO15UNITS, UPTO5UNITS

Problems during SQL data dictionary synchronization.
The operation failed.

I have tried to delete the fields from SQL, but there are no custom fields in SQL dbo.CustGroup, tried AOT synchronise and Full Compilation and FULL CIL and even then its giving some errors, Also tried ForceDatabase Synchronisation and still no go. Tried deleting .Auc files and still no go. .. Please Help...

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

Take backup of your DB and do following

smcdax.blogspot.com/.../dynamics-ax-database-synchronization.html

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you for your valuable solution, it worked like a charm.....

Thanks...

Was this reply helpful? Yes No