We’re on Umbraco v. 7.4.3
Every once in a while we can end up in a state where the cmsPropertyData table wipes away data for no apparent reason. The data can still exist in the XML cache even though it’s missing in the database, so the site itself will look fine, but in the back office, the data will be missing. If a user saves the page while in this state, the null value will overrule the data in the cache and wipe out whatever was in that property from the cache as well.
Other times, when trying to enter a value into a previously empty property, the user can put data in, hit save, and the data will not be saved to the cmsPropertyData table at all.
We have not been able to reliably reproduce the bug yet, but from what we have been able to tell, it’s not a failing on the side of the server or database. We use SQL 2014 Enterprise and IIS 8.5.
I’ve seen similar issues reported on the forum, but they seem to have been blamed on IIS Express and/or SQL CE, neither of which we use.
Does anyone have any insight into this issue, why it might be happening, or any workarounds? Please note that we are currently not in a place where we can do a full Umbraco upgrade soon.
This is a companion discussion topic for the original entry at https://our.umbraco.com/forum/87357-data-disappearing-from-cmspropertydata-table