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