Error SQLPrepare expected something between '(' and ')'
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
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.
Chris
- Labels:
- Error Message
- Gallery
- Publish
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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,
Samuel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
