Views:

Applies to Product - Dynamics 365 Supply Chain Management


What’s happening?

  • Automatic duplication of product attributes occurs in the Microsoft Dynamics system without user input, affecting data integrity and causing confusion during product updates and reporting.
  • The Product Attributes Entity V3 FullPush is not working as expected, with jobs ending without any data being found.
     
Reason:
  • The duplication of product attributes may be due to data corruption caused by existing duplicate records.
  • The FullPush issue may be related to memory constraints or configuration errors, leading to incomplete data exports during incremental updates.
     
Resolution:
  • For the automatic duplication issue:
  • Investigate the database for duplicate records, particularly focusing on the affected product attributes.
  • Use SQL scripts to detect and delete duplicate records. Sample SQL commands include: ```sql / Searching for Duplicates / SELECT attribute, product, MAX(RecId) AS Max_EcoResAttributeValueRecId, COUNT() AS NumberOfDuplicates FROM ecoresproductattributevalue GROUP BY attribute, product HAVING COUNT() > 1 ORDER BY product;
/ Deleting duplicates / DELETE FROM ecoresattributevalue WHERE recid IN (...); ``` 3. Confirm that the issue has been resolved after executing the scripts.
  • For the FullPush issue:
  • Ensure that the job is executed during off-peak hours to mitigate memory issues.
  • If the job fails, stop the current batch execution and delete the stopped batch.
  • Run a new batch and provide the new batch ID and its status.
  • If the incremental push continues to fail, consider running the job in full push mode to ensure all data is captured.
  • Provide session IDs and any relevant details to the support team for further investigation if issues persist.
  • If the issue remains unresolved, escalate the case to the product team for deeper analysis and support.