mixed up AOT

Like (0) Share

Report

Posted on 1 Feb 2024 14:38:04 by CRSW

619

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

All responses (7)

Answers (1)

Verified answer

CRSW 619 on 09 Feb 2024 at 06:13:20

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 619 on 06 Feb 2024 at 06:16:28

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... 293,289 Super User 2025 Season 1 on 04 Feb 2024 at 10:57:13

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 619 on 04 Feb 2024 at 07:27:32

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... 293,289 Super User 2025 Season 1 on 03 Feb 2024 at 12:03:55

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 619 on 02 Feb 2024 at 01:19:35

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... 293,289 Super User 2025 Season 1 on 01 Feb 2024 at 22:23:24

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.

Community site session details

mixed up AOT

Helpful resources

News and Announcements

Quick Links

Daivat Vartak – Community Spotlight

Announcing Our 2025 Season 1 Super Users!

Kudos to the February Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

mixed up AOT

Helpful resources

News and Announcements

Quick Links

Daivat Vartak – Community Spotlight

Announcing Our 2025 Season 1 Super Users!

Kudos to the February Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates