2241478 - Error: "The rowset column could not be found." when attempting to refresh or schedule a report off Salesforce.com in SAP BI LaunchPad

• Error: "The rowset column could not be found."
• Was able to successfully refresh the same report in the past.
• When refershing a report in SAP BI LaunchPad, that was created in Crystal Reports off Salesforce.com, it fails with the error:
    
    "The viewer could not process an event. 
      Error in file: < File Name>: The rowset column could not be found. [] ---- Error code:0
      [CRWEB00000119]"
         
        
      
      
     
• 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.

• SAP Crystal Reports 2013
• SAP Crystal Reports 2016
• SAP Crystal Reports 2020
    
• SAP BusinessObjects Business Intelligence Platform 4.1
• SAP BusinessObjects Business Intelligence Platform 4.2
• SAP BusinessObjects Business Intelligence Platform 4.3
    
• Salesforce.com

1. In Crystal Reports, create a report off a Salesforce.com Stored Procedure.
2. Save the report to the SAP BuinessObjects Enterprise Repository.
3. Logon to SAP BI LaunchPad, and refresh the report. It refresh successfully.
4. Few days later, refresh the same report in BI LaunchPad, and it fails with the error:
         
     "The viewer could not process an event. 
       Error in file: < File Name>: The rowset column could not be found. [] ---- Error code:0
       [CRWEB00000119]"

• The report is created off a Salesforce.com Stored Procedure.
• The error occur because the Salesforce.com Stored Procedure was modified. Since it does not output all the same database fields, it generates the error message.
• Note: A Salesforce.com Stored Procedure is actually a report created in Salesforce.com. In external application like Crystal Reports, it displays as a stored procedure.

• The report definition needs to be updated in Crystal Reports designer.
          
1. Open the report in Crystal Reports designer.
2. Under the menu "Database", select "Verify Database"
3. When it display the message: "The database file <Report Name> has changed. Proceeding to fix up the report.", click "OK"
      
      
          
        
4. If it is not possible to automatically mapped the database fields, it will then display the "Map Fields" window. 
   Manually map the database fields, and click "OK"
        
      
           
          
5. Once completed, it will display the message: "The database is now up to date"
      
       
           
        
6. Save the report back to the SAP BusinessObjects Enterprise Repository.
             
   Note: If some database fields that were removed from the Salesforce.com stored procedure were used in formula, group, chart,... You will need to modify the formula, group, chart,... before being able to successfully refresh the report, and save it to the SAP BusinessObjects Enterprise Repository.

SForce, CR, SProc, StoredProcedure , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , Problem

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