2142387 - Application Exception Error occurs when refreshing a report in Crystal Reports based off a Universe

• Crystal Reports close unexpectedly.
• After modifying the query of a report, Crystal Reports generate an application exception error.
• When refreshing a report based off a Universe, it generate the following error, and close:
         
  "Application Exception"  
  "Please send C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\crw32.dmp to program author." 
     
          

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

1. In Crystal Reports, create a new report off a Universe based on a stored procedure.
     
2. Save the report.
     
3. Open the report in Crystal Reports, and add to the query at least one more object from the Universe.
• To add an object to the query, select "Query Panel", under the menu "Database".
• In the "Connections based on Universe", window, click "Edit"
• In the "Business Objects Query Panel", add at least one object to the "Result Objects"    
• Click "OK" to accept the change.       
      
4. When refreshing the report, it generate the following error, then close:
      
   "Application Exception"  
   "Please send C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86.dmp to program author."

• This issue only occurs when the Universe is based off a stored procedure.
• The issue has been tracked under the SAP Note 2142400

• There is unfortunately no product update that resolves this issue at this point.
    
• To workaround this issue, add the new database fields that was added to the query, to the report design:
      
1. In Crystal Reports, open the report based off a Universe that points to a stored procedure.
       
2. If the report open with "Saved Data" under the "Preview" tab, select the "Design" tab.  
   
   Note: This is a very important step, because if the report is under the "Preview" tab, it will automatically attempt to refresh the report after modifying the query, and therefore, Crystal Reports will generate the error we are attempting to avoid.
         
3. Modify the query, by adding at least one new object to it.
• To add an object to the query, select "Query Panel", under the menu "Database".
• In the window "Connections based on Universe", click "Edit"
• In the window "Business Objects Query Panel", add at least one object to the "Result Objects"   
      
  In the example below, the Dimension Country is added.
    
      
     
• Click "OK" to accept the change.  
     
4. Back to the "Design" view of the report, add the new database fields to the report design, by dragging the database fields from the "Field Explorer" pane to the report.  
      
   In  the example below: The Country database field has been added to the Details section of the report, which was the one added in the Query Panel in the previous step.
          
     
      
5. The report will now refresh successfully.

• 1706630 - Crystal Reports 2011 close when attempting to create a report based off a Universe that uses contexts

CR, UNV, crash , KBA , crw32.dmp , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed

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