SAP Knowledge Base Article - Public

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

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

Product

SAP Signavio Process Intelligence 3.0