3607692 - 'Mandatory field 'c_time' has null value' error during load step of ETL

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'”

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.

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:  

If the SQL query already has one or more WHERE clauses, the need only add the following:

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