pentaho/pentaho-kettle · error · KettleStepException

NormaliserMeta.Exception.UnableToFindField

NormaliserMeta.Exception.UnableToFindField

Error message

NormaliserMeta.Exception.UnableToFindField

What it means

NormaliserMeta.getFields() builds the output row by cloning each input field listed in the Normaliser step config and renaming it to the configured 'normalised' name. Before cloning it looks the field up in the incoming row via row.searchValueMeta(fieldname). If a configured field name does not exist in the incoming row stream, a KettleStepException is thrown with this localized message.

Solutions

  1. Fix the Normaliser step configuration so 'Fieldname' matches an actual incoming field exactly (case-sensitive).
  2. Verify the upstream step still produces the field; add or repair the hop/step that emits it.
  3. Open the transformation and re-run 'Get Fields' on the Normaliser step to refresh the field list.
  4. If the field is optional, add a Select values step upstream that guarantees the field exists.

Example fix

// before (config XML references a stale field)
<field><name>old_amount</name><norm>amount</norm></field>
// after (matches upstream field)
<field><name>amount</name><norm>amount</norm></field>
Defensive patterns

Strategy: validation

Validate before calling

// Java, before configuring/running the step
RowMetaInterface inputRowMeta = ...;
for (NormaliserField f : normaliserMeta.getNormaliserFields()) {
  if (inputRowMeta.searchValueMeta(f.getFieldName()) == null) {
    throw new IllegalStateException("Field not in incoming row: " + f.getFieldName());
  }
}

Type guard

boolean fieldExists(RowMetaInterface row, String name) { return row != null && row.searchValueMeta(name) != null; }

Try / catch

try { stepMeta.getFields(rows, name, info, null, null, space); } catch (KettleStepException e) { log.error("Normaliser field missing: " + e.getMessage(), e); }

Prevention

When it happens

Trigger: Calling getFields (directly or via transformation row-layout resolution) when normaliserFields[i].getFieldValue() names a field absent from row (RowMetaInterface.searchValueMeta returns null).

Common situations: Upstream step renamed or removed the field; the Normaliser config references a field from a deleted hop; field name case/spelling mismatch; transformation edited after the Normaliser was configured; repository/XML metadata loaded from an older transformation version.

Understand the failure class

Background: 'Could not be found', 'does not exist', 'not found in database': the resource-not-found family when an ID, slug, key, or URI lookup comes back empty — this error's family across 20 libraries.

Related errors

AI-assisted analysis of pentaho/pentaho-kettle@f3058517a1 (2026-09-13). Data as JSON: /api/errors/b0573f68e670ff83. Report an issue: GitHub.

Appendix: source

Thrown at engine/src/main/java/org/pentaho/di/trans/steps/normaliser/NormaliserMeta.java:230

    // Then add the type field!
    //
    ValueMetaInterface typefield_value = new ValueMetaString( typeField );
    typefield_value.setOrigin( name );
    typefield_value.setLength( maxlen );
    row.addValueMeta( typefield_value );

    // Loop over the distinct list of fieldNorm[i]
    // Add the new fields that need to be created.
    // Use the same data type as the original fieldname...
    //
    for ( int i = 0; i < norm_occ.size(); i++ ) {
      String normname = norm_occ.get( i );
      String fieldname = field_occ.get( i );
      ValueMetaInterface v = row.searchValueMeta( fieldname );
      if ( v != null ) {
        v = v.clone();
      } else {
        throw new KettleStepException( BaseMessages.getString( PKG, "NormaliserMeta.Exception.UnableToFindField", fieldname ) );
      }
      v.setName( normname );
      v.setOrigin( name );
      row.addValueMeta( v );
    }

    // Now remove all the normalized fields...
    //
    for ( int i = 0; i < normaliserFields.length; i++ ) {
      int idx = row.indexOfValue( normaliserFields[i].getName() );
      if ( idx >= 0 ) {
        row.removeValueMeta( idx );
      }
    }
  }

  @Override
  public String getXML() {

View on GitHub (pinned to f3058517a1)