HANA : The inserted value is too large for the column

Short Text

The value inserted for the column is larger than the column size defined during creation of the table

HANA_Import_Error

Cause

The inserted value is too large for the column

Recommendations

Check the file and make sure that the data in the file is not larger in size than the column

Error Message

Batch from record 15485 to 17696 failed:
SAP DBTech JDBC: [274]: inserted value too large for column: TrexUpdate failed on table 'ITSITI:BSEG' with error: AttributeEngine: indexed value not within specified range;checkCesu8StringColumn(): 
max length violated on pos 240, value=DAANI;column 'USNAM', table 'ITSITI:BSEG', rc=6959(input position 266)
SAP DBTech JDBC: [274]: inserted value too large for column: TrexUpdate failed on table 'ITSITI:BSEG' with error: AttributeEngine: indexed value not within specified range;checkCesu8StringColumn(): 
max length violated on pos 240, value=DAANI;column 'USNAM', table 'ITSITI:BSEG', rc=6959(input position 266)

Exception

com.sap.db.jdbc.exceptions.BatchUpdateExceptionSapDB: 
SAP DBTech JDBC: [274]: inserted value too large for column: 
TrexUpdate failed on table 'ITSITI:BSEG' with error: 
AttributeEngine: indexed value not within specified range;checkCesu8StringColumn(): 
max length violated on pos 240, value=DAANI;column 'USNAM', table 'ITSITI:BSEG', rc=6959(input position 266)
at com.sap.db.jdbc.CallableStatementSapDB._executePreparedBatch(CallableStatementSapDB.java:759)
at com.sap.db.jdbc.CallableStatementSapDB._executePreparedBatch(CallableStatementSapDB.java:615)
at com.sap.db.jdbc.CallableStatementSapDB.executeBatch(CallableStatementSapDB.java:1864)
at com.sap.ndb.studio.bi.filedataupload.deploy.populate.PopulateSQLTable.populateTable(PopulateSQLTable.java:156)
at com.sap.ndb.studio.bi.filedataupload.ui.job.FileUploaderJob.uploadFlatFile(FileUploaderJob.java:201)
at com.sap.ndb.studio.bi.filedataupload.ui.job.FileUploaderJob.run(FileUploaderJob.java:61)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

You May Also Like

Leave a Reply?