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".
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 Onboarding
Reproducing the Issue
- Navigate to Report Center
- Edit story report
- Edit data source > click on Process
- 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."
- 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
Follow below steps to edit the existing affected reports by removing the Process Task block and then readding it to the report.
(*There are no additional fixes planned.)
Step 1: Open the report in Edit mode and then select the associated data source involving the joins from process and process tasks.
Step 2: Check the join between Process and Process Task. You will see that it refers to the mdfSystemId from the Process side.
Step 3: Click on the Process Task block and make a note of the column and filter selections if any, as this will be needed later to be enabled when we add the block back.
Step 4: Once step 3 is done, remove the table for Process Task temporarily.
Step 5: From the available data panel on the right side, under Onboarding category, find Process Task and drag and drop it into the report. Once added back, you can check the join is correct now with the rowId for the Process object. If this is correctly updated, then metadata has been updated correctly.
Step 6: Update the columns and filters as noted earlier in step 3. Make sure to do this otherwise the corresponding fields don’t show in the report.
Step 7: Click on Preview Query to check if the data is getting populated correctly.
Step 8: Once all looks good, click Finish and save as is, which will then update the story. This is the final step, and the story should have been updated as original.
Additional Points:
If there are more nodes after Process Task block, they will be removed post deletion as well. So, make sure to note what they are and the respective columns and filters if any associated with them. When Process Task block is readded, you can then add the connecting blocks again.
On readding Process task block and then adding the subsequent block as before.
Keywords
SAP, SuccessFactors, Onboarding, b2411, Story Report, Validation Error, Join Not Found , KBA , LOD-SF-OBX-REP , Suite Reporting SAC , Bug Filed