Article - CS73935

How to prevent huge increasing of Blob table space about "collectorcache" in Windchill PDMLink

Modified: 23-Apr-2025   


Applies To

  • Windchill PDMLink 10.0 to 11.0
  • SQL Server
  • Oracle Database

Description

  • How to prevent huge increasing of Blob table space from collectorcache table
  • What's the usage of COLLECTORCACHE table
  • Low Memory Warning or OutOfMemoryError reported from thread similar to: 
    at java.net.SocketInputStream.socketRead0(Native Method)
      at java.net.SocketInputStream.read(SocketInputStream.java:129)
      at oracle.net.ns.Packet.receive(Packet.java:300)
      at oracle.net.ns.DataPacket.receive(DataPacket.java:106)
      at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:315)
      at oracle.net.ns.NetInputStream.read(NetInputStream.java:260)
      at oracle.net.ns.NetInputStream.read(NetInputStream.java:185)
      at oracle.net.ns.NetInputStream.read(NetInputStream.java:102)
    ...
      at oracle.sql.BLOB.getBytes(BLOB.java:348)
      at oracle.jdbc.driver.OracleBlobInputStream.needBytes(OracleBlobInputStream.java:181)
      at oracle.jdbc.driver.OracleBufferedStream.readInternal(OracleBufferedStream.java:174)
      at oracle.jdbc.driver.OracleBufferedStream.read(OracleBufferedStream.java:143)
        - locked oracle.jdbc.driver.OracleBlobInputStream@405ba273
      at wt.pds.PDSEncoder$InputRedirector.read(PDSEncoder.java:1292)
    ...
      at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1106)
      at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1015)
      at wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1829)
      at wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1368)
      at wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1252)
      at wt.fc.collections.RefreshHelper$Refresh.doSecondPass(RefreshHelper.java:676)
      at wt.fc.collections.RefreshHelper$Refresh.refresh(RefreshHelper.java:467)
      at wt.fc.collections.RefreshHelper.refresh(RefreshHelper.java:112)
      at wt.fc.collections.StandardCollectionsManager.refresh(StandardCollectionsManager.java:80)
      at sun.reflect.GeneratedMethodAccessor193.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
      at $Proxy18.refresh(Unknown Source)
      at wt.fc.StandardPersistenceManager$DeleteBatchSpecChunkResultProcessor.process(StandardPersistenceManager.java:3394)
      at wt.fc.AbstractOidChunkResultProcessor.process(AbstractOidChunkResultProcessor.java:147)
      at wt.fc.AbstractOidChunkResultProcessor.addElement(AbstractOidChunkResultProcessor.java:78)
      at wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:693)
      at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1106)
      at wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1834)
      at wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1786)
      at wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1362)
      at wt.fc.batch.BatchSpecificationUtilities.queryTargetKeys(BatchSpecificationUtilities.java:89)
      at wt.fc.StandardPersistenceManager.execute(StandardPersistenceManager.java:1463)
      at com.ptc.core.htmlcomp.collection.engine.CollectorCacheServerHelper.releaseCollectorCache(CollectorCacheServerHelper.java:284)
      at com.ptc.core.htmlcomp.collection.engine.CollectorCacheServerHelper.releaseCollectorCache(CollectorCacheServerHelper.java:229)
      at com.ptc.core.htmlcomp.collection.engine.StandardUICollectionService.getNewCollectorID(StandardUICollectionService.java:778)
This is a printer-friendly version of Article 73935 and may be out of date. For the latest version click CS73935