SAP Knowledge Base Article - Public

2243216 - Unable to login or refresh report created in Crystal Reports off Salesforce.com that connect to the url: www.salesforce.com after January 1, 2016

Symptom

  • Fail to login to Salesforce.com from Crystal Reports.
  • Unable to refresh report based on Salesforce.com in Crystal Reports and in BI LaunchPad.
  • All report created in Crystal Reports off Salesforce.com, using the server url: www.salesforce.com, will fail to connect to Salesforce.com from January 1, 2016.
      
       
  • 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 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
           
  • SAP BusinessObjects Enterprise XI 3.1
  • SAP BusinessObjects Business Intelligence Platform 4.0
  • SAP BusinessObjects Business Intelligence Platform 4.1
  • SAP BusinessObjects Business Intelligence Platform 4.2
       
  • Salesforce.com

Reproducing the Issue

  1. In Crystal Reports, create a report off Salesforce.com using the default server url: www.salesforce.com
  2. Add database fields to the report, and save the report.
  3. Currently, it is possible to successfully refresh the report, but from January 1, 2016, the report will fail to refresh.

Cause

  • By default, when creating a report in Crystal Reports to connect to Salesforce.com, it is connecting using the url: www.salesforce.com
      
  • Application connecting to Salesforce.com via the API url: www.salesforce.com will no longer be able to connect from January 1, 2016, because Salesforce will retire this url.
      
  • All application connecting to Salesforce.com using the API will then be required to use the server url: https://login.salesforce.com
           
  • For reference, see the Salesforce Knowledge Article Number 000229717 

Resolution

  • To connect to Salesforce.com from Crystal Reports, update the reports to use the url: https://login.salesforce.com
        
    1. Open the report based off Salesforce.com in Crystal Reports
          
    2. Under the menu "Database", select "Set Datasource Location..."
         
       New URL SForce - 01.png  
           

    3. In the "Set Datasource Location" window, under current Data Source, expend the Properties, and double click on Server to change the url.
          
    4. Enter the Server url: login.salesforce.com, and hit enter.
         
      New URL SForce - 02-01.png  
             

    5. In the "Salesforce.com" window, enter the Salesforce.com user name and password, and click "Finish"
         
       New URL SForce - 04.png   
         
          
    6. Back to the "Set Datasource Location" window, you will notice the Server url is now equal to: https://login.salesforce.com
      Then click the "Close" button.
           
    7. Save the report.
           
      The report will now be able to connect to Salesforce.com, and refresh successfully, before and after January 1, 2016.
         
                
  • Notes:
    • In the latest update of Crystal Reports, when creating a new report off Salesforce.com, the default url is now: login.salesforce.com, but for any existing report, that were created in older version of Crystal Reports, the url will need to be updated manually for each report. ( SAP Note: 2228442 )
              
    • It is recommended to update all reports created off salesforce.com to the url: login.salesforce.com, for reports created before January 1, 2016, with an older version of Crystal Reports, otherwise the reports will fail to refresh after this date, due to Salesforce.com deprecating the url: www.salesforce.com

Keywords

  • SForce, API change, CR
, KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

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