SAP Knowledge Base Article - Preview

3679766 - Could not execute 'DELETE FROM "XXXX"."XXXXXX~" WHERE "$rowid$" IN (SELECT ROW_ID FROM (SELECT "$rowid$" ...' Error: (dberror) [260]: invalid column name: XX: line _ col _ (at pos _)

Symptom

You executed the SQL script 'HANA_Data_DuplicateKeys_ColumnStore_Deletion_CommandGenerator_1.00.100+.txt ' from the collection provided in SAP Note 1969700, which generated a DELETE command to remove duplicate entries. However, you encountered the following error while attempting to run the DELETE command:

Could not execute 'DELETE FROM "XXXX"."XXXXXXXX" WHERE "$rowid$" IN (SELECT ROW_ID FROM (SELECT "$rowid$" ...'
Error: (dberror) [260]: invalid column name: DUP_NO: line 1 col 148 (at pos 148)  


Read more...

Environment

SAP HANA Platform Edition

Product

SAP HANA, platform edition all versions

Keywords

HANA_Data_DuplicateKeys_ColumnStore_Deletion_CommandGenerator_1.00.100+.txt 

 (dberror) [260]: invalid column name , KBA , HAN-DB , SAP HANA Database , Known Error

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.