SAP Knowledge Base Article - Public

2695045 - Error While Importing Skills Hierarchy Using Data Workbench

Symptom

Your requirement is to upload Skills using the Data Workbench object Skills Hierarchy. Upon trying to import the Skills, system throws error:

The Data Services Request could not be understood due to malformed syntax|Property 'Status' at offset 'X' is invalid

*X represents the offset value

Environment

SAP Hybris Cloud for Customer

Reproducing the Issue

  1. Login to the HTML5 client
  2. Go to Data Workbench workcenter
  3. Go to Import view
  4. Select the radio button for Individual Object
  5. Go to Insert tab
  6. Go to Standard Object tab
  7. Search for the Data Workbench object Skill Hierarchy
  8. Select Download Metadata
  9. Fill data in the fields
  10. Save the file
  11. Select Next and Browse for the file
  12. Select Upload
  13. Choose Next
  14. Select Import
  15. In the Monitor tab, check for the respective Task ID

The records in the file have the Processing Error

Cause

The import is failing as the data in the Status field is incorrectly filled in the upload file.

Resolution

You may refer to the below Codes that are supported for import of Skills using Data Workbench.

1.  Codes for Status field:

  • 01 – In Preparation
  • 02 – Active
  • 03 – Blocked

2.  Codes for Skill_Type field:

  • 01 – Skill
  • 02 – Skill Group 

Correct the data in the upload file and proceed with the data import.

Keywords

Skill Hierarchy, Skill, Skill Type , KBA , skill hierarchy , skill , skill type , LOD-CRM-INT-DWB , Data Workbench , Problem

Product

SAP Cloud for Customer all versions