Applies to Product – Dynamics 365 Supply Chain Management
What’s happening?
The customer is experiencing issues related to the change in address format and the functionality of SYSROWVERSION in the database.
Reason:
This with SYSROWVERSION not working as expected can occur when the AxTable metadata undergoes two specific changes simultaneously: 1. Changing DataSharingType to None (from Single/Duplicate). 2. Setting AllowRowVersionChangeTracking to Yes (or any other metadata change that adds a new column to the AxTable).
When DataSharingType is set to None, DBSync skips recreating the sharing view for the table, which results in SYSROWVERSION not being added to it. Consequently, during data entity view sync, the entity that uses this sharing view as a data source fails to retrieve SYSROWVERSION from it. Additionally, database logging was not configured on the table, which is necessary for tracking changes.
Resolution:
To resolve this, it is recommended to: - Configure database logging on the affected table to monitor and track changes effectively. - Review the AxTable metadata to ensure that the DataSharingType and AllowRowVersionChangeTracking settings are correctly configured to avoid issues with SYSROWVERSION.
For further reference, consult the documentation on configuring database logging.