de.uplanet.jdbc.StandardDbException: Error: -1, SQLState: 42x01: syntaxfehler: Encountered "("

If you are reading this post, certainly you are using INTREXX. I will not give you a direct answer but rather some clues that will help you to find the errors.

1.  Take a break and drink a glass of water because there is a silly mistake in your code
2.  Have you changed your data group ? 
3. Recheck carefully all data types with the references, if possible rewrite your query
4. Check your punctuations: comma, semicolons...
5. Make sure you have the right syntax for your query operation

Feel free o drop a comment sharing with us your experience with this error. If it persists feel free to knock me.

Regular expression for the file name without extension in Groovy

Are you willing to get rid on the file extension in groovy, but don't know how to do that ? This post is for you. If you are a programmer, you will not certainly want to read many useless lines before getting what you.
This line is for you:

file.name.replaceFirst(~/\.[^\.]+$/, '')

All credits go to Nikita 

Namaste