Views:

Applies to Product -Dynamics 365 Commerce


What’s happening?
How to reduce the size of the Retail and Credit Card Transactions in the database, specifically needing to retain only a limited amount of transaction data for development and testing purposes.


Reason:
The underlying cause of this is related to the configuration of retention periods for transaction data and the execution of cleanup routines.


Resolution:

  1. For reducing the size of the databases, it is recommended to keep only one month of retail transaction data. This can be achieved by executing the Purge Commerce Sales transactions operation.
  2. For the Credit Transaction database, ensure that the archive Credit Card Transaction is set up correctly as per the documentation provided. The retention period should be configured to 90 days. If the batch job runs without errors but the table size does not change, try reducing the retention period. 
  3. It may be necessary to run the cleanup jobs multiple times if the initial run does not yield the expected results