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?
