アーティクル - CS223072
ユーザーが Windchill PDMLink のすべての部品にアクセスできない場合でも、すべての部品番号を表示できるようにする方法
修正日: 14-Oct-2022
適用対象
- Windchill PDMLink 9.1 to 12.1
説明
- ユーザーがすべてのパーツにアクセスできない場合でも、ユーザーがすべてのパーツ番号を表示できるようにする方法は?
- Query Builder内の WTPart の数をカウントするレポートが機能しない
- UI のエラー:
A statement with aggregate function can not be used with access control
- 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)
最新バージョンはこちらを参照ください CS223072