database update node fails

KNIME Analytics Platform
#1

Dear all

I 'm using knime SDK 2.11. I have a wf that update an oracle table using as WHERE column the cpd_database_counter. With 2.10 version all worked well. Today I noticed that when I execute the node I obtain no updating and this messages of error:

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

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

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

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

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

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

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

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

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

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

WARN      Database Update                    Errors "10" updating 10 rows.

Have you 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