技术文章 - CS73935

如何防止 Windchill PDMLink 中“collectorcache”相关 Blob 表空间大幅增加

已修改: 23-Apr-2025   


注意:本文已使用机器翻译软件翻译,以方便非英语客户阅读。但翻译内容可能包含语法错误或不准确之处。请注意, PTC对本文所含信息的翻译准确性及使用后果不承担任何责任。请在 此处 查看本文的英文原始版本以便参考。有关机器翻译的更多详情,请单击 此处
感谢您告诉我们。我们将尽快审阅此译文。

适用于

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

说明

  • 如何防止收集器缓存表导致 Blob 表空间大幅增加
  • COLLECTORCACHE表的用途是什么
  • 线程报告类似以下内容的低内存警告OutOfMemoryError
    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)
这是文章 73935 的 PDF 版本,可能已过期。最新版本 CS73935