topic Re: Output Data - Issue with quotes around schema and table name when writing to oracle in Alteryx Server Discussions

Output Data - Issue with quotes around schema and table name when writing to oracle

ayx-droid — Thu, 14 Apr 2022 07:30:06 GMT

I'm having issue while updating tables in a different schema on Alteryx Server (Version: 2021.3.1.47945). The problem is caused by alteryx pre-sql when sent to oracle. it adds quotes around "Schema_Name.Table_Name"

When I run this on designer (Version: 2021.2.2.45235), it just runs fine by putting quotes to both schema and table "Schema_Name"."Table_Name".

Error message:

Error running DELETE FROM "SCHEMA_NAME.TABLE_NAME": ORA-00942: table or view does not exist

Output data settings:

I've hit [roadblock after trying quote style with different settings but could not resolve it. Any thoughts on why it runs on designer version but errors on server?

Output Data - Issue with quotes around schema and table name when writing to oracle

ayx-droid — Thu, 14 Apr 2022 09:31:52 GMT

having issue while updating tables in a different schema on Alteryx Server (Version: 2021.3.1.47945). The problem is caused by alteryx pre-sql when sent to oracle. it adds quotes around "Schema_Name.Table_Name"

When I run this on designer (Version: 2021.2.2.45235), it just runs fine by putting quotes to both schema and table "Schema_Name"."Table_Name".

Error message:

Error running DELETE FROM "SCHEMA_NAME.TABLE_NAME": ORA-00942: table or view does not exist

Output data settings:

I've hit roadblock after trying quote style with different settings but could not resolve it. Any thoughts on why it runs on designer version but errors on server?

Re: Output Data - Issue with quotes around schema and table name when writing to oracle

gabrielvilella — Thu, 14 Apr 2022 13:37:16 GMT

Since you could determine that this issue is present in a specific Alteryx version, I encourage you to send this to support@alteryx.com so they are aware of this issue and can correct on a future update.

Re: Output Data - Issue with quotes around schema and table name when writing to oracle

apathetichell — Fri, 15 Apr 2022 18:46:20 GMT

Can you humor me and swap from "|||" to "|" in your output data tool? - give that a try.