Applies to Product - Dynamics 365 Supply Chain Management
What’s happening?
When attempting to export the data entity “work template V3” through the Data management, the exported file does not include the queries present in the work templates. This results in the need for manual modifications to the queries after re-importing the files.
When attempting to export the data entity “work template V3” through the Data management, the exported file does not include the queries present in the work templates. This results in the need for manual modifications to the queries after re-importing the files.
Reason:
This arises from a documented limitation in the Data management framework (DMF) when exporting to certain file formats, specifically a 255-character limit for string fields. This limitation is a known SSIS (SQL Server Integration Services) constraint, which causes data with more than 255 characters to be truncated during export.
This arises from a documented limitation in the Data management framework (DMF) when exporting to certain file formats, specifically a 255-character limit for string fields. This limitation is a known SSIS (SQL Server Integration Services) constraint, which causes data with more than 255 characters to be truncated during export.
Resolution:
To resolve this of missing queries during export, follow these steps: 1. Use the Source/Target data format set to XML-Attribute when importing/exporting the data entity “work template V3.” This format allows the full query to be exported without truncation. 2. Avoid using file formats that impose the 255-character limit, such as the Excel format. Instead, consider using XML-Attribute or CSV format, but be cautious with CSV due to potential character interference in the query. 3. Test the export with the XML-Attribute format to ensure that the field TEMPLATEQUERYJSON contains the complete query as expected.
To resolve this of missing queries during export, follow these steps: 1. Use the Source/Target data format set to XML-Attribute when importing/exporting the data entity “work template V3.” This format allows the full query to be exported without truncation. 2. Avoid using file formats that impose the 255-character limit, such as the Excel format. Instead, consider using XML-Attribute or CSV format, but be cautious with CSV due to potential character interference in the query. 3. Test the export with the XML-Attribute format to ensure that the field TEMPLATEQUERYJSON contains the complete query as expected.