SAP Knowledge Base Article - Public

3332277 - During ETL, Transformation & Load failed with 'Error creating Business Object' error

Symptom

During ETL, Transformation & Load failed with below error:

Error creating BusinessObject: There was a problem executing your SQL statement: line 78:58: Column 'pr created date' cannot be resolved

Environment

SAP Signavio Process Intelligence 3.0

Reproducing the Issue

  1. Open PI
  2. Navigate to Manage Data
  3. Select the Process data pipeline tab.
  4. Select a pipeline on the new page
  5. Press Run ETL button
  6. See you are faced with above error.

Cause

After checking the transformation template (Purchase Requisition), in the first place it says PR Created Date, but in the subquery, the column name is Last PR Created Date.

Resolution

Development have created a bug ticket for this issue and are fixing the PTP template asap. If you are affected by this Bug, please let us know by raising a case via the SAP for Me platform and reference this knowledge article.

See Also

For more information on the Procure-to-Pay template, please read the following excerpt from our user guide: https://documentation.signavio.com/suite/en-us/Content/process-intelligence/procure-to-pay-sap-s4hana.htm

Keywords

process, intelligence, ptp, procure, pay, template, error, creating, businessobject, etl, full, transform, load , KBA , BPI-SIG-PI-TRA , Transformation (Business Objects / Pipelines) , Known Error

Product

SAP Signavio Process Intelligence 3.0