Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. X

**Summary - Not recognizing latest revision as latest! 9.1 M060**

gkemner
7-Bedrock

**Summary - Not recognizing latest revision as latest! 9.1 M060**

Thanks to all that replied!! As most suggested I logged a call with PTC
and here was the solution. They said this issue can occur after an
upgrade, which we just did a couple weeks ago, somehow this gets messed
up during the upgrade process.



I did find that I had to run the command listed in Item #6 about 30-40
times in order for the table to repopulated fully. Basically if you
don't run that command enough times you will notice that the issue is
better but not completely solved, so just run it a bunch of time so be
safe.



1. Open Windchill shell.

2. Login to SQLPLUS from windchill shell only.

3. Take a backup of the table SeriesSortValue with the below mentioned
command.

: Create table SeriesSortValue_backup as select * from SeriesSortValue;

4. Delete all the rows from the SeriesSortValue table.

: delete from SeriesSortValue;

5. Now exit to SQLPLUS and come to Windchill shell.

6. Repopulate the table values by running the following command. (From
Windchill Shell)

: java wt.series.SeriesSortValuePopulater

(Note: Execute this command 2-3 times for repopulating the complete
values)

7. Stop all the servers.

8. Clear the Info-engine (<windchill>\tasks\codebase\com\infoengine)and
Tomcat cache.

9. Start all the servers and try to reproduce the issue.




0 REPLIES 0
Announcements


Top Tags