3710813 - Exception 42111: SQL Error : search table error: [6859] AttributeEngine: divide by zero - Story Report

• Running/exporting the story report results in Internal Error
• The following error message can be seen from network logs:
  Caught exception : exception 42111: SQL Error : search table error:  [6859] AttributeEngine: divide by zero;exception 70006859

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• SAP SuccessFactors HCM Suite
  • Story Report

There is a calculated column that includes a division, like the one below. The divisor has at least one value where it is 0. As it is not possible to divide by 0, the calculation will result in an error.

For example, the Employment#JobInformation#StandardWeeklyHours has at least one value where it is 0, resulting in error.

To resolve the issue exclude any field from the calculation for which the divisor equals 0.

divide by zero, exception 70006859, exception 42111, Internal Error , KBA , LOD-SF-ANA-SAC , Stories in People Analytics , Problem