1. Home
  2. Support
Article - CS26116

Actions performed on Windchill throws error "The returned query result has exceeded the query limit, and only <quantity> result returned" in Windchill PDMLink

Modified: 12-Mar-2025   


Applies To

  • 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

Description

  • File > Open in Creo Parametric on specific contexts throws error
    • The returned query result has exceeded the query limit, and only <quantity> result returned
  • Actions performed on Windchill throws error
    • The returned query result has exceeded the query limit, and only <quantity> result returned
  • Publishing jobs fail with following error in the MethodServer log 
    • 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.
  • Alternative message in the MethodServer or other log files for instance WinDU/WinRU logs
(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)
  • OR
UpgradeManager fails with following error in html report 
(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)
  • OR
  • 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)
  • Invoke API PagingSessionHelper.openPagingSession() with following errors 
    • 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)
  • Purge failed with unhandled exception
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.

 
  • While Configuring/Reconfiguring a Configurable Module/Configurable Part, the Matching Variant Specification Table shows "The returned query result has exceeded the query limit" error
  • The Security Audit Report query result cannot be exported completely with error: The returned query result has exceeded the query limit, and only XXX result returned
  • Agreement cannot be Check-Out with error: The returned query result has exceeded the query limit, and only XXX result returned
  • Data Monitor failing with error: wt.pds.PartialResultException: The returned query result has exceeded the query limit, and only xxxx result returned
  • Not able to open Policy Administration with error: The returned query result has exceeded the query limit
  • Error modifying internal name, in type and attribute management
  • Unable to view objects in specific library folder when created custom view with warning "query limit reached"
  • Upload or Check-in family table assembly failed with following error 
    The returned query result has exceeded the query limit, and only 250,000 result returned.
This is a printer-friendly version of Article 26116 and may be out of date. For the latest version click CS26116