We are seeing a very strange behavior after the upgrade(10.1.7--> 114.0.4). The Revision of the change objects have disappeared. When we search for the revision and do an where used on it gives an error message and in the syslog we see the statements as attached.
This is on MSSQL Server and Windows Platform I have the done the following
DBCC useroptions --> Isolation levels was only Read Commited
SELECT * FROM sys.dm_exec_sessions WHERE database_id = db_id('tcPROD')
ALTER DATABASE tcPROD SET READ_COMMITTED_SNAPSHOT ON WITH ROLLBACK IMMEDIATE
Checked teh DBCC useroptions and it is changed to Read Commited Snapshot.
The issues do not go I see that there are strange "Garbled" alphabets as in the attached snapshot not sure what they are....
Any advise what could have gone wrong and we can recover from this.
The struck out red is realted to the company
NX 11 | SW 2016 | Creo 4 | TcUA 11.4
Evaluating: AW 3.4
This is a bug in the 11.4.04 and we had an eloborate session with Siemens PLM and they are providing a CSP for this.
This is related to the pom_timestamp which is defaulted to 96 hours and that has corrupted the revisions in the workflow.
We had to be on call with the SPLM for almost two days to get this query and tested this on the dev environment with the prod data( did a db refresh of prod in dev) ....after the query is applied it started working.
My experience is better to move to 11.6 patch