SAP Knowledge Base Article - Public

3476197 - "Failed to create the query..." error when previewing queries for existing stories in SAP SuccessFactors People Analytics

Symptom

When we edit Story report > Edit Data Source and click on Preview Query, we are getting below error "Failed to create the query. For assistance, please contact your administrator or the SAP Product Support team, if needed" in SACEE.

Error:

{
    "error": {
        "status": 500,
        "errorCode": "0",
        "message": "Internal Server Error",
        "target": null,
        "details": [
            {
                "message": "NullPointerException: error occurred"
            }
        ]
    }
}

Environment

SAP SuccessFactors People Analytics

Reproducing the Issue

  1. Logon to SuccessFactors
  2. Go to Reporting.
  3. Open a Story.
  4. Edit story.
  5. Edit Data Source.
  6. Click preview query.
  7. Notice the error: "Failed to create the query. For assistance, please contact your administrator or the SAP Product Support team, if needed".

Cause

This issue is currently under investigation by the development team.

Resolution

This issue is currently under investigation by the development team.

Keywords

preview query, edit data source, sacee, embedded sac, SFSF, "Failed to create the query. For assistance, please contact your administrator or the SAP Product Support team, if needed". , KBA , LOD-SF-ANA-SAC , Stories in People Analytics , LOD-ANA-OEM , Embedded usage of SAP Analytics Cloud , Problem

Product

SAP SuccessFactors HCM Core 2405