Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Compare error when imp...
Microsoft Dynamics AX (Archived)

Compare error when importing any table

(0) ShareShare
ReportReport
Posted on by Mihkel 10

Hi!

Scenario is this:

I create a new table in AOT and add 1 string field.

Then export the table to xpo file.

And after that import the same xpo I just exported.

Now when i hit Compare button on import form I get two errors:

Table , field group AutoSummary: method modelGroupId does not exist

Table , field group AutoSummary: method itemGroupId does not exist

And this is the case with all tables. I get the same two errors.

I have already tried compiling the application, did not help.

What could be the reason for this?

Is it some inconsistency in model database?

How to fix it?

Thanks for any clue!

*This post is locked for comments

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Compare error when importing any table

    Hi Mihkel,

    As mentioned above. Try to avoid moving customizations to production using xpo files. Have you already tried to do a full X++ compilation and full CIL build? Then restart the AOS and synchronize the database. If this doesn't help, there might be some references really messed up somehow.

  • nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: Compare error when importing any table

    You need to ask the developers how they moved these changes. Was it by xpo delivery, models or modelstore? At least with modelstore delivery it is possible to break your environment if you decide to ignore element id conflicts. On the other hand, when set up and executed properly, modelstore delivery is the safest (and also recommended by Microsoft) process for production deliveries. But if the source environment has different element id values, you should never use a modelstore delivery.

    I wonder how you had 4 different developers each moving code to prod - that doesn't sound like a proper prod delivery process.

  • Mihkel Profile Picture
    Mihkel 10 on at
    RE: Compare error when importing any table

    The thing is that we had 4 different developers moving modifications to production a day before this problem started.

    And none of them admit something going wrong :(

  • nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: Compare error when importing any table

    What changes were done just before the environment started to act like this? Something must have caused it and you need to figure out what was done.

    Seems your modelstore and/or object ids are somehow messed up.

  • Mihkel Profile Picture
    Mihkel 10 on at
    RE: Compare error when importing any table

    Wea actually do not create tables directly in production.

    We already made a full copy of the production environment and tested there

    and the same problem exists in the copy environment.

    What actions could we try to fix the problem?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Compare error when importing any table

    Hi Mihkel,

    If this is happening in Production... why are you creating tables in the production environment directly and why are you working with xpo files instead of model store/model files?

    Have you also tried to restore the production databases (business and model) in a test environment to see if you can then still reproduce it?

  • Mihkel Profile Picture
    Mihkel 10 on at
    RE: Compare error when importing any table

    The problem occurs only in one environment - the production environment. In our development environment everything is fine.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Compare error when importing any table

    Can you reproduce the same issue in other environments? Or is it happening on just this single environment?

  • Mihkel Profile Picture
    Mihkel 10 on at
    RE: Compare error when importing any table

    There are no custom field groups, no methods, no relations, only one field.

    Even if i create a new table and create no fields on anything. And then export it and import the same xpo i just created then i get the same error.

    And the situation is the same when i export other tables. 

    InventTable has the methods that are mentioned in the error message but i do not try to export-import-compare InventTable but a new table.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Compare error when importing any table

    Can you tell more about the table contents? Especially if the current AOT object contains these fields within the field group and if the method do exist or not? Did you copy an existing table to create your custom one?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans