Skip to main content
12-Amethyst
Jul 16, 2024 3:55 AM UTC
Question

wvs publish problem

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

6 replies

avillanueva
23-Emerald II
Jul 16, 2024 11:46 AM UTC

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

 

Translate
12-Amethyst
Jul 17, 2024 12:16 PM UTC

memory is not enough

Translate
15-Moonstone
Jul 17, 2024 1:45 PM UTC

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.

Translate