Symptom
A Story widget component is resulting to the error message "We found an error while processing the request".
The browser Get Response log under Developer Tools > Network indicates the following :
"DetailedError": "Column not found : RD[column code]"
Environment
SAP SuccessFactors People Analytics
Reproducing the Issue
1. Login and go to Report Center
2. Look for affected Story report
3. Run it and observe the error "We found an error while processing the request" is displayed on the affected page that has the widget with the issue
Cause
The widget (chart, table, or even Grid page layout) is looking for a column that no longer exists.
1. Click on Edit mode > Designer > Builder panel to find out which field.
2. Under the list of columns, the affected column will be highlighted in Red and upon hovering on the ! icon it will show "[Column] not found".
Resolution
After checking from the Designer > Builder panel which field is affected:
1. Remove the currently selected missing field by clicking on the x icon
2. Click on Add Measures/Dimensions
3. Look for the new field or the field with the same name - notice that it is unselected
4. Tick the field or column checkbox to add it back again.
5. Wait for the widget or page to load
Result: If there are no more missing columns the widget or page should load the data successfully
Keywords
DetailedError, Column not found , Story Builder, missing column, Story errors, page errors, Grid, widget, widget errors , KBA , LOD-SF-ANA-SAC-SDS , Story Designer - Story & Formatting , Problem