Answered

mixed up AOT

(0) Share

Report

Posted on by CRSW

567

In our dev system we have a mismatch in the AOT. There is a Table in the AOT names TaxTransDetail_BE which should be a View and is a View on the SQL server.

How can this happen and more important how can I fix this?

Best regards

Chris

Categories:

Development / Customization / SDK

All responses (7)

Answers (1)

Verified answer

CRSW 567 on at

Like (0)

Report

mixed up AOT

Thx to all I just decided to do a copy from prod to fix everything(seems to be the fastest way)
CRSW 567 on at

Like (1)

Report

mixed up AOT

Hi Andre

I am pretty sure nothing has been done because normally it's me doing this or one other developer. And he didn't do anything eather.

To stop discussion I will take DB from Prod to fix this. seems to be the fastest way

Thx
André Arnaud de Cal... 290,246 Super User 2024 Season 2 on at

Like (0)

Report

mixed up AOT

Hi Chris,

It would be very hard now to guide you further. At least, something must have been changed, but you are not aware of it. For me, working with AX 2012 is too long ago to remember every single detail. PS. Did you already try a full compilation as I suggested in my first reply?
CRSW 567 on at

Like (0)

Report

mixed up AOT

there was no DB movement since at least 1 year. I checked the IDs in Modelstore Dev and Test. they are identical. because it is a standard object, never changed I didn't suppose anything else
André Arnaud de Cal... 290,246 Super User 2024 Season 2 on at

Like (0)

Report

mixed up AOT

Hi Chris,

When reading your last reply, it may be the case that a database movement was performed from e.g. prod to this development environment. In case this move was done without moving the model store as well, there can be differences in object numbers that can cause this behavior. Can you check if there was indeed a database movement action?
CRSW 567 on at

Like (0)

Report

mixed up AOT

Hi

Yes the system worked before. I don't know what happend to it. Its a standard object still in the standard "Layer".

It just turned from view to table

In Test and Prod System it is fine. only in dev not

CIL and DB sync failes because of this object.

First pic. Not correct (Devsystem), second pic correct Test system
André Arnaud de Cal... 290,246 Super User 2024 Season 2 on at

Like (0)

Report

mixed up AOT

Hi Chris,

Can you provide some more information? Do you know what happened to this environment? Did it work before?

Possibly add some screenshots to show what you mean by "should be a view"? Have you tried a full X++ compilation and CIL build? Then there after, you can run a full database sync and check if it solves the issue.

mixed up AOT

Helpful resources

News and Announcements

Quick Links

Dynamics 365 Community Update – Sep 9th

Announcing Our 2024 Season 2 Super Users!

Community Spotlight for September 2024

more Community News

Leaderboard

Featured topics

Product updates

mixed up AOT

Helpful resources

News and Announcements

Quick Links

Dynamics 365 Community Update – Sep 9th

Announcing Our 2024 Season 2 Super Users!

Community Spotlight for September 2024

more Community News

Subscribe to

Leaderboard

Featured topics

Product updates