Symptom
- Story displays an error "Internal Error Occurred", upon building a calculated column where Division is being performed and divisor value is Zero.
- Detailed error, in Browser > Network log, displays "DetailedError": "Caught exception : exception 42111: SQL Error : div by zero occurred error returned from /\n"
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
- SuccessFactors HCM Suite
- Analytics & Reporting (Ad Hoc, YouCalc, ORD, Story)
- People Analytics (Analytics Cloud for SF)
- Query Designer - Filter, Calculated Column, Params
- People Analytics (Analytics Cloud for SF)
- Analytics & Reporting (Ad Hoc, YouCalc, ORD, Story)
Reproducing the Issue
- Login to SF Instance and navigate to Report Center
- Create a simple story query with below calculated column condition ([value1]/[value2])
- When previewing the query, an error message "Internal error occurred while processing", is displayed
- Notice the error in the Browser's network log (This KBA will help you with fetching this information 2280022):
"Type": 2,
"Number": 42014,
"Text": "Internal error occurred while processing.",
"DetailedError": "Caught exception : exception 42111: SQL Error : div by zero occurred error returned from /\n"
Cause
The value of divisor [value2] would be '0' (zero).
Resolution
We need to avoid the columns/fields which could have a value of 0 in divisor. Or else it will lead to 'Divide by Zero' error.
Alternatively, if there exists some values with 0 in the field/column used in the divisor, then you may use the formula within an IF function.
Eg: IF([value2]>0, (([value1]/[value2])) , 0)
See Also
Keywords
Divide, calculated column, correlation, zero, condition, Divide by zero, Division by zero, Error, Story, People Analytics , KBA , LOD-SF-ANA-SAC-SDS , Story Designer - Story & Formatting , Problem