Sync error due to a view turned to a table

(0) Share

Report

Posted on by Community Member

Hi,

I can't Sync and I can't execute some actions because I have an SQL database error.

The problem is that I have the view DimensionAttributeValueSetItemView object like a Table, in the AOT (USR), but really this object is a view and I can't understood how it changed and convert in a table. I checked in SqlServer database this object is a view and in the SQLDICTIONARY table, the data are correct.

How I can to resolve this problem? How I can to change this object from table to view in the AOT?

Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

jaestevan 1,719 on at

Like (0)

Report
Copy link

Link copied!

Hi Iratxe,

Same problem has been issued previously, for instance, here (might be different object types but same problem at the end):

https://blogs.msdn.microsoft.com/axsupport/2014/05/23/ax-2012-a-tablemap-object-turns-to-be-a-table/

https://community.dynamics.com/ax/f/33/t/143042

https://community.dynamics.com/ax/f/33/t/118864

http://www.jaestevan.com/fixing-db-synchronization-problems-in-microsoft-dynamics-ax-2012-en/

Have you already tested the solutions/workarounds suggested here?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi,

I checked these solutions but my problem is only in the production AOT. I don't that the problem isn't in te database because in the SQLDICTIONARY table the data is correct. I excute the following sentence "select FLAGS from SQLDICTIONARY where name='DimensionAttributeValueSetItemview' and fieldid=0;" and the result is 1. I don't know how I can continue because I haven't got the ModelElement and ModelElementData tables.

Thanks.

Was this reply helpful? Yes No
Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

Hi Iratxe Lejarreta,

You have 2 different data bases in AX: DB with data and model store DB so probably you are looking for ModelElement table in a wrong data base. Usually model DB has name like <your DB Name>_model.

Was this reply helpful? Yes No