Comment on page
EXPECT_ERROR: Decimal conversion failed
Found in agent_errors table
There are generally two causes of this error:
- A non-numeric character was logged to a field with the "decimal" type
- An extremely small (<1e-24) or large number (>1e64) was logged
Simply update the code that produced the non-numeric character to only output numbers or an empty field. Move any error messages to a new field.
Numbers under
1e-24 cannot be handled by the system. These number should instead be scaled and the units changed. Generally speaking, try not to log values less that 0.000001. If you have existing data that contains these very small values, here is a small script to replace the tiny values with 0 and append the data back to latest.csv.Plain Text
Specific field number
grep -h '[0-9]e-[2-9][0-9]' 2021-05*.csv |
sed -r 's/,-?[0-9]\.[0-9]*e-[34][0-9],/,0,/g' >> latest.csv
awk -F, '$16 > -1e-24 && $16 < 1e-24 && $16 != 0 {print}' 2020-1*.csv |
sed -r 's/,-?[0-9]\.[0-9]*e-[34][0-9],/,0,/g' >> latest.csv