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