SAP Knowledge Base Article - Public

3546445 - [Known Error] Story Report Validation Error: Join Not Found - Onboarding

Symptom

See error for Story Report with Data Source "Process":

  • "We found some issues in the query validation. For details, use the validation information in the toolbar."
  • The query validation error in toolbar is "Join not found".

Environment

SAP SuccessFactors Onboarding

Reproducing the Issue

  1. Navigate to Report Center
  2. Edit story report
  3. Edit data source > click on Process
  4. Click on preview query > can see below error: "We found some issues in the query validation. For details, use the validation information in the toolbar."
  5. The query validation error in toolbar is "Join not found"

Cause

For the story reports created using process and process task, the relationship was created using mdfSystemId.

Onboarding team has introduced the rowId in the MDF object - ONB2Process as part of b2411 release. The MDF framework treats mdfSystemId and rowId as same field.

MDF framework assigns the mdfSystemID when there is no rowId in the MDF object. However, if the rowId is present, then MDF framework adds the rowId instead of the mdfSystemId.

The existing stories are failing as they are created using mdfSystemId.

Resolution

Engineering is currently working on the fix. Latest information will be updated into this KBA.

[Workaround]

When the issue occurs, create a new report similar to the existing one and use the field of rowId instead of mdfSystemID in query join when joining the process with process task.

Keywords

SAP, SuccessFactors, Onboarding, b2411, Story Report, Validation Error, Join Not Found , KBA , LOD-SF-OBX-REP , Suite Reporting SAC , Bug Filed

Product

SAP SuccessFactors Onboarding 2411