SAP Knowledge Base Article - Public

2755127 - ERROR: ORA-01438: value larger than specified precision allowed for this column - Data Services

Symptom

  • ERROR: "ORA-01438: value larger than specified precision allowed for this column"
  • Job fails when processing specific rows in the source
  • Source and target columns are decimal datatype

Environment

  • SAP Data Services 4.x
  • Oracle target

Cause

Length of data sent to target is longer than the precision defined for the output column.

Resolution

Increase the precision on the target output column to accomodate the full length of the input data.

Keywords

BOSDS, DS, ORA-01438, value larger than specified precision allowed for this column, job, Data Services, oracle , KBA , EIM-DS-EXE , Job Execution , EIM-DS , Data Services , Problem

Product

SAP Crystal Reports 2011