SAP Knowledge Base Article - Public

3167067 - ETL failed with FINAL_CASE_ATTR Case type/Error executing TransformationProcessor CASE in SAP Signavio Process Intelligence

Symptom

When running transformation and load, I get an error as below. 

Case type: FINAL_CASE_ATTR
Message: Error executing TransformationProcessor CASE - (The field 'c_caseid' contains null values)

Resolution

Please make sure there are no NULL values for c_caseid, c_eventname and c_time are filtered from your resulted queries.

For Event collectors:

WHERE c_caseid IS NOT NULL AND c_eventname IS NOT NULL AND c_time is NOT NULL

For Case attributes:

WHERE c_caseid IS NOT NULL

Keywords

Process,intelligence,pi,processintelligence,signavio,etl,null,value,values,c_caseid,c_eventname,c_time,query,queries,event,collectors,Case,attributes,attribute,transformation,load,error,executing,TransformationProcessor,field,type,FINAL_CASE_ATTR , KBA , BPI-SIG-PI-TRA , Transformation (Business Objects / Pipelines) , BPI-SIG-PI-DTT , Data Transformation Templates , BPI-SIG-PI-DS , Data Source (CSV, Connector) , BPI-SIG-PI-DI , Data Import for SAP Signavio Process Intelligence , BPI-SIG-PI-DM , Data model / ETL for SAP Signavio Process Intelligence , Known Error

Product

SAP Process Intelligence by Signavio all versions