Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Upgrading Shared table...
Microsoft Dynamics AX (Archived)

Upgrading Shared tables form Ax 4.0 to Ax 2012

(0) ShareShare
ReportReport
Posted on by Tina Vyf

I am busy running through the Preprocessing upgrade check to upgrade an AX 4.0 system to Ax 2012. I am trying to solve all the upgrade readiness issues.

The one error I received is: readiness : Detect shared tables.

Error: Some source tables are shared table, preprocessing script should be modified to follow the correct pattern.
Resolution: Look at preprocessing scripts for CustTable table within the ReleaseUpdateTransformDB40_Basic class.
Details:
Script ReleaseUpdateTransformDB40_Basic.validatesmmBusRelTableRecordsWithoutName has a shared source table SMMBUSRELTABLE.
Script ReleaseUpdateTransformDB40_Basic.validateBusRelCustAccount has a shared source table SMMBUSRELTABLE.
Script ReleaseUpdateTransformDB40_Basic.validateBusRelVendAccount has a shared source table SMMBUSRELTABLE.
Script ReleaseUpdateTransformDB40_Basic.validateBusRelCustAndVendAccount has a shared source table SMMBUSRELTABLE.
Script ReleaseUpdateTransformDB40_Basic.validateContactPersonRecordsWithoutName has a shared source table CONTACTPERSON.
Script ReleaseUpdateTransformDB40_Basic.validateAddressStateReferenceData has a shared source table ADDRESSSTATE.
Script ReleaseUpdateTransformDB40_Basic.validateAddressCountyReferenceData has a shared source table ADDRESSCOUNTY.
Script ReleaseUpdateTransformDB40_Basic.validateAddressZipCode has a shared source table ADDRESSZIPCODE.
Script ReleaseUpdateTransformDB40_Basic.validateAddressZipCodeReferenceData has a shared source table ADDRESSZIPCODE.

I am not sure what to do with this. The resolution says to look at the class and to modify it to follow the correct pattern, but I am not sure what the pattern should be and what to look for.

Does anyone have any ideas?

(I have already added the shared tables to the Table collections, and reran the update readiness script, but I am still getting this error.)

*This post is locked for comments

  • Verified answer
    Kevin Kidder Profile Picture
    Kevin Kidder on at
    RE: Upgrading Shared tables form Ax 4.0 to Ax 2012

    Tina,

    Because the tables mentioned are all address related tables, you should be able to ignore these errors because the AX upgrade scripts are already written to transform the address data into the new shared table structure that addresses in Dynamics AX 2012 use. Internally we have a list of common shared tables that can be ignored, and unfortunately we haven't updated that script to include the address tables that you mentioned. There isn't a way to keep them from showing up in the validation results, but you can safely ignore those validation errors.

    You are correct that you do not want to change the tables in any way to SavePerCompany=No as that creates completely different behavior.

  • Tina Vyf Profile Picture
    Tina Vyf on at
    RE: Upgrading Shared tables form Ax 4.0 to Ax 2012

    Hi Nitesh,

    Thanks for your answer. I just read this post on the SaveDataPerCompany property:

    community.dynamics.com/.../88784.aspx

    Apparently it's never a good idea to change the setting. It's quite a big change as it removes the DataAreaId field from the table. Since quite a lot of functions and reports use DataAreaId, removing the field from the table can cause loads of things to go wrong.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Upgrading Shared tables form Ax 4.0 to Ax 2012

    in AX 2012 Table sharing is not recommended to share using Table collections,

    Table collection is used to share tables using Virtual Company...

    Consider setting the property -SaveDataPerCompany of table - 'NO'

    Please verify and update us with your finding

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Upgrading Shared tables form Ax 4.0 to Ax 2012

    Hi Tina,

    I am not technical to help on the actual error but I wanted to warn you that it's not recommended to use shared tables for customers in AX 2012 using the virtual tables and table collection. Microsoft will eventually share the cust and vend tables using the new 2012 architecture and they don't recommend to keep virtual tables as they might stop maintaining this feature.

    If it's mandatory for you to share customers then you might want to think about writing your own code to automatically create or update the customer in all your entities.

    Thanks,
    Caroline.

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