Skip to Content
0
Sep 27, 2021 at 09:39 AM

HANA Error: inserted value too large for column: Failed in "" column with the value 2002

504 Views

Hello,

when executing a calculation view* (with table function) on HANA (Release 1.00.122.25) the following error is thrown:

SAP DBTech JDBC: [274]: inserted value too large for column: Failed in "" column with the value 2002

but I cannot understand what column is affected or where the value 2002 comes from since there is "" before column in the message. In addition this error goes away if I add some filters in the where condition but it's not related directly to that filter. For example if I do not filter the month field the error is thrown BUT if I filter from january to june is NOT thrown and also if I filter only from july to december is NOT thrown too. So it's not like there is a specific record/field that causes the issue.

*the error is also thrown when executing directly the code from the SQL console.

This CV reads from:

- external view made on BW infocube

- another CV (table function) 2 times in left join

- two tables in left join

I already tried to strip down the code in order to isolate the cause of the issue and now the code is based only on:

- external view made on BW infocube

- another CV (table function)

but the problem still persists.

What can be the problem? Or how can I further investigate?

Thanks,

Regards

Michele