3692872 - "Step X of data action Y in version Z failed to execute due to a technical error. This error has been logged." in SAP Analytics Cloud for Planning (SAC)

• When executing the data action, the step execution fails due to a "Technical Error."
• Error message: Step X of data action Y in version Z failed to execute due to a technical error. This error has been logged.
• It may happen that a similar data action which uses nearly the same logic completes successfully.
• It may happen the same data action works fine in the non-prod system and experiences the error in the prod system.

SAP Analytics Cloud

1. log in to SAC
2. run a data action from the story or the trace tool.

The issue is caused by an overflow of the INTEGER variable in the Advanced Formulas step. The maximum value for the INTEGER data type, "2,147,483,647," was exceeded during the execution of the data action.

Change the variable type from INTEGER to FLOAT to resolve the overflow issue.

• Optimize Advanced Formulas for Better Performance
• Number Variable Function in Advanced Formulas

technical error, data action failure, advanced formulas, integer overflow, float variable, sap analytics cloud, create actual ratio by usage, sales volume, redundant iterations, optimization, step execution failure, error message, multi action, MA, multiaction, multi-action, data-action , KBA , LOD-ANA-PL-AF , Advanced Formulas , Problem