Skip to Content
0

How to insert data into identity column in SAP HANA ( HCI) JOB

Jun 06, 2017 at 08:55 PM

42

avatar image

Hi Team,

We are using SAP HANA job ( ETL Tool) to read data from csv file and insert into database table.

Data is inserting properly in the database table if there is no identity column(auto incremental) defined in the table as we have matching columns in csv file and DB table.

But, we have identity column in DB table, running the job to insert data from csv file to DB table is giving me the following error.

2017-06-06 20:21:17 (E)(10068:9004) VAL-30177 |SESSION FILE_BAM_USER_READING|DATAFLOW FILE_BAM_USER_READING_USER3|STATEMENT <GUID::'NwFjHdNzgqKnzg3vy1jz1l' LOAD TABLE DAS_BAM_DEV.BAMDEV.BAM_USERS1 INPUT(Target_Query)> Column <ID> is a key column for target <BAM_USERS1>, but does not match any column from the input schema and the target's <use input key> option is not ON. 2017-06-06 20:21:17 (E)(10068:9004) VAL-30177 |SESSION FILE_BAM_USER_READING|DATAFLOW FILE_BAM_USER_READING_USER3|STATEMENT <GUID::'NwFjHdNzgqKnzg3vy1jz1l' LOAD TABLE DAS_BAM_DEV.BAMDEV.BAM_USERS1 INPUT(Target_Query)> Column <ID> is a key column for target <BAM_USERS1>, but does not match any column from the input schema and the target's <use input key> option is not ON.

Please see attached screenshot of the dataflow.

This is a simple read from CSV file and inserting to a table.

Sorry i posted this in SAPUI5,

please let me know where should i post this question, this is related to SAP HCI ETL Tool

dataflow.jpg

dataflow.jpg (61.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers