Error:SQL problems: Unexpected exception occurred within query compilation

[tnyjr]

Hi all,

I hope somebody can help me with the following error while issuing SQL query against a VW database using iReport. The error is:

Error:SQL problems: Unexpected exception occurred within query compilation

My SQL query has 9 JOINs. If I remove one of the JOINs, it worked fine. The version of VW I'm using is:

VectorWise Version VW 1.6.0 (a64.lnx/115)NPTL

Can somebody please help me resolve the problem? Thanks.

[marcin]

It might be something that is fixed in more recent releases, it's impossible to say without the schema/data.

Any chances you can try Vectorwise 2.0? Or provide query/schema/data?

If you're running 1.6 for production, you can also contact the official support if you prefer to keep details confidential.