1877154 - Running Crystal Reports for Enterprise gives the Query Execution Error: Failed to execute query: '[] <com.businessobjects.dsl.commons.exception.NestedException:1>'.Redesign your query or contact the data source maintainer to solve the problem

SAP Knowledge Base Article - Public

1877154 - Running Crystal Reports for Enterprise gives the Query Execution Error: Failed to execute query: '[] <com.businessobjects.dsl.commons.exception.NestedException:1>'.Redesign your query or contact the data source maintainer to solve the problem

Symptom

While refreshing a report from Crystal Report for Enterprise gives the error "[] <com.businessobjects.dsl.commons.exception.NestedException:1>'.Redesign your query or contact the data source maintainer to solve the problem".

Environment

SAP Crystal Reports for Enterprise

Reproducing the Issue

  1. Launch SAP Crystal Reports for Enterprise.
  2. Run the report based on the BEx Query and it gives the error.

Cause

  • This is due to scaling factor applied on the BEx Query Designer.
  • It needs to be changed at the report level.

Resolution

To Display the SAP BW BEx Query Measure with the Scaling factor:

  1. Insert the field on the report canvas
  2. Right click the field.
  3. Select Format field object element
  4. Go to Advanced
  5. Open Formula Workshop for Display String.
  6. Add the following code: totext(field/scaling factor)
  7. Click to Save and close.
  8. Click to OK.

Note: The scaling factor should be same as selected at the query level.

Keywords

Crystal Reports for Enterprise, BEx Query , Execute , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011