primary Key required for Update option - Oracle ODBC but Primary Keys do exist

All,

Primary Key is available in Database (Oracle Cloud) But Alteryx ODBC Output data unable to detect. Can somebody please help?

Error Message : Output Data (23) Primary Key required for Update option

ODBC Settings :

Field Mappings :

key Defined in Database :

Options Tried :

Dropped and recreated PK with different names - No success

Tried Append Data in Output and it worked fine with inserting records so Column name is not an issue

Dropped and recreated table with constraint ,didn't work

Changed None/Quoted in SQL style, didn't work

I have seen couple of posts related to the same issue but none of the solution worked for me. My source is flat file and target is Oracle Cloud. I would really appreciate if someone shares their idea.

Workflow

Developer

Developer Tools

Tips and Tricks

Transformation

In Database

In-Database

Accepted answers

vepp

Just for others who look for solution :

odbc:DSN=COnnectionName|||SchemaName.TableName -> This is required for Updates/Deletes

odbc:DSN=COnnectionName|||TableName -> Insert was working without schema name

Even though we have hard coded the schema name in ConnectionName, it does not pickup for Updates. The error was also misleading. I am sure its a bug in Alteryx. It should not work differently for different type.

All comments

joshuaburkhow

Did you also try via OleDB instead of ODBC per this article or using the preSQL statement?

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Primary-Key-Required-for-Update-Option-but-Primary-Key-Exists/td-p/194412

Screen Shot 2019-09-23 at 1.35.34 PM.png

vepp

Nope, none of the option worked. I tried Both.

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177