SAP Knowledge Base Article - Public

3300213 - We found an error while processing the request - Column not found - People Analytics Story

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

Product

SAP SuccessFactors HXM Suite Core 2205