1. Home
  2. Support
Article - CS181635

Loading the Work Package List Table with the "All" view generates excessively large queries on the CDRLBasePackage table with Windchill Aerospace and Defense Module 10.1

Modified: 20-Oct-2016   


Applies To

  • Windchill PDMLink 10.1 M040
  • Windchill AeroSpace and Defense Module (WADM)

Description

  • Loading the Work Package List Table with the All view generates excessively large queries on the CDRLBasePackage table
  • Thread dumps show threads like the following
2014-08-03 14:10:41,193 INFO [Periodic-Stack-Logger] wt.jmx.core.mbeans.PeriodicStackLoggingDelegate - Full thread stack trace (2376@<SERVER_NAME>; 2014-08-03 19:10:41.191 +0000)
"DataSource Task Executor-29022" Id=84174 prio=5 RUNNABLE
Blocked (cnt): 1631; Waited (cnt): 0
CPU nanos: 8199614452; User nanos: 7151461170; Bytes allocated: 1533759744
Method context: 10gd6vg;hyakt172;2376;5kxtx6;628695; DB session: 2130
at java.lang.Throwable.fillInStackTrace(Native Method)
- locked java.beans.IntrospectionException@5edf518e
at java.lang.Throwable.<init>(Throwable.java:196)
at java.lang.Exception.<init>(Exception.java:41)
at java.beans.IntrospectionException.<init>(IntrospectionException.java:29)
at java.beans.PropertyDescriptor.<init>(PropertyDescriptor.java:89)
at wt.introspection.WTPropertyDescriptor.<init>(WTPropertyDescriptor.java:75)
at wt.introspection.WTPropertyDescriptor.<init>(WTPropertyDescriptor.java:52)
at wt.introspection.ClassInfo.getPropertyDescriptor(ClassInfo.java:1331)
- locked wt.introspection.ClassInfo@3e5b631
at wt.introspection.ClassInfo.getConstrainedEnum(ClassInfo.java:1026)
at wt.facade.persistedcollection._PersistedCollectionInfo.readExternal(_PersistedCollectionInfo.java:114)
at wt.pds.WTResultSet.readObject(WTResultSet.java:602)
at com.ptc.windchill.wp._AbstractWorkPackage.readExternal(_AbstractWorkPackage.java:1331)
at com.ptc.windchill.wp._WorkPackage.readExternal(_WorkPackage.java:66)
at com.ptc.windchill.wadm.cdrl._ContractPackage.readExternal(_ContractPackage.java:166)
at com.ptc.windchill.wadm.cdrl._CDRLBasePackage.readExternal(_CDRLBasePackage.java:611)
"DataSource Task Executor-28993" Id=84110 prio=5 BLOCKED on lock=wt.introspection.ClassInfo@3e5b631
lock owned by "DataSource Task Executor-29022" Id=84174
Blocked (cnt): 5594; Waited (cnt): 0
CPU nanos: 27406065958; User nanos: 23910839197; Bytes allocated: 5079793192
Method context: 10gd6vg;hyakt172;2376;5kxtx6;628423; DB session: 2725
at wt.introspection.ClassInfo.getPropertyDescriptor(ClassInfo.java:1325)
at wt.introspection.ClassInfo.getConstrainedEnum(ClassInfo.java:1026)
at wt.facade.persistedcollection._PersistedCollectionInfo.readExternal(_PersistedCollectionInfo.java:114)
at wt.pds.WTResultSet.readObject(WTResultSet.java:602)
at com.ptc.windchill.wp._AbstractWorkPackage.readExternal(_AbstractWorkPackage.java:1331)
at com.ptc.windchill.wp._WorkPackage.readExternal(_WorkPackage.java:66)
at com.ptc.windchill.wadm.cdrl._ContractPackage.readExternal(_ContractPackage.java:166)
at com.ptc.windchill.wadm.cdrl._CDRLBasePackage.readExternal(_CDRLBasePackage.java:611)
This is a printer-friendly version of Article 181635 and may be out of date. For the latest version click CS181635