Article - CS52471
When exporting a list to XLS Report in search result table, dataset get truncated in Windchill PDMLink
Modified: 29-Feb-2024
Applies To
- Windchill PDMLink 10.0 to 12.1
- Microsoft Excel
Description
- Export List to XLS Report in Search Result table - dataset gets truncated
- Export list to File fails to export all rows
- Report Manager (Query Builder) result export is limited
- Warning message:
ATTENTION: Export truncated. The data set is too large to be exported. The export constraint limits are 256 columns and 65535 rows
- This message (or similar) may appear in the MethodServer log:
wt.pds.PartialResultException: The returned query result has exceeded the query limit, and only 15,000 result returned. (wt.pds.pdsResource/22) wt.pds.PartialResultException: The returned query result has exceeded the query limit, and only 15,000 result returned. at wt.pds.BasicResultCursor.next(BasicResultCursor.java:90) at wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:837) at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1076) at wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1977) at wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1929) at wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1459) at wt.query.template.ResultProcessorBridge.streamResults(ResultProcessorBridge.java:164) at com.ptc.windchill.enterprise.reportBuilder.ReportBuilderAsyncTableBuilder.buildComponentData (ReportBuilderAsyncTableBuilder.java:202)
- When generating list of objects in a library using Query builder, unable to export certain reports due to export constraint limits, Is it possible to increase the Constraint Limits?
This is a printer-friendly version of Article 52471 and may be out of date. For the latest version click CS52471