1448627 - Error: 'An error occurred while generating a new report template. No error.' when attempting to create a new report off an SAP BW BEx Query in Crystal Reports

SAP Knowledge Base Article - Public

1448627 - Error: 'An error occurred while generating a new report template. No error.' when attempting to create a new report off an SAP BW BEx Query in Crystal Reports

Symptom

  • Error: 'An error occurred while generating a new report template. No error.'
  • When attempting to create a new report off an SAP BW BEx Query in Crystal Reports using the SAP menu, it fails with the error:
       
         'An error occurred while generating a new report template. No error.'

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
           
  • SAP BW 7.1
  • SAP BW 7.2
  • SAP BW 7.3
  • SAP BW 7.4
  • SAP BW 7.5

Reproducing the Issue

  1. In Crystal Reports, under the menu "SAP", select "Create New Report from a Query..."
  2. Logon to an SAP BW System.
  3. Select any SAP BW BEx Query, and click "Open"
        
       SAP BW Menu - Error - 01.png
      
      
    It then generates the following error, and it is not possible to create a new report:
     
          'An error occurred while generating a new report template. No error.'

Cause

  • The SAP Gateway security configuration is not allowing Crystal Reports from retreiving the information for the SAP BW BEx Query.

Resolution

  • To be able to create a new report off an SAP BW BEx Query in Crystal Reports, open the SAP Gateway to allow Crystal Reports to connect to the SAP BW System.
         
  • To update the SAP Gateway to allow your user, or computer, or external application to connect to the SAP System, contact your SAP BASIS Administrator. For more information see the SAP Note: 1408081 Basic settings for reg_info and sec_info
            
  • If you have any questions or issues setting security for the SAP Gateway, then create an incident for the SAP Gateway support, under the component: BC-CST-GW

Keywords

CR, CR SAP BW, BEx Query report, an error occured, an error ocurred , KBA , BI-BIP-IK , Integration; Integration kits for SAP, Baan, PeopleSoft, Sie , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

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