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, ... / No records exported du...
Finance | Project Operations, Human Resources, ...
Suggested answer

No records exported during first time incremental export BYOD

(0) ShareShare
ReportReport
Posted on by agneum 150

When I change the tracking in the export project to Incremental, I get the following text:


"If this is the first time an export will be done for the entity X after change tracking was enabled, then the first incremental export will be a full export. It is recommended to not have any data in the target tables for the entity X"


My question is, what exactly triggers this "first time full export"?  NOTHING I do works, which leaves me to believe this is some kind of a bug.


My process:


I disabled change tracking on all the entities.
Then I dropped the entities.
Then I published them again.
Then I enabled change tracking for primary table.
Then I went to the export project with incremental enabled and ran "export now" option.
Result = 0 records exported.


Whatever I do, it simply doesn't work as intended.

The workaround for now is to have to export jobs, (one for full and one for incremental), though I've noticed that during the first push some entities show an error until you run the job again. 

At times like this I wonder if it wouldn't be easier to give customers a SELECT grant on the production AOS so that customers can read directly from the database as with AX09.... either the custom solution works, or it is a pain for customers, but I digress...

  • Suggested answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,014 on at
    RE: No records exported during first time incremental export BYOD

    additionally could validate your change trackings in this table

    AIFSQLCTTRIGGERS

  • WillWU Profile Picture
    WillWU 22,352 on at
    RE: No records exported during first time incremental export BYOD

    Hi agneum,

    The change tracking in D365 is essentially the same as that in SQL server.

    From your process, you disabled it first and then you enabled it without any data changing.

    In fact, the data in the database has not changed, change tracking was not triggered either.

    And records of Change tracking record still exists, Disabling or enabling does not affect their records in the database.

    To query the change data in the Azure SQL Server ,you can write T-SQL like this:

    DECLARE @changeTrackingMinimumVersion INT = CHANGE_TRACKING_MIN_VALID_VERSION(OBJECT_ID('axdb.ax.custtable'));
SELECT *
FROM CHANGETABLE(CHANGES [axdb].[ax].[custtable], @changeTrackingMinimumVersion) AS AxDB;

    You can refer to the following Doc to read more about change tracking:

    https://docs.microsoft.com/en-us/sql/relational-databases/track-changes/work-with-change-tracking-sql-server?view=sql-server-ver15.

    https://docs.microsoft.com/en-us/sql/relational-databases/system-functions/changetable-transact-sql?view=sql-server-ver15

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,999 Super User 2025 Season 1 on at
    RE: No records exported during first time incremental export BYOD

    Hi,

    You are correct in your understanding: docs.microsoft.com/.../export-entities-to-your-own-database

    When you deleted a change tracking and recreated it, then there is still history on the data project and also records will probably still exist in your BYOD database. That might be the reason why it is not doing the full push automatically. Can you verify if the tables in BYOD still had data?

  • agneum Profile Picture
    agneum 150 on at
    RE: No records exported during first time incremental export BYOD

    Well, according to the messages from within D365, it states that after an entity has change tracking enabled, the first export (regardless if it's incremental or full) will be a full push. I just want to understand why it doesn't do a full push the first time, hence I recreated everything from scratch.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,999 Super User 2025 Season 1 on at
    RE: No records exported during first time incremental export BYOD

    Hi Agneum,

    What is your exact question here? The first push needs to be a full push. Thereafter you can do the incremental updates. The reason is that change tracking will mark new created and updated records which will be picked up by the incremental push. When you enable it, the system is not aware what had been exported before or not. That is the reason why you need to do an initial full push.

    What is the reason that you disabled the change tracking? And recreated everything from scratch?

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,999 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,831 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans