error writing to an existing table

MLoren001 — Sun, 10 Sep 2023 21:50:11 GMT

The workflow I am stuck is supposed to read in a table from one Oracle DB, joined it with another table, and write the transformed table to a different Oracle DB. Very simple.

I first created the table in the 2nd Oracle DB using Alteryx output tool. No issues.

I then updated the output tool configure to Update: Insert if New then went into the RDBMS and set up a Primary Key on the destination table.

When I run the workflow on my local machine, it runs fine and updates table. No issues.

However, when I publish the workflow on the gallery and run it I get this error:

Error creating table [tablename] [Simba][OracleOCI] (3000) Oracle Caller Interface: ORA-00955: name is already used by an existing object

Very confusing as I am not trying to create a new table and my configuration appears to be set correctly. Can anyone please provide tips?

Re: error writing to an existing table

Peachyco — Tue, 12 Sep 2023 07:06:33 GMT

Could it be an issue with the ODBC configurations? Maybe the workflow is relying on the ODBC on your local machine, and it isn't working properly with the different ODBC on the Gallery machine.

topic error writing to an existing table in Alteryx Server Discussions

error writing to an existing table

Re: error writing to an existing table