Media on temporary tables

Dynamics 365 ERP - Development

The article discusses the benefits of using Media instead of BLOB in Microsoft business applications like Dynamics 365.
The author warns about the risk of unreferenced data when working with Media or MediaSet data types in Tenant Media and Tenant Media Set system tables.
Microsoft introduced the FindOrphans() procedure on Media and MediaSet objects to identify unreferenced Media/MediaSet records.
The Data Administration module within the System app helps in cleaning up unreferenced Media data, including the option to schedule a cleanup task.
The article demonstrates a potential issue with using Media fields in temporary tables, leading to the generation of Orphan Media.
The author highlights three occurrences of using Media in temp tables in the Base App, cautioning about potential Orphan Media issues.
While using Media instead of BLOB has benefits, it is essential to be cautious about unreferenced data in system tables and consider implementing Data Cleanup procedures.
The article emphasizes the importance of being careful when working with Media data types, especially in temporary tables, and suggests alternatives like using BLOB fields or implementing cleanup procedures.

Registered users can view the full text for FREE!