Article - CS223072
How to allow users to see all part numbers even though they do not have access to all parts in Windchill PDMLink
Modified: 26-Nov-2025
Applies To
- Windchill PDMLink 9.1 to 12.1
Description
- How to allow users to see all part numbers even though they do not have access to all parts ?
- Report to count the number of WTParts within Query Builder does not work
- Error in UI:
A statement with aggregate function can not be used with access control
- Error in MethodServer log:
2022-10-13 04:29:32,137 ERROR [DataSource Task Executor-92] com.ptc.mvc.components.ds.AbstractDataSourceComponentDataBuilder wcadmin - Unable to process component data (async) for component: adhocTable[123] (wt.pds.pdsResource/36) wt.pom.PersistenceException: ?????????????????? at wt.pds.SurrogateAccessController.checkQuery(SurrogateAccessController.java:224) at wt.pds.CompositeAccessController.checkQuery(CompositeAccessController.java:252) at wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:720) at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1077) at wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1977) at wt.fc.StandardPersistenceManager._find(StandardPersistenceManager.java:2008) at wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:667) at jdk.internal.reflect.GeneratedMethodAccessor194.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399) at com.sun.proxy.$Proxy27.find(Unknown Source) at wt.query.template.ResultProcessorBridge.streamResults(ResultProcessorBridge.java:173) at com.ptc.windchill.enterprise.reportBuilder.ReportBuilderAsyncTableBuilder.buildComponentData(ReportBuilderAsyncTableBuilder.java:202) at com.ptc.jca.mvc.components.DefaultJcaComponentDataBuilder.buildRawDataAsync(DefaultJcaComponentDataBuilder.java:93) at com.ptc.mvc.components.ds.AbstractDataSourceComponentDataBuilder$ComponentDataSourceTask.run(AbstractDataSourceComponentDataBuilder.java:455) at com.ptc.mvc.ds.server.DefaultDataSourceManager$DataSourceTaskCallable.callInContext(DefaultDataSourceManager.java:224) at com.ptc.mvc.ds.server.DefaultDataSourceManager$DataSourceTaskCallable.callInContext(DefaultDataSourceManager.java:193) at com.ptc.mvc.ds.server.MethodContextCallable.call(MethodContextCallable.java:47) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829)
This is a printer-friendly version of Article 223072 and may be out of date. For the latest version click CS223072