VERIFIED SOLUTION i
X

'Decimal result is too large, increase field precision' error message during plan execution in Sagent

Issue

While running Sagent plan that uses 'ToDecimal' function on string input in the expression calculator transform, 'Decimal result is too large, increase field precision' error message is encountered. The plan works fine if the input is 'Double' type.

User-added image

Cause

It could be caused when 'ToDecimal' function is called on a String column in expression calculator and if the exponent (size of the string column as input to Expression Calculator) is greater than precision set in the expression.

Resolution

UPDATED: October 1, 2018


Increase the precision of 'ToDecimal' function for the affected column more than the exponent.

Environment Details

Product Feature: Expression Calculator

Downloads

  • No Downloads