3193632 - Job Information table throwing error 'The query has validation issues' in new and existing Story reports.

Symptom

Job Information table keeps throwing the error 'The query has validation issues' in new and existing Story reports.

Network Logs:
error: {status: 400, errorCode: "5040",…}}
error: {status: 400, errorCode: "5040",…}
details: [{message: "BadRequestException: error occurred"}]
errorCode: "5040"
message: "{\"errorMessage\":{\"exceptionErrors\":\"Query is not activated and will be deleted, Query Name:_________"

"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 Core
Report Center > Story Report

Reproducing the Issue

1. Navigate to Reporting
2. Create a new Story report with Job Information table
3. Preview the query formed under Job Information, error appears

Cause

When we add Pick list to the Time Profile, The relationship will be created between the Time Profile and Pick list based on the column added, but some column/picklist data types are not compatible and Base Calculation view creation fails.

Resolution

Change the configurations for Job Information in "Manage Business Configuration":

Employee Central --> HRIS Elements --> jobInfo

Navigate to the Filed Label "Time Profile" [click on Details]-> change to,
1. "Type of Reference Object" : "No Selection"
2. "Picklist" : "No Selection"
3. "Parent Field for Picklist" : "No Selection"

After this, the Reporting Metadata will need to refreshed, this can be carried out by Support if Provisioning access is unavailable.

Keywords

Job Information, People Analytics, Error, Validation, Story, Metadata. , KBA , LOD-SF-ANA-SAC-DAM , Data Modelling - Module & Entity Data Issues , Problem

Product

SAP SuccessFactors HCM Core all versions