Applies to Product - Dynamics 365 Commerce
What’s happening?
Exporting an entity to BYOD is failing with an OLE DB error indicating unsupported data type conversion, particularly related to the "PrimaryAddressDescription" field.
Reason:
The failure occurs due to a data type mismatch when exporting the "PrimaryAddressDescription" field, which has been changed from string to NVARCHAR. Additionally, the BYOD staging table columns were initially set to not allow null values, which could cause issues with the data export.
Resolution:
- Ensure that the property "Mandatory" is set to "No" (allow null) on all columns in the entity staging tables in BYOD.
- Verify that the column sizes in both the source database tables and BYOD tables are the same (e.g., if the string size is 60 in the database table, ensure the BYOD table string size is also 60).
- Set the staging option to "No" in the entity data project to allow data to pass through the staging table rather than directly querying the entity view. Note that this may result in slower performance during the export process.
- If the issue persists, try exporting the data entity to a local machine and validate the values. If a column is missing or not updating properly, it indicates that data may be missing. Ensure that the data in the source system is valid before exporting.