Failed to execute query

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