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