Alteryx error using inDB
- 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
Hello all,
I'm receiving an error when using inDB Teradata ODBC v16.x or v17.x. When my script is using '<' or '<>' operators it returns
'Connect In-DB (1) Error parsing xml: Message=expected element name, Location=> (deleted field names)'
The same script works fine with Input Data method. This happens on my Designer 2022.3 and 2023.1 versions, as well as on the server 2022.3
I submitted a ticket with Alteryx and they were not able to replicate the issue. I tried another script in inDB SQL and worked fine. Same script works fine in Teradata.
I'm curious is there anybody else have the same problem? Because I have the issue on both server and my local computer, this shows the issue is not directly related to me.
This is the XML output and it looks fine for me. '>' operator works fine.
AND (C_A <> C_LSFDS) AND
Thanks
Alteryx ACE
https://www.linkedin.com/in/alaluf/
- Labels:
- In Database
- Settings
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It could be a particular issue with the ODBC driver that you're using. Try using != instead of <>. According to the TeraData documentation, this is accepted.
Dan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@danilang Unfortunately != is not working, it returns an error. I don't worry about this that much, I can use NOT IN instead. But, '<' is not working.
Alteryx ACE
https://www.linkedin.com/in/alaluf/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I decided to reopen my case with Alteryx support.
Today I tested with Teradata ODBC 16.2. All worked fine with input data, but inDB is failed. This happens on both client and server. I run ODBC debug, provided to support.
Alteryx ACE
https://www.linkedin.com/in/alaluf/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Did you ever get an answer to this albert? I am running into the same issue with Teradata. Non In-DB tools are running my queries successfully, but In-DB doesn't seem to allow <>, <=, or >= in teradata.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm encountering the same problem here with SQL Server - anyone got a solution?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am having the same issue with Athena in in-DB. The script works in Athena and in the normal input data tool.
I think the issue is with the generic odbc driver in the in-DB tool, it does not like some of the operators in the script and has trouble translating it from the generic odbc to Athena.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @Brinker - I replied to your post the other day, not sure if you missed it but if so:
I ran into this exact issue recently when querying Snowflake via the In-DB tools. I believe the problem is caused by the query not being escaped properly in terms of special XML characters (<> etc). I got around this by escaping them myself i.e. instead of <= or >= I would use <= or >= respectively. Escape characters found here: https://stackoverflow.com/questions/1091945/what-characters-do-i-need-to-escape-in-xml-documents. Hope this helps!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is an old topic, but I ran into the same issue and the solution for me was pretty simple.
In my connection (within alteryx - update with manage connections) I unchecked DCM - Use Data Connection Manager (DCM). Hopefully that saves someone a bit of time troubleshooting.
My snipping tool doesn't let me post in the community or I'd post images to show better.
