SAP Knowledge Base Article - Public

3491300 - All rows of import jobs are getting rejected via error "Invalid measure values" in SAP Analytics Cloud (SAC)

Symptom

Using File Server import data connection in SAP Analytics Cloud (SAC), import jobs started to reject all the rows via message: "Invalid measure values".

Recreating the jobs based on the same mapping will solve the issue. However, the initial jobs still seem to be corrupted, even though, there doesn't seem to be any format change on the data source side.

Environment

  • SAP Analytics Cloud (Enterprise) 2024.8.16

Reproducing the Issue

  1. Run the existing import job in SAC (either manually or scheduled).
  2. Notice that all rows are rejected via "Invalid measure values".
  3. Recreate the same job in the model and see that it works fine.

Cause

In case of the import job of the rejected rows, the format is set to a period "." for columns of decimal data type.
In case of the newly created import job that works as desired, the format is set to a comma "," for columns of decimal data type.

The format of decimal data type was changed from "." to "," on the data source side, causing all the rows to be rejected of the initial import job.

Resolution

To fix the issue of rejected rows, the format for columns of decimal data type should be set to "." instead on the data source side.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

Invalid measure values, reject, rejected rows, all rows are failing, failed import, import error , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud all versions