NX 12 | SW 2017 | Creo 4 | TcUA 11.4
As a best practice, we hahve already established a rule not to change any site preferences in PROD when users are connected as I have seen similar issue earlier. Anyway, we are working with GTAC where I can see similar issues being raised. Will update once we get anything concrete.
I would suggest to disable shared memory for site preferences. We had the same problem in Teamcenter 8 & 10 and disabling it solved it for us
Please see SFB-Teamcenter-8568..
OK..i have an update on this from GTAC and it looks to make sense in theory. We have put the fix and have kept in monitoring mode..thought can share here for the benefit of others.
It seems this issue has been reported by couple of other customers and the root cause seems to be bcause of mismatch of encoding between RAC--tcserver--DB. All these needs to be in sync - else there might be some characters not recognised by the other encoding set and this seems to be corrupting the preferences.
Below are the things you will need to check to see if your charcter encoding is aligned between these 3 layes - client--tcserver--db.
1. TC_CHARACTER_ENCODING (client level encoding)
2. TC_XML_ENCODING (tcserver level encoding)
3. NLS_character_set (DB paramater)
From the db side, you will need to query the pdata and pdata_0 and check the clob values and see if the encoding levels in each row are same for all rows. In case you find multiple encoding, you will need to correct it with the help of GTAC.