Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / BYOD - Deleted records...
Finance forum
Answered

BYOD - Deleted records in D365 are not reflected in Azure SQL DB

Posted on by

Hi all

I configured a data entity for a BYOD Export to an Azure SQL database. I enabled the specific entity for ChangeTracking and it also shows me that "Track Deletes" is enabled.

However, whenever I delete a record from the mentioned entity, this is not reflected in the Azure SQL database. The record will still be available there.

Did i misunderstood something? I expected the record to be deleted in the Azure database as well?

Your help is really appreciated

Thanks

Andreas

Categories:
  • AF83 Profile Picture
    AF83 on at
    RE: BYOD - Deleted records in D365 are not reflected in Azure SQL DB

    Hi Nikolaos

    Thanks, your explenation makes sense.

    Do you guys have any other workarounds for this beside a "Full push"?

    kind regards

    Andreas

  • Verified answer
    nmaenpaa Profile Picture
    nmaenpaa 101,148 on at
    RE: BYOD - Deleted records in D365 are not reflected in Azure SQL DB

    This same behavior most likely happens for all entities which are based on ValidTimeState tables.

    In general, if you query ValidTimeState tables in D365FO, you will get only the "active" records (ValidFrom <= today, ValidTo >= today). And this happens in the full push as well., just like you described.

    But the data deletion in BYODB incremental push is based on actual deletes in the table (which the SQL change tracking notices). In this case there is no delete, so nothing is deleted from BYODB, either.

    And it also means you can't use this feature to track address "deletes" (= disabling of address) with the out of the box capabilitites.

  • AF83 Profile Picture
    AF83 on at
    RE: BYOD - Deleted records in D365 are not reflected in Azure SQL DB

    i guys

    thanks for the fast answer

    @Nikolaos:

    If i run a "Full Push" the address will not be exported anymore (even if it is still available within the history view). So this tells me it should be deleted with the "incremental push".

    Just tried it with the entity "Entities for a processing group" and you're right...with this one it seems to be working....which is already kind of progress if i compare to PU15

    @Martin:

    No, ValiTo field is still set to "2154-12-31 23:59:59.000" as for all the addresses.

    If I go to D365 I can see the correct Expiration date on the deleted address within the history view...however, this date is not exported with the entity nor any other status information.....

    So bottom line, this leaves me with the issue that i'm not able to track address deletes (same issue might appear for other entities).

    kind regards

    Andreas

  • Martin Dráb Profile Picture
    Martin Dráb 225,490 Super User on at
    RE: BYOD - Deleted records in D365 are not reflected in Azure SQL DB

    The address record isn't deleted (otherwise you couldn't still see it in the history view", could you?); what has changed is the value of its ValidTo field.

  • nmaenpaa Profile Picture
    nmaenpaa 101,148 on at
    RE: BYOD - Deleted records in D365 are not reflected in Azure SQL DB

    Removing the address in D365FO doesn't actually delete the address from LogisticsPostalAddress table, so maybe it explains the behavior here. The address is just set as inactive (like you say, it can still be seen in the history view). If you try it with some simpler table / entity (not ValidTimeState controlled), are the deletes tracked correctly?

  • AF83 Profile Picture
    AF83 on at
    RE: D365 BYOD - Deleted records in D365 are not reflected in Azure SQL DB

    Hi Rahul

    I can not confirm your answer.

    Just tried it with Version 10 PU 24 and deletes are still not tracked as expected. Maybe I do have a wrong expectation, so I try to describe the whole process here:

    - I create a new address for a custome - > address gets exported as expected within the entity "Party postal address V2"
    - I remove the address in D365 (the address is now visible only within the "history view") -> when I run the BYOD Export Job, the address in they BYOD is not deleted or marked as deleted

    Can you guys please correct me if my assumption is wrong that deletes like I described them above should be tracked?

    kind regards and thanks

    Andreas

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: D365 BYOD - Deleted records in D365 are not reflected in Azure SQL DB

    with incremental push and 8.1 PU23 it is seen working.

    With full push anyway covered.

    Try with latest PU

  • AF83 Profile Picture
    AF83 on at
    RE: D365 BYOD - Deleted records in D365 are not reflected in Azure SQL DB

    So no other ideas?
    Here my example with a little bit more details on the configuration:

    2185.2.png

    2185.2.png

    Updates are loaded as expected on incremental basis into the Azure DB. However deletes in D365 are never really reflected in the Azure DB.

    What's your experience with deletes and BYOD? 

    Regarding Version & PU:

    4251.3.png

    your help is really appreciated

    kind regards

  • AF83 Profile Picture
    AF83 on at
    RE: D365 BYOD - Deleted records in D365 are not reflected in Azure SQL DB

    Hi Sukrut

    Yes I know. We do have PU 15.

    Any other ideas?

    Thanks for your help

    Andreas

  • Sukrut Parab Profile Picture
    Sukrut Parab 71,643 Moderator on at
    RE: D365 BYOD - Deleted records in D365 are not reflected in Azure SQL DB

    What PU you are on ?  Deletes are supported from PU 11 onwards.

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