on 02-11-2015 5:57 PM
Hi Guys,
I have a numeric column in a table that i used in analytical view, which is decimal (14,14 ) . When I use it in Analytical view, It gives me "Arithmetic overflow in numeric calculation; $function$=mergeLoop; $message$=aggregation failed N_ABRMENGE$sum$ 1 fixed0.14(14)" error. After that I created a calculated attribute and i used DECIMAL, FLOAT, DECFLOAT conversion functions to solve the error. But nothing changed.
Do you have any idea how to get rid of it ?
Sincerely,
Yakup
Hi yakup,
It is because when aggregation is taking place on this column the value is exceeding more than column size. Try increasing 14,14 to Higher values. Like ex 16,14 or 20,14. Hope this helps
Regards,
Safiyu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Safiyudeen,
I created variable like this and give me this error. If I click "calculate before aggregation". It works correctly.
"
Error: [314]: numeric overflow: search table error: [6944] Error executing physical plan: exception 6944:
AttributeEngine/Parallel/Aggregators/SumAggregator.hpp:149
AttributeEngine: overflow in numeric calculation; $function$=mergeLoop; $message$=aggregation failed N_ABRMENGE$sum$ 1 fixed0.14(14)
,in executor::Executor in cube: _SYS_BIC:YARSLAN/ISU_GENERAL_BILLING/olap"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Guys,
I increased the length of calculated attribute, it worked when I select "calculate before aggreagation.". But the query execution time increased , I couln't find any further solution without selecting "calculate before aggreagation".
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Yakup,
As Safiy mentioned, when you reach the maximum limit of the datatype on column N_ABRMENGE then you will see this error .
Altering the column data type to higher limit would solve that issue, if not try this conversion function TO_DOUBLE ( N_ABRMENGE ) in your calculated attribute before Aggregation.
Thanks
Siva
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.