SQL Workflow Runs Fine Locally but Gives Error on Alteryx Server
- 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
I have a workflow that create temporary tables in Teradata and does inserts and updates to the table (using PreSql). When I run the workflow locally it runs fine but on Alteryx server I get an error saying 'object (the temporary table I created) could not be found' even though it has already been created. Please help.
Thank you!
- Labels:
- Server
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Does your connection string embed the credentials it should use or is it using Windows authentication? If the latter, it could be that the service account your server is configured to run jobs as may not have the necessary permissions to create temp tables.
You may also check the version the server has of the ODBC Teradata driver and confirm that it's a version that Alteryx has validated (https://help.alteryx.com/20212/designer/teradata).
If neither of these apply, reaching out to your DB admin would be your best option so that they can review the TD logs to see why the temp table is not being created.
Hope this helps!
-Jimmy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The Temp table is being created but I get an error during an update statement.
