SAP Knowledge Base Article - Preview

3631314 - Error: "failed to execute transform" when using null in IF formula in import job - SAP Analytics Cloud

Symptom

  • SAC import connection, when "Prepare Data", if set formula using "null", for example below formulas, get "failed to execute transform":
  • [Column] = IF( 1==1, 1, null )
  • [Column] = IF( 1==1, "1", null)
  • The issue happens since 10.07.2025.
  • After this issue happens, existing job which used this formula cannot run or be edited anymore.
  • Error message: "failed to execute transform"


Read more...

Environment

  • SAP Analytics Cloud (SAC) 1.0

Product

SAP Analytics Cloud all versions

Keywords

failed to execute transform, SAC, import connection, prepare data, null formula, data acquisition, BW, error message, existing job, new job, workaround, SAP Analytics Cloud , KBA , LOD-ANA-AQU-BW , Data Acquisition from BW , LOD-ANA-ML-DE , SAC Data Wrangling , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.