Symptom
During an ETL run, the following error is thrown during the Load step:
“Error requiring user action: Invalid input: Mandatory field 'c_time' has null value in result row of collector '3. Status Changes' in business object 'Manufacturing Order'”
Cause
In the Business Object Event Collectors, there are three mandatory values, one being 'c_time'. Mandatory, meaning that they also cannot be of the value NULL.
Therefore, the error message you are facing describes how in one of the rows of data, created by the Even Collector 'Status Changes', c_time has a value of NULL.
Resolution
All you need to do is add the following WHERE clause to the end of the Event Collectors SQL statement and run the T&L again. The Load should then succeed without issue:
- WHERE <expression that calculates c_time> IS NOT NULL
If the SQL query already has one or more WHERE clauses, the need only add the following:
- AND <expression that calculates c_time> IS NOT NULL
For example, if the following query defines the c_time variable (FROM_UNIXTIME(lips.erdat / 1000 + lips.erzet / 1000) AS c_time), you need to insert the following at the end of your script:
- WHERE (FROM_UNIXTIME(lips.erdat / 1000 + lips.erzet / 1000)) IS NOT NULL
If the SQL query already has one or more WHERE clauses, the need only add the following:
- AND (FROM_UNIXTIME(lips.erdat / 1000 + lips.erzet / 1000)) IS NOT NULL
Keywords
process, intelligence, soe, etl, load, step, event, collector, null, error, c_time, attribute, result, business, object , KBA , BPI-SIG-PI-DM , Data model / ETL for SAP Signavio Process Intelligence , Known Error