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
- Login to the HTML5 client
- Go to Data Workbench workcenter
- Go to Import view
- Select the radio button for Individual Object
- Go to Insert tab
- Go to Standard Object tab
- Search for the Data Workbench object Skill Hierarchy
- Select Download Metadata
- Fill data in the fields
- Save the file
- Select Next and Browse for the file
- Select Upload
- Choose Next
- Select Import
- 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