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

12-Amethyst
July 18, 2024

thanks,How to set it up? Please provide specific steps for setting up the operation