How to clean up data in business central

With the release of Business Central Wave 2 2021 aka BCV19 lot of new features has been added to make life easier of developer and/or customers.

To keep database performance always high and size of database in control we need to remove some data from database as part of maintenance .but after removing the data what if user would like to review the data again.

In new version Microsoft comes up with new extension called Data Archive.

The main purpose of this extension whenever you delete the records it will archive the records. With this extension archive data will be stored in JSON format in the extension. Media field is created for the storage of JSNO format (Data Archive Media Field)

Lets See how it works in reality

The archive data is stored in Tenant Media table which is not considered while calculating database size. If user would like to revisit some data then you might need to query Azure Cosmos database or you can export data in excel.

Hopefully this will help.

Next blog we will look into how to use the archive functions in AL code.

Till then stay tuned for more updates.


App Installation Permission Denied in Business Central

Yesterday we were installing PTE app on production environment and it throw an error as below.

We are juggled by seeing this message and thinking why it is showing an error message when we are uploading extension by using administrator login which is global administrator.

To overcome this error there is new permission set has been introduced in business central wave 1 2021


You need to assign the above permission to install the app as below.

Hopefully this will help

Stay tuned for more.