We are aware of an issue with the Search bar. Please use Advanced search for the time being while we troubleshoot. Thanks for your patience as we work on improving the community!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Error SQLPrepare expected something between '(' and ')'

10 - Fireball



When publishing a Standard Workflow that reads Teradata input, we get this message:



The job 1st Test run of new version did not complete successfully and resulted in the following errors:

  • Error SQLPrepare: [Teradata][ODBC Teradata Driver][Teradata Database] Syntax error: expected something between '(' and ')'. (Tool Id: 1)


The workflow runs perfectly from Designer, just not from the server. Tool ID 1 is a Connection tool to Teradata. 


Any suggestions as to trouble shooting would be appreciated.



9 - Comet

Hi @Archaeopteryx ,


If you have access to the worker node, try to run your workflow by using the Alteryx Designer on the worker node to see if there is any error.


Best Regards,


10 - Fireball

We may put all the workflows on the server and see if that works. Currently, only the lead workflow is on the server with the chained workflows on the Network drive. The references to the chained workflows are all full machine paths.