SAP HANA的procedures报Numeric overflow error

最新推荐文章于 2025-01-23 21:22:22 发布

SAPmatinal

最新推荐文章于 2025-01-23 21:22:22 发布

阅读量3.4k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： HANA进阶学习文章标签： HANA

本文链接：https://blog.youkuaiyun.com/SAPmatinal/article/details/58594969

HANA进阶学习专栏收录该内容

194 篇文章

订阅专栏

SAP HANA的存储过程报错如下：

[314]: numeric overflow: [314] INF126293.PROC_TEST1: line 203 col 1 (at pos 4849): numeric overflow exception: numeric overflow: search table error: [6944] AttributeEngine: overflow in numeric calculation;JECalculate pop12(setResultFromTo(0, 2147483647),addExpression('box ( "schema1.table b.fiels 1" , 1 , ( decfloat ( 1 ) / decfloat ( 7 ) ) , ( decfloat ( ( "schema1._SYS_CE_LLANG_5162F1DF92976332E10000000A9CF502_TMP:IT_0x7f77228e13500x7f76ee07c800:1@vid:2.VAL0000" * "INF126293._SYS_CE_LLANG_5162F1DF92976332E10000000A9CF502_TMP:IT_0x7f77228e13500x7f76ee07c800:1@vid:2.BILL_OFFPEAK" ) ) / decfloat ( "schema1"._SYS_CE_LLANG_5162F1DF92976332E10000000A9CF502_TMP:IT_0x7f77228e13500x7f76ee07c800:1@vid:2.USAGE_OFFPEAK_TOTAL" ) ) )'),addViewAttribute('_CV0x7f77228e2f40'));checkNull false

解决办法，判断字段是否为零

如果为零，则跳过

IF FIELD1 <> 0 THEN

--处理语句

ENDIF.