We are uploading a csv file into HANA database, during the upload running, it is failed due to below error message,
[ROLLBACK] – inserted value too large for column:
Failed in “xxx” column with the value ‘
Solution
In our case, we are using the command line step to load the csv file into HANA database. It’s highly recommended to output the trace log file to any accessible path, if failure occurred.
This will ease your troubleshooting and can route you to the specific column and error.
- Increase the dimension of the column table i.e 1, 4, 10
- Ensure the correct SQL data type assigned i.e VARCHAR, NVARCHAR
- Check the csv file, most of cases, it’s due to the source csv file was corrupted that cause the load failed.
- Refer to SAP Note 2725050 – SqlScript Execution Fails With “[274]: inserted value too large for column”
