Soluzione # - CS223072

Come consentire agli utenti di visualizzare tutti i numeri di parte anche se non hanno accesso a tutte le parti in Windchill PDMLink

Modifica: 02-Apr-2025   


Si applica a

  • Windchill PDMLink 9.1 to 12.1

Descrizione

  • Come consentire agli utenti di vedere tutti i codici articolo anche se non hanno accesso a tutti i pezzi?
  • Il report per contare il numero di WTParts in Query Builder non funziona
  • Errore nell'interfaccia utente:
A statement with aggregate function can not be used with access control
  • Errore nel registro MethodServer:
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 PDF version of Article 223072 and may be out of date. For the latest version CS223072