Skip to Content
0
May 18, 2020 at 06:11 PM

2713362 - Numeric Overflow: Search Table Error: [6944]

281 Views Last edit May 19, 2020 at 01:45 PM 4 rev

Hi Experts,

My HANA DB RELEASE : 1.00.122.22..

As per the note tying to add hint

WITH HINT (NO_CS_PROJECT, NO_USE_HEX_PLAN);

but getting an error as Invalid Hint when using NO_USE_HEX_PLAN .

NO_CS_PROJECT is working well if I give in the individual select statement but not in the union statement as shown below and it is giving the same message Numeric Overflow: Search Table Error: [6944] , please advise.

select fields from tabl1 innerjoin tab12

union

select * from tabl3 innerjoin tabl4

union

select from tabl5 innerjoin tabl6 on ....

and ...

with hint(no_cs_project);