3627572 - Load step of ETL fails with 'Unprocessable Entity': Signal query sent to datastore is invalid

When executing full ETL or only T&L in a SAP Signavio Process Intelligence pipeline, the Load step fails with the error message: 

“Error during update of linked process: Failed to upload to pex-backend. Reason: Target responded with 'Unprocessable Entity': Signal query sent to datastore is invalid” 

This can be reproduced by adding 'xyz' AS case_id in the Case Attributes Business Object script and running the T&L.

There is a field in the Case Attributes Business Object script named c_caseid

c_caseid gets converted into case_id while generating the eventlog & hence a custom defined case_id will produce duplicate attribute. 

Example Case attribute script (c_caseid is the only mandatory field):

SELECT
    pkcol AS c_caseid, -- mandatory field
    'xyz' AS case_id -- also gets converted to c_caseid producing a duplicate  attribute
FROM <table>

Do not use AS case_id as a column alias.

ETL, T&L. Load, soe, SAP, Signavio, process, Intelligence, Alias, Column, c_caseid, case_id, case, attributes, script  , KBA , BPI-SIG-PI-DM , Data model / ETL for SAP Signavio Process Intelligence , Problem