BMC Atrium Integrator Spoon - NULL value is not getting replaced according to "If field value is NULL" step in Custom spoon job

Version 1
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    BMC Atrium CMDB Suite


    Atrium Integrator 9.x & later, Pentaho Spoon 4.x & later


    Custom transformation was built to load data into various foundation tables (i.e. Organization, People).

    The source of the data is via a table input & for null values in any column "If field value is NULL" step was used but still sometimes it was throwing below errors :

    ERROR (307): Required field can not be blank.; 


    It seems defect on Spoon side.


    - This issue was already discussed by many users on Pentaho communities : 
    - Most of issues got resolved by adding below keyword in file :

    Article Number:


    Article Type:

    Solutions to a Product Problem

      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles