SAP Knowledge Base Article - Public

3454612 - Error happened when importing Growth Portfolio data - Talent Intelligence Hub

Symptom

Cannot import attributes via integration center due to the following error:

HttpOperationFailedException: Failed due to - HTTP operation failed invoking http://apiXX-internal.dcXX.sf.priv/rest/ecosystem/wholeself/v1/portfolios with statusCode: 400

Environment

SAP SuccessFactors Talent Intelligence Hub

Reproducing the Issue

1. Go to integration center

2. Create an attribute import job by following the guide:

Importing Entities | SAP Help Portal

3. Upload import file on SFTP and try to import the file

4. The import job was failed due to the following error:

HttpOperationFailedException: Failed due to - HTTP operation failed invoking  http://apiXX-internal.dcXX.sf.priv/rest/ecosystem/wholeself/v1/portfolios with statusCode: 400

Cause

The error occurred because the wrong proficiencyAssignedDate data was imported.

Resolution

1. Wrong proficiencyAssignedDate data format:

We are always exporting the growth portfolio data via the export integration template from the guide Exporting Entities | SAP Help Portal, however, the exported proficiencyAssignedDate data is not the correct import data format.

In the export file, we can see the proficiencyAssignedDate data can be "53:10.0" or "1/17/2023  9:53:10 AM", which is not allowed to import.

Allowed date formats are [yyyy-mm-dd or yyyy-mm-ddThh:MM:ss:SSSZ].

Please correct the proficiencyAssignedDate data to the allowed data formats.

2. Trying to change historical record of Growth portfolio:

New validation rules are now applied to Growth Portfolio IC import, described in the guide Important Notes and Best Practices | SAP Help Portal:

  • If you’re importing an attribute for the first time, you can set the proficiencyAssignedDate to any date in the past. Ensure that the proficiencyAssignedDate follows the correct date format. The allowed date formats are yyyy-mm-dd and yyyy-mm-ddThh:MM:ss:SSSZ.  
  • If you're importing an attribute for which the proficiency level is already recorded in the system, then the new proficiencyAssignedDate must be set to a date later than the last proficiencyAssignedDate. Ensure that the proficiencyAssignedDate follows the correct date format. The allowed date formats are yyyy-mm-dd and yyyy-mm-ddThh:MM:ss:SSSZ.

See Also

SAP Help Guide

Keywords

Talent Intelligence Hub, TIH, Growth portfolio, import, export, entities, Integration Center, proficiencyAssignedDate, 400 error,  historical record, existing data change, can't update historical record. , KBA , LOD-SF-TIH-LIB , Attribute Library , How To

Product

SAP SuccessFactors HCM Core all versions