SAP Knowledge Base Article - Public

1448627 - Error: 'An error occurred while generating a new report template. No error.' when creating a new report on an SAP BW 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 Query in Crystal Reports using the SAP menu, it fails with the error:
       
         'An error occurred while generating a new report template. No error.'
      
      
  • Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
             
  • 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 a case 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 Business View Manager , Problem

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020