cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are happy to announce the new Windchill Customization board! Learn more.

Pending Change icon (red triangle) still appears when there is no longer a pending change

dgraham-4
1-Newbie

Pending Change icon (red triangle) still appears when there is no longer a pending change

Anyone seen this before.

Pending change icon displays even though there is no pending change
objects association.
I queried our dB and found 137 such cases.
I know how to remove the icon but I though this behavior rather strange.
PTC has not been able to offer an explantation.

10.1 M010



David Graham
Windchill Administrator
Pro|ENGINEER Administrator
CAx Administrator


Emhart Glass Manufacturing Inc.
Emhart Glass Research Center
123 Great Pond Drive | Windsor, CT 06095 | USA
Telephone +1 (203) 376-3144 | Telefax +1 (860) 298 7397
Mobile +1 (203) 376-3144 |
2 REPLIES 2

David,
I saw the same thing in my 10.1 M010 system. I couldn't for the life of me find any pending changes that caused this. How did you remove the icon?

Patrick Williams | Engineering Systems | c: 616.947.2110
[cid:image001.jpg@01CE0931.FE8B42B0]

Patrick,

I found 137 WTDoc, 613 WTParts and 499 EPMDocs with this condition.
Therefore this had to be done with a few scripts. I'll try to be very
clear in the details of what I did.

First whether the icon appears or not is determined in the dB tables
WTDocument, WTPart and EPMDocument.

Run describe on WTDoc, WTPart or EPMDoc. All three have columns that
determine if the icon is displayed.
In the image below I point to "HASRESULTINGCHANGE" column.
Value for this column is either 0 or 1 (it is either a resulting item in a
Change Activity or it is not) I was only concerned with resulting items.
Affected Data would be a different column but I think you get the idea.

For the purpose this mail we will focus only on Resulting Items.


Sadly my SQL is not great therefore to solve at the dB level I did the
following.

I spooled the output of every WTDocument where HASRESULTINGCHANGE=1 to a
text file. We will call 1.txt

select ida2a2 from WTDocument where HASRESULTINGCHANGE=1;

I then wrote a Java script to read my spooled file and write an sql script
that finds ida3b5 from ChangeRecord2 where ida3b5=<the ida2a2=" from=" the=" <br="/>WTDocument>
A ChangeRecord2 is nothing more than a link that connects a Changable to a
Change Activity.
This would return all legitimate id number where HASRESULTINGCHANGE=1

select ida3b5 from ChangeRecord2 where ida3b5=<the ida2a2=" from=" the=" <br="/>WTDocument>;

I then spooled the output from my sql script to another text file. We will
call 2.txt

1.txt has all id number of WTDocs where HASRESULTINGCHANGE=1
2.txt has id numbers of all legitimate WTDoc where HASRESULTINGCHANGE=1

I wrote another Java method to compare the two files and output a second
sql script.

Any number that is in 1.txt that was not also in 2.txt needs to be
changed. When my method found such a number it wrote to the second sql
file
update WTDocument set HASRESULTINGCHANGE=0 where ida2a2= <the number=" that=" <br="/>was found>;

I then ran this second sql script and problem was gone.

Somewhat complicated but logical I think.

Let me know how you make out and feel free to call if you need any help.

David Graham
Windchill Administrator
Pro|ENGINEER Administrator
CAx Administrator


Emhart Glass Manufacturing Inc.
Emhart Glass Research Center
123 Great Pond Drive | Windsor, CT 06095 | USA
Telephone +1 (203) 376-3144 | Telefax +1 (860) 298 7397
Mobile +1 (203) 376-3144 | http://www.emhartglass.com



Top Tags