Materialization Retention - Failed to load preview

I have an empty dataset on which I have created an ontology object that has a materialisation table, which is modified with actions on workshops. This materialisation table is used in several transforms in a pipeline in code repository. The materialisation table occasionally has the following error:
image

causing several transforms in the pipeline to fail.
If I manually rebuild the materialisation table like this:
Screenshot 2024-09-30 110618

the problem is solved, but I would like to prevent it from happening so often and creating problems for end users using the app.