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


    AI 9.x & later, Spoon 4.x & later


    Customer was loading data into various foundation tables (i.e. Organization, People) using custom transformation. 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 the 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