Re: wvs publish problem

TB_10966080 · ‎Jul 15, 2024

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

avillanueva · ‎Jul 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

TB_10966080 · ‎Jul 17, 2024

memory is not enough

jlecoz · ‎Jul 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.