Synchronize failed due to indexes

Finance and Operations/AX Technical Forum
1

Hi everyone,

I Deleted one field from my table indexes due to my requirement…now the table is not synchronizing and not even my data in that table itz giving me any error like this.,

"Cannot edit a record in Table (MyTabke).
You are trying to operate on one record, but more records are affected. Check indexes, run database synchronize, or equivalent"…plz help

with regards

hari

2

HI,

sorry i didn’t get .did u deleted the filed in the table or in the index? if u deleted in the table then delete in the index also.

3

Hi

I deleted the field only in indexes

4

hi,

in that table u have any data? when ur working with indexes for any chages ,should be the table is empty.otherwise the error will come

5

Hi,

Is this DAX 2009? When you try to synchronize, what error do you get? You may have to check error logs in Event viewer of both AOS and SQL Server.

6

Does it is an unique index? I think deleting the field is resulting in unique index violation.

7

Hi,

Yes it is an unique index…and resulting in unique index violation ,do u have an solution for that.

with regards

hari

8

Try to find out what values are duplicate and manually change the values so it’s not duplicate anymore.

You can also change the index in AX and make it contain a new column to make it unique (but i prefer the first solution)

9

If there are no tables related on this field, then this option is worth investigating. But if there are table relations, this will cause data integrity problems.

10

Hi

My table is related to two more tables,what shall i do…?

with regards,

hari