Article - CS292726

Non-site admin users unable to edit or generate a report from a report template with ‘Bypass Access Control’ in Windchill

Modified: 05-Dec-2024   


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 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)
      
This is a printer-friendly version of Article 292726 and may be out of date. For the latest version click CS292726