1. Home
  2. Support
Article - CS364546

"Find in Structure" is slow in Product Structure Browser in Windchill PDMLink

Modified: 14-Apr-2026   


Applies To

  • Windchill PDMLink 12.0 to 13.1

Description

  • Structure Tab > Search keeps loading indefinitely for certain large structure
  • Windchill UI spins and becomes unresponsive until the proxy error pop-up appears
  • Unable to perform search in Part Structure Browser (PSB); the searching icon keeps spinning. Error in logs:
  • com.ptc.windchill.csm.util.CLFAccessUtils <username> - Unable to fetch OOTB Classification Administrators group. No users will have access to CLF admin
  • Find in Structure is slow in Product Structure Browser 
    • The View has soft attributes/Instance Based Attribute (IBA) configured
  • Getting a 502 Proxy error while they searching on a BOM structure
  • Can not search out part by number in PSB, it keeps loading
  • Several locks in database observed creating a huge CPU load on database slowing down Windchill
  • Query takes long time to be executed  : 
    • SELECT 0 indexAlias,10,A0.idA2A2,A0.updateCountA2,A0.classnameA2A2,ABS(NULL),A0.branchIdA2typeDefinitionRefe
FROM WTPart A0,
  (SELECT A0.idA2A2 alias1
   FROM WTPart A0
   WHERE ((A0.idA2A2 IN
             (SELECT /*+ CARDINALITY(wtot 500) */ *
              FROM TABLE(cast(:1 AS GUEST.TABLE_OF_NUMBER)) wtot
              WHERE (ROWNUM > 0)
                AND (column_value IS NOT NULL))))) A1
WHERE (((A0.adhocVersionInfo IS NULL)
        AND ((A0.idA2A2 IN (
                              (SELECT A0.idA2A2
                               FROM WTPart A0
                               WHERE ((UPPER(A0.source) LIKE '%0Z1035%')))
                            UNION
                              (SELECT A0.idA2A2
                               FROM WTPart A0,
                                    WTPartMaster A0B
                               WHERE (A0.idA3masterReference=A0B.idA2A2)
                                 AND ((A0B.WTPartNumber LIKE '%0Z1035%')))
                            UNION
                              (SELECT A0.idA2A2
                               FROM WTPart A0,
                                    WTPartMaster A0B
                               WHERE (A0.idA3masterReference=A0B.idA2A2)
                                 AND ((UPPER(A0B.name) LIKE '%0Z1035%')))
                            UNION
                              (SELECT A0.idA2A2
                               FROM WTPart A0
                               WHERE ((A0.idA2A2 IN (
                                                       (SELECT A0.idA2A2
                                                        FROM WTPart A0,
                                                     
This is a printer-friendly version of Article 364546 and may be out of date. For the latest version click CS364546