External error ORA-00907 missing right parenthesis

Problem:

When creating a Custom Query in a Data Connection, and pressing the Validate button, you might get the error "missing right parenthesis".

This could be because the custom SQL was developed and tested outside of Spotfire.  The query runs OK in the database client.  But when copied into the custom query box and Verify is pressed, this error is seen.

Solution:

Make sure the custom query does not end with a semi-colon ;

It is normal for SQL queries to end with this, but the Spotfire Client wraps this custom query inside another query to test the syntax is valid.  This leads to the semi-colon ending up in the middle of the test query and terminating it prematurely.

This box will be hidden from the public.
Case reference #231038