技术文章 - CS26116
对 Windchill 执行的操作抛出错误：“返回的查询结果已超出查询限制，并且仅<quantity>Windchill PDMLink 中返回结果”
已修改: 31-Dec-2025
适用于
- Windchill PDMLink 9.0 to 13.1
- FlexPLM 9.0 to 12.0
- Creo Parametric 2.0 to 11.0
- Windchill PDMLink 13.0 to 13.1
说明
- 在特定上下文中，使用Creo Parametric 的“文件”>“打开”选项会报错。
- 返回的查询结果已超过查询限制，仅返回 <quantity> 个结果。
- 对 Windchill 执行的操作会抛出错误
- 返回的查询结果已超过查询限制，仅返回 <quantity> 个结果。
- 发布作业失败，MethodServer 日志中出现以下错误。
Tue 7/12/11 20:06:25: WVSScheduleQueue.ScheduleingThread: (wt.pom.pomResource/22) wt.pom.PersistenceException: Search results size has exceeded the limit set by the System Administrator.
- MethodServer 或其他日志文件（例如WinDU / WinRU日志）中的替代消息
(wt.pds.pdsResource/22) wt.pds.PartialResultException: The returned query result has exceeded the query limit, and only 750,000 result returned. at wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:837) at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1148) at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1051) at wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:4453) at wt.fc.StandardPersistenceManager._find(StandardPersistenceManager.java:4508) at wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:1550) at wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:605)
- 或者
UpgradeManager 失败，并在 HTML 报告中显示以下错误。
(wt.pds.pdsResource/22) wt.pds.PartialResultException: The returned query result has exceeded the query limit, and only 120,000 result returned. at wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:717) at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1106)
- 或者
wt.util.WTException: wt.util.WTException: (wt.pds.pdsResource/22) wt.pds.PartialResultException: The returned query result has exceeded the query limit, and only 300,000 result returned. Nested exception is: (wt.pds.pdsResource/22) wt.pds.PartialResultException: The returned query result has exceeded the query limit, and only 300,000 result returned. at wt.change2.MigrateProcessVariables.migrateData(MigrateProcessVariables.java:147) at wt.change2.RepairAuditsForChangeObjects.executeRepairTask(RepairAuditsForChangeObjects.java:45)
- 调用 API PagingSessionHelper.openPagingSession()时出现以下错误
data_extract_thread5: (wt.pom.pomResource/22) wt.pom.PersistenceException: Search results size has exceeded the limit set by the System Administrator. data_extract_thread5: at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1696) data_extract_thread5: at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1068) data_extract_thread5: at wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:4426) data_extract_thread5: at wt.fc.StandardPersistenceManager._find(StandardPersistenceManager.java:4499) data_extract_thread5: at wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:1550) data_extract_thread5: at wt.fc.PersistenceManagerFwd.find(PersistenceManagerFwd.java:1158) data_extract_thread5: at wt.fc.PagingSessionHelper.openPagingSession(PagingSessionHelper.java:396) data_extract_thread5: at wt.fc.PagingSessionHelper.openPagingSession(PagingSessionHelper.java:321)
- 清除操作失败，出现未处理的异常。
SEVERE ERROR: Unhandled exception occurred during processing. Cannot continue Purge operation. The returned query result has exceeded the query limit, and only XXX result returned.
- 在配置/重新配置可配置模块/可配置部件时， “匹配变体规范表”显示“返回的查询结果已超出查询限制”错误。
- 安全审计报告查询结果无法完全导出，出现错误：返回的查询结果已超出查询限制，仅返回 XXX 条结果。
- 协议无法结账，错误信息为：返回的查询结果已超出查询限制，仅返回了 XXX 个结果。
- 数据监控失败，并出现以下错误： wt.pds.PartialResultException：返回的查询结果已超出查询限制，仅返回了 xxxx 个结果。
- 无法打开策略管理，错误信息为：返回的查询结果已超出查询限制
- 修改类型和属性管理中的内部名称时出错
- 创建自定义视图时，无法查看特定库文件夹中的对象，并出现警告
"query limit reached”。 - 上传或签入族表装配失败，出现以下错误
The returned query result has exceeded the query limit, and only 250,000 result returned.
这是文章 26116 的 PDF 版本，可能已过期。最新版本 CS26116