Skip to Content
May 13, 2020 at 04:20 AM

Numeric overflow nested call



I am getting a weird error. We recently upgraded to SAP HANA 2.0

We have a SP1, which calls SP2 in the body.

Now, after the upgrade, the SP1 fails with the following error:

|Session <Job_NAME> SQL submitted to ODBC data source <> resulted in error <[SAP AG][LIBODBCHDB SO][HDBODBC] General error;314 numeric overflow: search table error: <SP Name>: line 108 col 2 (at pos 3427): [314] (range 3) numeric overflow exception: numeric overflow: '3387269540'>. The SQL submitted is <call <SP1>>.

SP1 calls SP2 and SP2 does all the job finishes gracefully, and the call to SP2 is the last statement. SP1 finishes with this error.

We had ::ROWCOUNT. We commented out the code suspecting that was causing the issue.

Not sure, whats going on here.