SAP Knowledge Base Article - Public

3806516 - Draft creation fails with cell character limit and default values loaded when selecting NAME (Default) in SuccessFactors dimension import job - SAP Analytics Cloud

Symptom

  • In a dimension import job from SuccessFactors, a default value intended only for missing Korean descriptions is applied to all records, even when valid NAME (ko_KR) values exist.
  • Draft creation fails with the error: "Query results exceeded the cell character limit of 4998 in column NAME_DEFAULTVALUE."
  • Draft creation may also display: "Cell value exceeds 5,000 characters."
  • An existing import job with the same entity and field mapping continues to run successfully; the issue occurs only when creating a new import job.

Environment

  • SAP Analytics Cloud
  • Import Data Connections (Acquiring Data)

Reproducing the Issue

  1. Create a new Dimension Import Job using the SuccessFactors source.
  2. Select the FODepartment entity.
  3. Select fields: A, B, C.
  4. Apply filter: Status = X,Y.
  5. Proceed to create and save the draft.
  6. Observe the draft creation error indicating a cell character limit exceedance.

Cause

This issue is currently under investigation of development team.

Resolution

This issue is currently under investigation of development team.

See Also

Keywords

SAC, SuccessFactors, OData, dimension import job, FODepartment, NAME (Default), name_defaultValue, NAME_DEFAULTVALUE, cell character limit, 4998, 5000 characters, draft creation failure, locale fallback, Korean description, ko_KR , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud all versions