Failed to execute query

[Former Member]

Hi Guys

I am getting the following error when i run my crystal report for enterprise

Failed to execute query: '[] <com.businessobjects.dsl.commons.exception.NestedException:1>'.Redesign your query or contact the data source maintainer to solve the problem.

My Crystal Report is based on a Bex query. The report does not use Interval date variable, neither does it use variable values for a BEx query with cell edition.

I am running BOE 4.0 SP 4 on my both my client machines and the server.

Has anyone came across this error before, please advise.

Morris

[Former Member · Accepted solution]

Hi Abhilash,

Thanks for your continued helpful prompt responses at all times.

The issue above is solved and it was due to the scaiiling factor in Bex Query Designer and i did the following:

To display the SAP BW
BEx Query Measure with the Scaling Factor,

inserted the Field: Formatted Value of the Measure on the report.

-The Field: Formatted Value of the Measure will respect the Scaling

Factor set in the SAP BW BEx Query

[abhilash_kumar · Accepted solution]

Thanks for letting us know Morris. Appreciate it!

-Abhilash