While executing bulk insert over the function module TREX_EXT_INDEX_CELL_TABLE or TREX_EXT_INDEX_CELL_TABLE_V2,
following runtime error:
Runtime Errors CONVT_OVERFLOW
Except. CX_SY_CONVERSION_OVERFLOW
ABAP Program CL_HDB_BULK_TABLE_UPDATE_UTIL=CP
This error occur When data conversion functions (ex. TO_TIMESTAMP) are required for the bulk insert call, those information needs to be stored internally for generating an SQL statement. The internal table which stores such intermediate information can accept up to 255 lines. And if the number of columns of the bulk insert table is more than the limit. It leads to the runtime error described above.
1. Apply the correction in 2215961.
2. Tr-SE38 and execute the ABAP report NOTE_2215961.
On the selection screen, select the radiobutton for "Step 2" (UPDATE & ACTIVATE...).
Press F8 or execute icon.
If you are asked to enter a transport request number for the changes, enter your own request number. If you do not have any, you need to create a new one.
3. Make sure the following objects have been newly created:
Tr-SE11, select the radiobutton for "Data type", enter "HDBS_SQL_OPTION", and press "Display" button.
Tr-SE11, select the radiobutton for "Data type", enter "HDBT_SQL_OPTION", and press "Display" button.
If you can display the above objects without any error, it is ok.