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

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".

SAP SuccessFactors Onboarding

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"

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.

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.

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