SAP Knowledge Base Article - Public

2582193 - Trend Import - Error: Wrapped Exception: Cannot cast class java.lang.String to class java.lang.Number - SuccessFactors Employee Profile

Symptom

Error nessage when importing via Admin Center > "Import Extended User Information":

  • "Internal system error. Please contact your representative. Not able to call the SCA to import the data. com.successfactors.sca.service.ServiceLegacyRollbackException: Wrapped Exception: Cannot cast class java.lang.String to class java.lang.Number" when importing the Trend File.

"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 Employee Profile

Reproducing the Issue

  1. Admin Center > "Import Extended User Information";
  2. Select Type of Information: "Trend Information";
  3. Options below available to be selected:
    • Stop import if invalid users found
    • Import by incrementally adding data
    • Import by overwriting existing data

Cause

CSV file structure configuration. The import file must have the same structure of Trend Information Template.

Resolution

  1. Export the template of Trend Information in Export Extended User Information > Export Template;
    template.png
  2. Fill the data or copy from exported Trend Information;

  3. Import the Trend Information File in Import Extended User Information.
    Before importing the file, check the fields "Source" and "Module". Since those are system generated fields, they should be blank on the import.

See Also

Please refer to KBA 2091409 for further details on  Extended User Information: Import & Export Process for Personal Info, Background, and Trend Data - Employee Profile

Keywords

SuccessFactors; Import Extended User Data; Trend Information; CSV Format;  , KBA , LOD-SF-EP-JOB , Scheduled jobs , LOD-SF-EP , People Profile (Employee Profile / PP3) , Problem

Product

SAP SuccessFactors HCM suite all versions