1579221 - Error: 'COM exception caught in CExtToolBar::GenerateTemplateHelper', when selecting an SAP BW BEx Query in Crystal Reports

SAP Knowledge Base Article - Public

1579221 - Error: 'COM exception caught in CExtToolBar::GenerateTemplateHelper', when selecting an SAP BW BEx Query in Crystal Reports

Symptom

  • Fails when selecting an SAP BW BEx Query in Crystal Reports.
  • When attempting to connect to an SAP BW BEx Query from Crystal Reports, it fails with the error:
        
    "COM exception caught in CExtToolBar::GenerateTemplateHelper(). HR = 0x80010105"

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Reproducing the Issue

  1. Open Crystal Reports designer.
  2. In the SAP Toolbar, click the button 'Create new report from a query'.
  3. Connect to the BW system.
  4. Select a BW query and click OK.
  5. The error message will be displayed.

Cause

  • The 'req. status' value for the BEx Query under the RSRT transaction code is set too high, and does not allow to use the BEx Query.

Resolution

  • The "request status" setting in transaction RSRT needs to be adjusted.
    1. Launch the SAP GUI and enter transaction code: RSRT
    2. In the 'Query' text box,  type in or search for the query name.
    3. Click on the 'Properties' tab.
    4. Modify the 'Req. Status' value to be lower.

NOTE:
The request status can be set to different values, which will affect whether the yellow request (open request created by planning function) will read or not during the query run. 
 
For example:
  
0 - will only read all the green requests
9 - will including red and yellow requests

Keywords

RSRT, BEx, CExtToolBar, GenerateTemplateHelper, HR = 0x80010105, SAPIK , KBA , BI-BIP-ADM , BI Servers, security & CrystalReports viewing in BI platform , Problem

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016