cancel
Showing results for 
Search instead for 
Did you mean: 

Database returned the SQL code 314. Error text: numeric overflow - Manage Customer Line Item Fiori

0 Kudos

We are encountering an error whenever searching items specifically to one customer using the Manage Customer Line item Fiori application. The error displays as below:

Database returned the SQL code 314. Error text: numeric overflow: search table error: [6944] AttributeEngine: overflow in numeric calculation;string comma(string rtrim(string midstru(string rtrim(string fox_replace(string rtrim(string sqladd(string rtrim(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$0$"), string rtrim(string sqladd(string ' &@', string rtrim(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$1$"))))), string '&@', string '')), int '1', int '80')), string jf(int eq(int in(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$34$", string 'V', string 'W'), int '1'), string '3', string jf(int or(int or(int and(int and(int gt(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$10$", string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$6$"), int ne(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$6$", string '')), int ne(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$6$", string '00000000')), int eq(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$10$", string '00000000')), int eq(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$10$", string '')), string '2', string '1')), string jf(int gt(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$6$", string '00000000'), string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$6$", string '20181207'), fixed8_5 jf(int eq(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$7$", string 'X'), fixed8_5 '0', fixed8_5 jf(int and(int gt(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$37$", string '19000101'), int lt(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$37$", string '29001231')), fixed8_5 jf(int and(int gt(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$10$", string '19000101'), int lt(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$10$", string "__common2")), fixed8_5 [here]checkdigits(fixed8_5 fixed_8(int dats_days_between(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$37$", string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$10$")), int '5'), fixed8_5 checkdigits(fixed8_5 fixed_8(int dats_days_between(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$37$", string "__common2")), int '5')), fixed8_5 '0')), string box(string "SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$11$", string '0000', string jf(int lt(fixed8_5 "__common1", fixed8_5 '0'), string '1', string jf(int eq(fixed8_5 "__common1", fixed8_5 '0'), string '2', string '3')), string '')),(SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$0$ = "Urbano's Drugstore"[string], SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$1$ = ''[string], SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$10$ = '20180915'[string], SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$11$ = '2018'[string], SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$34$ = ''[string], SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$37$ = '23010929'[string], SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$6$ = '00000000'[string], SAPABAP1.#_SYS_QO_COL_7fac03e64990:401800000074c1ef.COL$7$ = ''[string]); checkNull false An exception was raised Close

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Hello Sergio,

Thanks for your comment. This is from a standard Transactional Fiori app (Manage Customer Line Item), its function is to output all open items for a specific customer. A bit weird thing is that the error only occur on one specific customer. Thus we'd be checking on the data type if it's correct.

SergioG_TX
Active Contributor
0 Kudos

there seems to be a calculated field that is generating all this... can you please confirm if that calc field has the right data type and also the logic may seem like to much... you may be able to do a regex replace instead of nested operations ??? what is the entire logic.. it may be able to be simplified