SAP Knowledge Base Article - Public

1741103 - Error: "Logon failed. Details: Select one of the installed languages" when attempting to create or refresh a report based off an SAP data source in Crystal Reports

Symptom

  • Unable to connect to SAP data source.
  • Fails to connect to SAP data sources from Crystal Reports.
  • When attempting to connect to SAP data sources from Crystal Reports, like: "SAP Tables, Functions and Clusters", "SAP Infosets", "SAP Operational Datastore" or "SAP BW BEx Query", it fails with the error:
      
        "Logon failed. Details: Select one of the installed languages"
         
      
         Error - 01.png

Environment

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

Reproducing the Issue

  1. In Crystal Reports, create a new report.
      
  2. In the "Database Expert" select on of the SAP data source:
    • SAP BW MDX Query
    • SAP Info sets
    • SAP Operational Data Store
    • SAP Table, Cluster, or Function
         
      Data Source - 02.png
       
           
  3. In the "SAP System Logon" window, select the SAP System to connect to, and click "Next"
        
  4. Enter the client number, username and password, and click "Finish"
     
    It then fails with the error:

       "Logon failed. Details: Select one of the installed languages"

Cause

  • When Crystal Reports connects to an SAP System, it does not prompt the end user for the language to use to connect. It uses the default language set for Crystal Reports designer.
  • If the language set in Crystal Reports is different than the installed language on the SAP System, it will fail to connect with this error.
          
    For example:
    - If the language set for Crystal Reports is: French
    - And the language installed on the SAP System are: English and German
         
    When attempting to connect to the SAP System, Crystal Reports will use the French language. Since it does not exist on the SAP System, it will fail to connect.

Resolution

  • Set Crystal Reports Preferred Viewing Locale language to one of the language installed on the SAP System.
            
    1. Confirm the languages installed on the SAP System you want to connect to, by contacting the SAP BASIS Administrator, or by following the steps below:
        
      1. 1.1  Using the SAP Logon, connect to the SAP System
          
      2. 1.2  Type transaction: SMLT
           
      3. 1.3  In the Language Management screen, it will display the list of installed languages on the SAP System. 
             
               Language installed.png
                   
           
            
    2. Set Crystal Reports Preferred Viewing Local Language to one of the language installed on the SAP System.
         
      1. 2.1  Open Crystal Reports designer.
         
      2. 2.2  Under the menu "View - Preferred Viewing Locale", select one of the language installed on the SAP System. ( For example: English )
         
      3. 2.3  It will display the message:

                   "You have changed the viewing localed and all currently opened document need to be re-formatted. Do you want to continue?"

               Click "Yes" 

                    language changed.png
                         
      4. 2.4  Now you can create a new report and successfully connect to your SAP System from Crystal Reports.

Keywords

 Logon failed, Select one of the installed languages, Crystal Reports, Locale, SAP BW MDX, Crystal Reports 2011 , KBA , 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