SAP Knowledge Base Article - Public

3568118 - "Unable to find the selected table or column in the database" error due to 127 character limit for Custom MDF Object

Symptom

Create a Simple story report on Custom MDF object and click on preview query, the following error appears:

We are unable to find the selected table or column in the database.
For assistance, please contact your administrator or the SAP Product Support team, if needed.

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

Environment

  • SAP SuccessFactors HCM Suite
    • Story Report

Reproducing the Issue

  1. Create a custom MDF object with more number of characters like below
  2. "cust_AddinganAssociationfromCustomFoundationObjecttoMDFFoundationObjectParentChildObjectTesting " (SAP_SAC.FoundationObjects cust_AddinganAssociationfromCustomFoundationObjecttoMDFFoundationObjectParentChildObjectTesting)
  3. Create a Story report on this Custom MDF object
  4. Select the fields from this object and click on preview query
  5. The following error appears

Cause

The character limitation is 127. This issue is observed when the custom MDF object name exceed the 127 character limitation for the association of the two custom objects in their system.

For example, in the case of two objects having a parent and child relationship, the child table name in the backend will include both object names. This makes the object name longer, resulting in error.

Resolution

This is a known limitation and a fix is underway. There is no way to correct this on its own or through any workaround. The only way is to remove the longer objects and recreate them with shorter name formats, as it is not possible to change the name of a custom MDF object (It will result in an error message).
 

Keywords

127, We are unable to find the selected table or column in the database, Character, Limit, Parent, Child, Custom, MDF object, Story, Report, AYT-57685, FPA97-8734 , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , LOD-SF-ANA-SAC , Stories in People Analytics , Problem

Product

SAP SuccessFactors HCM Suite all versions