web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / SQL dictionary table c...
Microsoft Dynamics AX (Archived)

SQL dictionary table count differs, in two different AX Servers (AX 2009)

(0) ShareShare
ReportReport
Posted on by karthickarden 135

 Hi all,

I have installed Two AX Server in two different machines with the same configuration.

After installed , I have checked the SQLdictionary table in both AX Servers database and the table count differs in both servers. I'm using the following query "select count(*) from SQLDICTIONARY where FIELDID=0".

The following table count is getting both AX servers.,

First AX Server       -  1569

Second AX Server  -    2473

Can anyone tell how can I know the which one is correct ?

In the newly installed AX Server how much of table count will be in SQLDictionary table by default?

Thanks,

Karthick.M

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    A.Prasanna Profile Picture
    A.Prasanna 8,225 on at

    Check Followings ,

    1.Whether you loaded same license to both environments (Because it's AX2009)

    2.Check and compare Configuration Keys on Both Environment

    3.If you have Customization's Have you imported all the objects in to both of environments

    run Following Job to get list of tables and Compare

    static void ListOfTables(Args _args)

    {

       UtilElements        localEelmet;

       UtilEntryLevel      LayerName = UtilEntryLevel::usr;

       TreeNode            treeNode;

       ;

       while select localEelmet

           where localEelmet.utilLevel == LayerName

               && localEelmet.recordType == UtilElementType::Table

       {

           treeNode = xUtilElements::getNodeInTree(xUtilElements::parentElement(localEelmet));

           info(strFmt("TableId: %1 ; Name: %2",localEelmet.TableId,localEelmet.name));

       }

    }

    Thanks & Regards,

    Amith Prasanna  

  • karthickarden Profile Picture
    karthickarden 135 on at

    Hi Amith,

    Thanks for your response.

    Please find the answers inline,

    1.Whether you loaded same license to both environments (Because it's AX2009)  -Yes

    2.Check and compare Configuration Keys on Both Environment  -  Yes , Configuration Key count is 223 in both Environment.

    3.If you have Customization's Have you imported all the objects in to both of environments - There is no customization in both servers.

  • Verified answer
    A.Prasanna Profile Picture
    A.Prasanna 8,225 on at

    by "Check and compare Configuration Keys on Both Environment" i meant check whether enabled disabled keys are same on both environment not the Configuration key count.

    If you disable configuration key it will drop tables relevant to that Configuration key.and if you enable it will add relevant table  while synchronizing.

    Thanks & Regards,

    Amith Prasanna

  • karthickarden Profile Picture
    karthickarden 135 on at

    Amith,

    Thanks for valuable solution. I got it.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 26

#2
imran ul haq Profile Picture

imran ul haq 8

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 4 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans