SAP Knowledge Base Article - Public

2245135 - Connecting to Salesforce.com from Crystal Reports - Master Knowledge Base

Symptom

  • Where to find information on Salesforce.com connectivity with Crystal Reports?
  • What are the common issues when reporting off Salesforce.com in Crystal Reports?
  • How to troubleshoot and resolve issues connecting to Salesforce.com from Crystal Reports?

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
           
  • Salesforce.com

Cause

  • Most issues connecting to Salesforce.com from Crystal Reports, or refreshing a report based on Salesforce.com, are due to:
          
    • Salesforce.com Security
      • Security Token
      • Trusted IP Range
      • Password Security Policy
      • Cerificate
             
    • Corporate Network Security
      • Proxy
      • Firewall
              
    • Salesforce.com Limitations
      • Salesforce.com Edition
      • Salesforce.com API restrictions
                  
    • Salesforce.com Java driver used by Crystal Reports 2011 and below:        
      • Java installation / configuration
      • Java Memory
      • Batch Size  
              
    • Salesforce.com ODBC driver used by Crystal Reports 2013 and above:
      • ODBC driver product defects

Resolution

  • Important News
        
    • In 2016, Salesforce deprecated the API url Crystal Reports was using by default to connect to Salesforce.com, therefore, reports needs to be updated to use the new url. For more information, see the SAP Knowledge Base Article 2243216
          
    • Also in 2017, Salesforce.com will be dropping support for the encryption TLS 1.0, therefore all application using this encryption method will no longer be able to connect to Salesforce.com, including Crystal Reports. The latest updates of Crystal Reports are now using TLS 1.1 or higher. For more information, and latest update, see the SAP Knowledge Base Article 2261638 
                     
    • Crystal Reports was using a Java driver to connect to Salesforce.com in the past, but from Crystal Reports 2013, it is now using an ODBC driver. The latest update of the Salesforce ODBC drivers in Crystal Reports 2013 / 2016 has many issues, therefore we suggest to test each report in a testing environment before applying the latest product update to a production environment. For a list of issues, see the Crystal Reports 2013 / 2016 section below.
                     
               
  • General Information on Crystal Reports connectivity to Salesforce.com
            
    • 1206543 - Salesforce.com not listed in available datasources in Crystal Reports
    • 1294512 - How to configure the HTTP proxy for the Salesforce.com connectivity for Crystal Reports?
    • 1294023 - How to add an IP Address to the Salesforce.com Trusted IP Ranges, to be able to connect to Salesforce.com?
    • 2247103 - How to set Salesforce Security Token, to be able to connect to Salesforce.com from Crystal Reports?
    • 1294496 - How to create a report off a Salesforce.com report in Crystal Reports? (Stored Procedure)
    • 1294510 - How to create a report off Salesforce.com in Crystal Reports using your own SOQL query? (Command Object)
    • 1294497 - How to improve report performance when reporting off Salesforce.com in Crystal Reports?
    • 1294583 - How to increase the batch size when reporting off Salesforce.com in Crystal Reports?
    • 1294557 - How to increase JVM memory size for Crystal Reports when reporting off Salesforce.com?
    • 1384116 - What are the Salesforce.com API version supported by Crystal Reports?
    • 2174175 - What does the option: Use Analytic API do, when connecting to Salesforce.com from Crystal Reports?
    • 1294032 - What are the Salesforce.com objects that can be used when connecting to Salesforce.com from Crystal Reports?
    • 1376594 - Does the Salesforce.com connectivity with Crystal Reports is supported on SAP BI Platform installed on Unix?
    • 2092680 - SAP Crystal Reports, Salesforce.com and SSL vulnerability
                 
             
  • General troubleshooting steps to resolve Salesforce.com connectivity issue?
       
    1. Verify if the Salesforce.com user name and password are correct by login to the Salesforce.com website at: https://login.salesforce.com
             
    2. Verify with your Salesforce.com Administrator, if your computer is within the Salesforce.com Trusted IP Range?
      For information on how to add your computer to the Salesforce.com Trusted IP Range, see the SAP Knowledge Base 1294023
           
    3. If your computer is not within the Salesforce.com Trusted IP Range, then ensure you are using the Salesforce.com Security Token?
      For information on how to obtain and use the Salesforce.com Security Token to connect using external application, see the SAP Knowledge Base 2247103 
                  
    4. Confirm with your Network Administrator, if your company network uses Proxy. If it does, then add the proxy information to the Salesforce.com driver, by following the information found in the SAP Knowledge Base 1294512
            
    5. Search the SAP Knowledge Base Articles below, which list all the known error messages and issues connecting to Salesforce.com from Crystal Reports.
           
                      
  • Issues to login or refresh a report
            
    • 2243216 - Unable to login or refresh report based on Salesforce.com that connect to the url: www.salesforce.com after January 1, 2016
    • 2261638 - Error: 'TLS 1.0 has been disabled in this organization'
    • 2475960 - Error: 'Logon failed. Unexpected error; nested exception is:javax.netssl.SSLHandshakeException...'
    • 2475299 - Error: 'Logon failed. HY000:[Simba][Saleforce] (60) Invalid Salesforce URL used for connection...'
    • 1978931 - Error: 'Logon Failed. Host not found'
    • 2394761 - Error: 'Logon failed. HY000:A connection attempt failed...'
    • 1516976 - Error: 'Invalid Argument provided. Details: Java Server startup failure.'
    • 1466958 - Error: 'Logon failed. Unexpected error; nested exception is: java.net.UnknownHostException: www.salesforce.com'
    • 1825387 - Error: 'Logon failed. Unexpected error; nested exception is: java.net.UnknownHostException:https' when attempting to connect to a Sandbox
    • 2177800 - Error: Failed to open the connection, The users password has expired, you must call SetPassword before attempting any other API operations
    • 2204887 - Error: 'HY000:API_DISABLED_FOR_ORG: API is not enabled for this Organization or Partner'
    • 2270580 - Error: 'HY000:OPERATION_TOO_LARGE:Exceeded 100000 distinct ids'
    • 2270635 - Error: 'HY000:QUERY_TIMEOUT: Your query request was running for too long.'
    • 2205572 - Error: 'Failed to open the connection. Nested exception: javax.net.sslSSLHandShakeException'
    • 1639310 - Error: 'Failed to open the connection. Details:Unexpected Error; in Crystal Reports 2011 SP02
    • 1977803 - Error: INVALID_QUERY_FILTER_OPERATOR
    • 2387522 - Error: 'MALFORMED_QUERY: Bind variables only allowed in Apex code'
    • 1745816 - Error: 'Unexpected', when refreshing a report based on Salesforce.com Stored Procedure
    • 1294566 - Error: Query Locator time out
    • 1363251 - Error: Unexpected Error, when trying to expand the Salesforce.com tables
    • 1771811 - Error: Database Connector Error, due to invalid SOQL generated by Crystal Reports when the report contains complicated Record Selection
    • 1461807 - Error: 'An error occurred while parsing the native salesforce report'
    • 2383365 - Error: 'INVALID_QUERY_LOCATOR', when refreshing a report based off Salesforce.
    • 2517068 - Error: 'Invalid column name' when refreshing a report based off Salesforce.com
    • 2383365 - Slow performance when refreshing a report based off Salesforce.com             
          
                   
  • Issues Viewing reports in BI LaunchPad or the Central Management Console (CMC)
            
    • 1821605 - Looping Logon
    • 2066359 - Error: "Failed to open the connection. <Report Name> .rpt"
    • 1455285 - Error: Failed to load database information
    • 2215441 - Salesforce.com connectivity for Crystal Reports missing in SAP BusinessObjects Business Intelligence Platform
    • 2205572 - Error: "Failed to open the connection. Nested exception: javax.net.sslSSLHandShakeException"
    • 2041989 - The viewer could not process an event. File is too large for attachment. Error code:0 [CRWEB00000119]
    • 1376594 - Does the Salesforce.com connectivity with Crystal Reports is supported on SAP BI Platform installed on Unix?
           
          
  • Crystal Reports 2008 / 2011
          
    • 2475960 - Error: 'Logon failed. Unexpected error; nested exception is:javax.netssl.SSLHandshakeException...'
    • 1404062 - Error: 'Invalid Argument provided. Details: Java Server startup failure.' in Crystal Reports 2008
    • 1639310 - Error: 'Failed to Open the connection Details:Unexpected Error' when attempting to connect to Salesforce.com from Crystal Reports 2011 SP02
         
          
  • Crystal Reports 2013 / 2016
        
    • 2383365 - Crystal Reports 2013 and 2016 are slow when refreshing some reports based off Salesforce.com
    • 2177883 - Crystal Reports 2013 crash when attempting to logon to Salesforce.com due to user password that needs to be reset
    • 2174282 - Crystal Reports 2013 crash when connecting to Salesforce.com and selecting the option: Use Analytic API
    • 1941563 - Crystal Reports 2013 crash when refreshing a report based off Salesforce.com that contains a field with a large number of characters
    • 2247113 - Crystal Reports 2013 crash when refreshing a report based off a custom Salesforce Query ( SOQL )
    • 2521079 - Error: 'Invalid date format' when refreshing a report based off Salesforce.com Command Object
    • 2521534 - Error: 'ParsingFailure', when refreshing a report based off Salesforce.com Command Object.
    • 2517068 - Error: 'Invalid column name' when refreshing a report based off Salesforce.
    • 2521080 - Error: 'HY000: General error: string too long' when refreshing a report based off Salesforce.com Command Object.
    • 2522744 - Error: '42000: Syntax error near <Query>' when refreshing a report based off Salesforce.com Command Object.
    • 2522708 - Error: 'HY000:QUERY_TOO_COMPLICATED' when refreshing a report based off Salesforce.com Command Object.
    • 2521446 - Error: 'HY000:INVALID_FIELD' when refreshing a report based off Salesforce.com Command Object.
    • 2383365 - Error: 'INVALID_QUERY_LOCATOR', when refreshing a report based off Salesforce.
    • 2118506 - Error: Failed to retrieve data from the database. Qualified column could not be bound
    • 2521442 - Error: 'HY000:MALFORMED_QUERY' when refreshing a report based off Salesforce.com
    • 1976422 - Error: 'HY000:MALFORMED_QUERY' when refreshing a report based off Salesforce.com, that filter data on a date.
    • 2172544 - Error: 'A date is required here'; or 'A boolean is required here.' when refreshing a report based on Salesforce.com
    • 1942224 - Error: 'SF011:[Simba][Saleforce] (18) The table name does not exist. [Database Vendor Code: 18]'
    • 2127029 - Error: 'Cannot obtain error message from server.' when refreshing a report based on a Salesforce.com stored procedure
    • 2163336 - Error: 'Login failed: HY000:INVALID_LOGIN', when attempting to connect to Salesforce.com Sandbox from Crystal Reports
    • 2475299 - Error: 'Logon failed. HY000:[Simba][Saleforce] (60) Invalid Salesforce URL used for connection...'
    • 2204887 - Error: 'HY000:API_DISABLED_FOR_ORG: API is not enabled for this Organization or Partner'
    • 2067003 - Error: 'HY000:[Simba][Salesforce] (23) Error in Http request: Couldn't resolve host name [Database Vendor Code: 23]'
    • 2261004 - Error: 'HY000:[Simba][DSI] (40390) Internal error - SwapWriteError' when refreshing a report based on Salesforce.com
    • 2130829 - Boolean fields in Crystal Reports 2013 for salesforce.com stored procedure reports display as -1
    • 2247073 - No data returned when reporting off Salesforce.com Stored Procedures in Crystal Reports.
    • 2247074 - No stored procedures listed in Crystal Reports 2013 when connecting to Salesforce.com
    • 2247094 - Unable to see all the Salesforce.com Standard and Custom Reports under Stored Procedure in Crystal Reports.
    • 2247095 - Missing data when reporting off a Salesforce.com Stored Procedure in Crystal Reports 2013
    • 2174175 - What does the option: Use Analytic API do, when connecting to Salesforce.com from Crystal Reports?

Keywords

Sforce, CR, Saleforce, Salesforce, SFDC, Master Knowledge Base, Master KBase , KBA , sforce , salesforce , crystal reports salesforce.com , 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