Cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to see the change revision objects.

Valued Contributor
Valued Contributor

Dear Listers,

 

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 

 

1) 

DBCC useroptions --> Isolation levels was only Read Commited

 

2)

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 

 

Regards

Vilas

 

2 REPLIES 2

Re: Unable to see the change revision objects.

Solution Partner Honored Contributor Solution Partner Honored Contributor
Solution Partner Honored Contributor
Looks like something wasn't validating language and now it is. Those look like control characters in the image. But the user doesn't see a marshalling error or "Failed to parse XML document" error message? Tc uses Latin1_General_BIN character set (ISO-8859-1).

Work around:
ASCII control codes are not compliant with XML and you can use a replacement character by setting in tc_profilevars.bat:
set PM_STRIP_CNTRL_CHARS=32
(32 is Space in ascii)

Fix permanently:
This may work or may not depending if this is truly an invalid character issue.
1. You have to know your class and property name combinations from BMIDE.

2. Find the control characters using:
install -find_control_chars infodba infodba dba WorkspaceObject object_name
Note: in the above I'm searching class WSO and property object_name. You have to run the command multiple times using class\property combinations.
Output will look something like:
Selected option: Look for control characters in a given string attribute.
Started POM v1000.0.1 ...
in WorkspaceObject:object_name
12 strings contain a character 0x6
29 strings contain a character 0x7
17 strings contain a character 0x8
40 strings contain a character 0xb
44 strings contain a character 0xc
17 strings contain a character 0xf
16 strings contain a character 0x10
23 strings contain a character 0x11
6 strings contain a character 0x13
24 strings contain a character 0x14
9 strings contain a character 0x17
Install terminated successfully

3. Now identify a replacement character (hex). I used "". And fix the issue by running:
install -replace_control_chars -u=infodba -p=infodba -g=dba WorkspaceObject object_name 06 ""

As always, make a db backup before modify it. You can find the ascii/decimal/hex table on Google.

Randy Ellsworth, Teamcenter Architect, Applied CAx, LLC
NX 11 | SW 2016 | Creo 4 | TcUA 11.4
Evaluating: AW 3.4

Re: Unable to see the change revision objects.

Valued Contributor
Valued Contributor

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

 

Regards

Vilas