database update node fails

KNIME Analytics Platform
1

I'm recently switched to KNIME SDK 2.11. Executing a wf in which I update an ORACLE database table, the node return this message:

WARN      DatabaseWriterConnection           Error while updating row #1 (Row1_CHD-00519), reason: ORA-00904: "cpd_database_counter": invalid identifier

WARN      DatabaseWriterConnection           Error while updating row #2 (Row2_CHD-00520), reason: ORA-00904: "cpd_database_counter": invalid identifier

WARN      DatabaseWriterConnection           Error while updating row #3 (Row3_CHD-00521), reason: ORA-00904: "cpd_database_counter": invalid identifier

WARN      DatabaseWriterConnection           Error while updating row #4 (Row4_CHD-00522), reason: ORA-00904: "cpd_database_counter": invalid identifier

WARN      DatabaseWriterConnection           Error while updating row #5 (Row5_CHD-00523), reason: ORA-00904: "cpd_database_counter": invalid identifier

WARN      DatabaseWriterConnection           Error while updating row #6 (Row6_CHD-00524), reason: ORA-00904: "cpd_database_counter": invalid identifier

WARN      DatabaseWriterConnection           Error while updating row #7 (Row7_CHD-00525), reason: ORA-00904: "cpd_database_counter": invalid identifier

WARN      DatabaseWriterConnection           Error while updating row #8 (Row8_CHD-00526), reason: ORA-00904: "cpd_database_counter": invalid identifier

WARN      DatabaseWriterConnection           Error while updating row #9 (Row9_CHD-00527), reason: ORA-00904: "cpd_database_counter": invalid identifier

WARN      DatabaseWriterConnection           Error while updating row #10 (Row10_CHD-00528), reason: ORA-00904: "cpd_database_counter": invalid identifier

WARN      Database Update                    Errors "10" updating 10 rows.

Using the KNIME SDK 2.10 the update node works fine because "cpd_database_counter" is the valid identifier.

Any suggestions?

regards

Andrea

2

Hi Andrea,

this might be an issue with case sensitivity. Have you tryed to rename the cpd_database_counter column to all upper case prior using the Database Update node? Oracle uses all upper cases as default if the column name isn't quoted. You can also have a look at the KNIME log to see if KNIME quotes the column name in the update statement. To view the log file open KNIME an go to View->Open KNIME log.

Bye,

Tobias