Many problems with materialization are due to incorrect or missing permissions in primary or replicate databases.