Hi, I want to ask, when I load the data error

SQLSTATE_NUMERIC_VALUE_OUT_OF_RANGE

appears I want to know which field took the data because in the log there is no explanation about the field. Thanks

Hello @Giri Purnama, the exact field is not in the log, because this happen during loading of data to physical data model, which has a slightly different structure than Logical Data Model. And this error happens when transferring data on the database level. What can be useful to you is that the field is in

dataset.logicnesia_dwh_fact_order

and has datatype of integer in GoodData. Reading from the mapping section in the log you’ve provided it can be one of these fields:

total_do_goods_qty
reassign_count
total_to_goods_value
total_do_goods_value
total_delivery_goods_qty
total_to_goods_qty
rates_calculation_type

I was able to check some database level logs and it seems that the exact field throwing the error should be

total_do_goods_value

.

Ok Thanks