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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / AxDw not refreshing
Finance | Project Operations, Human Resources, ...
Answered

AxDw not refreshing

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I have created an AzureDevBox on LCS and copied the UAT database to it, the environment is working fine, synchronized and when I check SQL I can see the new DB, I changed connection in web.config but when I access AxdW data warehouse, I can see the entities are empty, I tried modifying the dbo.sysserverconfig by adding the batch record in dbo.batchserverconfig

but seems still the AxDw tables remain empty. any idea how to refresh the data warehouse ?

Thank you

I have the same question (0)
  • Suggested answer
    Adria Ariste Profile Picture
    Adria Ariste User Group Leader on at

    Hi,

    you should be able to refresh the Entity Store on your dev box going to System administration > Set up > Entity store and doing it manually or enabling the automatic refresh. Isn't that working for you?

    Adrià Ariste - Senior technical consultant @ Axazure - Read my blog!

  • Community Member Profile Picture
    Community Member on at

    Hi Adria,

    That is the idea, I refresh it manually and I have it set for automatic and I see the message, that batch job is scheduled to reset the data, but nothing happen, tables in AxDW remain empty.

    I am sure somewhere a connection is missing ,the new database imported at some point is not configured to refresh the data warehouse, maybe, I guess,, not sure.

    thanks

  • Suggested answer
    Adria Ariste Profile Picture
    Adria Ariste User Group Leader on at

    Is the batch service started? And are the batch servers on D365 selected undes System Admin -> Setup -> Batch groups tab Batch servers.

    Adrià Ariste - Senior technical consultant @ Axazure - Read my blog!

  • Community Member Profile Picture
    Community Member on at

    Yes , all exist, I just managed to refresh it by manually changing the status of a previously created job FULL RESET in batch job.

    have no idea why the system didn't create the job after I clicked refresh, as I received a message that it is scheduled, but it was never created

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    I faced an issue where my entity store - aggregate measure were not refreshing, I clicked on the refresh button (system admin - entity store - aggregate measures), but it doesn't refresh.

    I go to Batch Jobs and find the batch job name 'Full reset' and change its status to execution. This batch job refreshes the entity store so once the batch job is in execution, the entity store is refreshed.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 522 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans