1469862 - Error: Database logon failed. (LO26603) while refreshing Crystal Xcelsius(Xcelsius) model

SAP Knowledge Base Article - Public

1469862 - Error: Database logon failed. (LO26603) while refreshing Crystal Xcelsius(Xcelsius) model

Symptom

Try refreshing an Xcelsius report based on Crystal report gives error: "Error: Database logon failed. (LO26603)"

Reproducing the Issue

  1. Create a Crystal report and save it to Enterprise folder.
  2. Import the Crystal reports content to Live Office.
  3. Create an Xcelsius model based on that Crystal report.
  4. Publish the Dashboard to Enterprise.
  5. Log on to Central Management Console.
  6. Navigate to the folder where Crystal report and Xcelsius is saved.
  7. Right click on the Crystal report.
  8. Go to Database Configuration
  9. Change the Database server from existing one to new one.
  10. Save changes and open the Xcelsius model.
  11. It gives an Error: Database logon failed. (LO26603)

Cause

The Xcelsius model is still pointing to the Crystal Report’s old datasource location as the set datasource location is not updated and not pointing to the new database server.

Resolution

  1. Open the Crystal report saved in the Enterprise folder.
  2. In Database select Set Datasource Location
  3. Change the Current datasource location with the new server and click Update
  4. Publish the Crystal report to Enterprise with same name.
  5. Open the Xcelsius model and now it refreshes properly.

Keywords

Xcelsius refresh,Database logon error,LO 26603 , KBA , BI-RA-XL , Dashboards and Presentation Design , How To

Product

SAP BusinessObjects Xcelsius Enterprise 2008