Article - CS68607
Windchill PDMLink: API to set query limit for customization query using QuerySpec
Modified: 18-Mar-2026
Applies To
- Windchill PDMLink 10.2 to 13.0
Description
- After setting wt.pom.queryLimit to 10000 or any specific number, customization query using QuerySpec API fails as it returned more than 10000 results or value set
- Is there any API to reset query limit for the query
- Custom code using the QuerySpec API fails to execute, with following error in MethodServer log:
ERROR [ajp-nio-127.0.0.1-8010-exec-1] wt.method.MethodContextMonitor.contexts.servletRequest TESTUSER - XXXX-XX-XX 10:53:09.774 +0000, 1cdhasfy0r;mmt1mof2;2979786;8ora79;3284, -, -, 1cdhasfy0r;mmt1mof2;2979786;8ora79;3283, TESTUSER, XX.XX.XX.XXX:11126, -, -, , 0, 2, 463.767851939, 2, 0.001807671, 16.08104029, 481.07071622 (wt.pds.pdsResource/22) wt.pds.PartialResultException: The returned query result has exceeded the query limit, and only 200,000 result returned.
at wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:875)
at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1077)
at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:986)
at wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:2133)
at wt.fc.StandardPersistenceManager._find(StandardPersistenceManager.java:2169)
at wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:666)
This is a printer-friendly version of Article 68607 and may be out of date. For the latest version click CS68607