We are experiencing a strange situation here.
I have a database with multiple replicas accross our network. This database also has a template that is replicated.
The database has three missing views, because there are deletions stubs. The cause of the deletion stubs is still unknown.
Yesterday, the administrator tried to replace the design on one of our servers and failed to do so. I was skeptical, so I created a local replica without the ACL, so I granted myself administrator access to my local database, while I have Editor access on the server.
I did replace the design, and the missing views were correctly replaced, the deletion stubs became design elements. Then I replicated with my server, because I wanted to see how the server would react to the presence of the design elements. To my surprise, the design elements were replicated and the server was up to date, with no deletion stubs.
Then I checked on some other servers after some time, and I saw that the three missing views were appearing everywhere.
This morning, I checked the servers. The deletion stubs are back and the three views are missing again. After some verifications, one server decided this night that the deletion stub was stronger than the design element. We seem to have found the origin and we replaced the design. For now we are waiting to see if there won’t be another server hiding in a corner that won’t force the deletion stub back into our production network (we have around 1500 servers…)
My questions are:
1 - Why did the replication between my machine and the server push the design element on the server while I was only granted Editor access?
[Edit] This is possible due to an ACL checkbox granting the right to design public views to editor access. Solution: remove the checkbox. [/Edit]
2 - How does the replication decide which is stronger; the deletion stub or the design element?
[Edit] I still don’t know the exact answer. However, we found out that one of our server had an older template and that the nightly ‘load design’ created the deletion stub - this template didn’t have the view. Replicating the new template and applying it on this server solved the problem. [/Edit]
3 - Why did my administrator fail to replace the design yesterday while he completed this task with success this morning?
[Edit] I’m still under the strong impression that he did some mistake because he sounded tired when I called him. [/Edit]
Thanks