Non-site admin users unable to edit or generate a report from a report template with ‘Bypass Access Control’ in Windchill
Applies To
- FlexPLM 11.0 F000 to 12.0.0.1
- Windchill PDMLink 10.2 F000 to 13.0
- Windchill ProjectLink 10.2 to 12.1
- Using the “unrestrictedGroups” property to allow some users to run query builder reports does not override the user’s restricted access to some WC libraries when the report runs
Description
-
Non-site admin users are unable to edit and generate a report when the report template is checked with Bypass Access Control
-
As an organization admin, user is unable to create a Query Builder Report
-
User unable to update an existing Query Builder Report
- Non-admin user cannot see Save button while creating a Query builder Report
- Non admin user can see distinct is greyed out and can't be checked
- View Report action is greyed out for Non admin user
-
MethodServer logs show the following errors
-
For Windchill 11.0 and later versions
InvalidQMLException: Access is restricted for this user. at com.ptc.windchill.enterprise.reportBuilder.ReportBuilderHelper.buildResultProcessorInfo(ReportBuilderHelper.java:842) at com.ptc.windchill.enterprise.reportBuilder.ReportBuilderHelper.buildResultProcessorBridge(ReportBuilderHelper.java:813) at com.ptc.windchill.enterprise.reportBuilder.ReportBuilderAsyncTableBuilder.buildComponentData(ReportBuilderAsyncTableBuilder.java:131) at com.ptc.jca.mvc.components.DefaultJcaComponentDataBuilder.buildRawDataAsync(DefaultJcaComponentDataBuilder.java:93)
-
For Windchill 10.2
2019-06-19 08:24:01,187 ERROR [DataSource Task Executor-55] com.ptc.mvc.components.ds.AbstractDataSourceComponentDataBuilder test - Unable to process component data for component: adhocTable wt.util.WTException: Access is restricted for this user. Nested exception is: Access is restricted for this user. Nested exception is: (wt.query.template.templateResource/3) wt.query.template.InvalidQMLException: Access is restricted for this user. at wt.query.template.ReportTemplateHelper.buildResultProcessorBridge(ReportTemplateHelper.java:1757) at com.ptc.windchill.enterprise.report.mvc.builders.ReportResultsAsyncTableBuilder.buildComponentData(ReportResultsAsyncTableBuilder.java:98) at com.ptc.jca.mvc.components.DefaultJcaComponentDataBuilder.buildRawDataAsync(DefaultJcaComponentDataBuilder.java:91) at com.ptc.mvc.components.ds.AbstractDataSourceComponentDataBuilder$ComponentDataSourceTask.run(AbstractDataSourceComponentDataBuilder.java:425) at com.ptc.mvc.ds.server.DefaultDataSourceManager$DataSourceTaskCallable.callInContext(DefaultDataSourceManager.java:226) at com.ptc.mvc.ds.server.DefaultDataSourceManager$DataSourceTaskCallable.callInContext(DefaultDataSourceManager.java:195)
-