SAP Knowledge Base Article - Public

2050814 - Database Password stored on the SAP BI Server reset after updating the report in Crystal Reports

Symptom

  • Database password reset.
  • Keyword and Description for the report are erased.
  • When attempting to view a report that has been updated in SAP BI LaunchPad, it fails due to incorrect login credentials.
  • When updating a report in Crystal Reports designer, and saving it back to the SAP BusinessObjects Repository, the database password, keywords, and description are reset to blank.
  • How to avoid resetting the report database password, keywords and description after modifying a report in Crystal Reports and saving it back to the SAP BI Server?

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
         
  • SAP BusinessObjects Business Intelligence Platform 4.0
  • SAP BusinessObjects Business Intelligence Platform 4.1
  • SAP BusinessObjects Business Intelligence Platform 4.2

Reproducing the Issue

  1. In Crystal Reports designer, create a report off any data source.
  2. Save the report to the SAP BusinessObjects Repository.
  3. Logon to the Central Magement Console (CMC), and set the user name and password for the report connection.
  4. When refreshing the report on SAP BI LaunchPad, the report can be viewed successfully.
  5. Open the report in Crystal Reports designer.
  6. Update the report as needed, like add a text object, or format a section, ...
  7. Save the report back to the SAP BusinessObjects Repository.
  8. When attempting to view the report in SAP BI LaunchPad, it fails, due to incorrect database password.
               
    When looking at the report Database Configuration in the CMC, notice the database password has been reset.
    How to avoid reseting the database password every time the report is modified?
       
     
    Password Reset.png

Cause

  • By default, when updating a report in Crystal Reports designer, and saving it back to the SAP BusinessObjects Repository, it will reset the database password stored on the SAP BI Server for this specific report to blank, and update the report Keyword and Description.

Resolution

  • To avoid reseting the database password stored on the SAP BusinessObjects Repository, and to avoid updating the report Keywords or Description, uncheck the option: "Update Enterprise Report Properties on Save"
         
    1. Open Crystal Reports.
       
    2. Under the menu "File", select "Options"
         
    3. In the "Options" window, under the tab "Reporting", uncheck the option: "Update Enterprise Report Properties on Save"
        
        Update Report Properties.png
          
       
    4. Click "OK" to accept the change.

Keywords

CR, Save, password reset , 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