issue in synch in Ax 2012

(0) Share

Report

Posted on by Community Member

when i add field to salesline table i have below message and not apple to synch

after that i delete it but message worining appear and no synch

An action you have taken requires that one or more fields be dropped from the Microsoft Dynamics AX database. This can be caused by changes in the data dictionary such as deleting fields or disabling fields through configuration keys.

However, because the fields listed below contain data, you may want to
back up your database before the fields are deleted. This field and all data it contains for all companies will be deleted:

Salesline.field name

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Ajit 8,788 on at

Like (0)

Report
Copy link

Link copied!

Adding filed shouldn't cause any sync issue. What are columns you are seeing in the warning? And Is that error or warning?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

warning name column i add it

warning appear after add it and after delete it

Was this reply helpful? Yes No
kvnkk 800 on at

Like (0)

Report
Copy link

Link copied!

Before adding any new fields in to the base tables, just make sure that tables synchronized properly .

May be these wringing due to schema mismatch between AX and SQL.

- Adding new field will not cause for any loss of data.

Just try below things:-

Close and reopen the application

Clear cache Refresh Dictionary, data and element and do sync again

If you have more than one AOS instance try to restore, refresh and sync in other instances as well..

Was this reply helpful? Yes No
Suggested answer

Heinz Schweda 1,367 on at

Like (0)

Report
Copy link

Link copied!

When you delete a field from a table, it's absolutly OK that this warning appears. AX will tell you, that you are trying to delete a field from database, which may contains data. If you click [Next] in the synchronisation-dialog, the field (and it's data) will be removed from database.

What i don't understand: You told us that you created a field salesLine.name in your AX. But by default there is already a field named "name" in this table?

Was this reply helpful? Yes No