Skip to main content
12-Amethyst
July 16, 2024
Question

wvs publish problem

  • July 16, 2024
  • 1 reply
  • 1733 views

024-07-16 09:56:11,702 ERROR [PublisherQueue1.PollingThread] wt.wvs.publish.PublishHelper Administrator - Unexpected exception
(wt.pds.pdsResource/22) wt.pds.PartialResultException: 返回的查询结果已经超过查询限定,并且只返回了100,000的结果。
at wt.pds.BasicResultCursor.next(BasicResultCursor.java:90)
at wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:853)
at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1111)
at wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1983)
at wt.fc.StandardPersistenceManager._find(StandardPersistenceManager.java:2007)
at wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:678)
at sun.reflect.GeneratedMethodAccessor154.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
at com.sun.proxy.$Proxy12.find(Unknown Source)
at wt.representation.StandardRepresentationService.getOutOfDateRepresentationContributors(StandardRepresentationService.java:400)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
at com.sun.proxy.$Proxy100.getOutOfDateRepresentationContributors(Unknown Source)
at com.ptc.wvs.server.publish.PublishHelper.markParentRepresentationsOutOfDate(PublishHelper.java:2412)
at com.ptc.wvs.server.publish.PublishHelper.markParentsOutOfDate(PublishHelper.java:1852)
at com.ptc.wvs.server.publish.PublishJob.executePublishJob(PublishJob.java:1096)
at com.ptc.wvs.server.publish.PublishJob.processJob(PublishJob.java:810)
at com.ptc.wvs.server.publish.WVSProcessingJob.doMyJob(WVSProcessingJob.java:549)
at com.ptc.wvs.server.publish.WVSProcessingJob.doJobInternal(WVSProcessingJob.java:510)
at com.ptc.wvs.server.publish.WVSProcessingJob.doJob(WVSProcessingJob.java:480)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at wt.queue.QueueEntry.execute(QueueEntry.java:224)
at wt.queue.ProcessingQueue.execEntry(ProcessingQueue.java:285)
at wt.queue.ProcessingQueue.execEntries(ProcessingQueue.java:901)
at wt.queue.PollingQueueThread.run(PollingQueueThread.java:99)
2024-07-16 09:56:23,828 ERROR [PublisherQueue6.PollingThread] wt.wvs.publish.PublishHelper Administrator - Unexpected exception
(wt.pds.pdsResource/22) wt.pds.PartialResultException: 返回的查询结果已经超过查询限定,并且只返回了100,000的结果。
at wt.pds.BasicResultCursor.next(BasicResultCursor.java:90)
at wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:853)
at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1111)
at wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1983)
at wt.fc.StandardPersistenceManager._find(StandardPersistenceManager.java:2007)
at wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:678)
at sun.reflect.GeneratedMethodAccessor154.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
at com.sun.proxy.$Proxy12.find(Unknown Source)
at wt.representation.StandardRepresentationService.getOutOfDateRepresentationContributors(StandardRepresentationService.java:400)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
at com.sun.proxy.$Proxy100.getOutOfDateRepresentationContributors(Unknown Source)
at com.ptc.wvs.server.publish.PublishHelper.markParentRepresentationsOutOfDate(PublishHelper.java:2412)
at com.ptc.wvs.server.publish.PublishHelper.markParentsOutOfDate(PublishHelper.java:1852)
at com.ptc.wvs.server.publish.PublishJob.executePublishJob(PublishJob.java:1096)
at com.ptc.wvs.server.publish.PublishJob.processJob(PublishJob.java:810)
at com.ptc.wvs.server.publish.WVSProcessingJob.doMyJob(WVSProcessingJob.java:549)
at com.ptc.wvs.server.publish.WVSProcessingJob.doJobInternal(WVSProcessingJob.java:510)
at com.ptc.wvs.server.publish.WVSProcessingJob.doJob(WVSProcessingJob.java:480)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at wt.queue.QueueEntry.execute(QueueEntry.java:224)
at wt.queue.ProcessingQueue.execEntry(ProcessingQueue.java:285)
at wt.queue.ProcessingQueue.execEntries(ProcessingQueue.java:901)
at wt.queue.PollingQueueThread.run(PollingQueueThread.java:99)
2024-07-16 09:56:25,844 ERROR [Thread-29 ProcessMessages] wt.wvs.workeragent.ProcessMessages - 不知道如何处理 "

 

how solve this problem

1 reply

avillanueva
23-Emerald I
23-Emerald I
July 16, 2024

Check this setting: com.ptc.windchill.search.queryLimit and wt.pom.queryLimit. Sounds like you are hitting the query limit with DB. You can disable or increase as needed but most articles are pointing to this setting:

https://www.ptc.com/en/support/article/CS366840?source=search

 

12-Amethyst
July 17, 2024

memory is not enough

15-Moonstone
July 17, 2024

If you can't increase the query limit for memory reasons, then you can consider to reduce the size of your query. For example you could schedule multiple publishing jobs at context level (product/library) instead of a big one.