Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. X
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
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
memory is not enough
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.
How to set it up? Please provide specific steps for setting up the operation
thanks,How to set it up? Please provide specific steps for setting up the operation
If you are product manager in a context you select the Utility menu in the left navigator.
From the utility page you then use the WVS publish job to schedule a publication job, the search scope will be then limited to the product context.