Update Table NO RCP

[oracledba]

Source stage (Flat File):

Target stage (ODBC Connector) Usage:
Write mode = Update; Generate SQL = Yes; Table name = #target_table#

NO RCP with this job..

I have the primary key I want to update on selected in the target ODBC connector stage which matches the primary key in the database table

At runtime, I got the following error: Failed to generate where clause for update statement. No key fields defined in the design schema.

Update is done on a key column and yet this error pops up

Whats the problem here???

[chulett]

Curious why your table name is parameterized... will all tables being updated by this job have identical metadata?

I'd also be curious if you (as a test) replace the parameter with an actual table name, if the error goes away.

[oracledba]

tried replacing the parameter with the actual table name and the error doesn't go away (same error)

[ray.wurlod]

Please verify that each column to be mentioned in the WHERE clause is identified in the metadata as Key

[chulett]

It's generated SQL, so it will only put fields into the WHERE clause when they are marked as Key fields. I'm assuming that is what was meant by 'selected in the target ODBC connector stage' but please verify.

Still curious why the table name is parameterized.

[oracledba]

each column to be mentioned in the WHERE clause is identified in the metadata as Key which is the reason i am confused that I am getting this error.

[oracledba]

ok found the error...in the target ODBC connector the table name was referencing an old table since this job was copied from an older job. replaced with the current table name. reran the job with no problems.

Still this error from the log is very misleading and inaccurate.