Some of XSA table columns updated with NULL values - though column is not SET in UPDATE statement

[ssurampally]

Hi, We recently migrated our HANA system to XSA, created all tables as design time artifacts in Web IDE for HANA. Then, we load data into HANA table from an external Source periodically using SQL procedure updates , we are noticing that couple of columns are updating to NULL value with no reason, even though those columns are not SET in UPDATE statement. We did not notice this behavior in XS classic.

Later, we update the column with correct values manually, but next load is updating back to NULL values for those records. Can you help us in understanding why this inconsistent behavior in XSA? is it a bug in the design?

Note: an observation on this problem, the table columns having this problem are listed after the generated columns in the order of the table structure.

[lbreddemann]

You may want to add which HANA revision you're on and provide example code of your procedure and your data loading so that this can be reproduced.

[ssurampally]

Hi Lars, Actually I tried to recreate issue outside of existing data flow. But I couldn't succeed in doing so. attaching the file used to recreate column-updating-to-null.txt . So it is not a general problem in design. there must be something else is a problem in my stored procedure. I will debug the stored procedure with small number of records and see if the problem occurs or not.

so for now, I have no further question, I will update with my findings later.