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

[abhilash_kumar]

Hi Morris,

Do you get this error with all BEx queries?

Could you use the same BEx query with WebI and see if you can successfully report off of it?

If this happens only with the query in question just with CR, then you might have to check if there is something specific in the query that is causing the issue.

If there is a Test system, try upgrading to SP05 and check again.

-Abhilash

[Former Member]

Hi Abhilash,

I do not get this error when I run this query in BW transaction RSRT as well as Analysis.

I ran this same query in webi and it gave me this error. The problem seems to be with BOBJ because it works fine with Analysis and BW.

We don't have any test system currently, only DEVELOPMENT system.

We will upgrade to SP5 and get back to you.

Thanks