Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

not responding when i query about this table

Posted on by 2,016

Greeting everyone 

when i try to get query of this table DimensionAttributeValueCombination

static void Job24(Args _args)
{
    DimensionAttributeValueCombination   dimensionAttributeValueCombination;

    while select * from dimensionAttributeValueCombination 
    {
        info(strFmt("%1",dimensionAttributeValueCombination.DisplayValue));
    }
}

it's not responding

this table doesn't have customization 

also i did deleted and sync that table but still make ax2012 not responding for ever

also i try to add parameter even that make it  not responding for ever too

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,148 on at
    RE: not responding when i query about this table

    What exactly are you trying to achieve? Clearly this is just a job to list all DisplayValues but what is your business requirement?

    I think the slowest thing in your code is that you try to print so many entries to the infolog.

  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 225,490 Super User on at
    RE: not responding when i query about this table

    This table usually has many records, therefore iterating all of them may take a while. Especially when you run code on client - consider doing it on server.

    Also, you fetch all fields from database and then ignore all of them except of DisplayValue. Selecting just DisplayValue will improve performance.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans