SAP Knowledge Base Article - Public

3798686 - Clean & Replace Subset of Data method causes import job to fail with error "Import to model ended unexpectedly. Error code: 1019"

Symptom

  • An import job inside a Model in SAP Analytics Cloud (SAC) fails with the following error when using 'Clean & Replace Subset of Data' method:
    "Import to model ended unexpectedly. Error code: 1019"

  • This occurs when a Public Dimension is selected as the scope for the above method.
  • When the method scope includes only Private Dimensions belonging to the model, the import completes successfully.

Environment

  • SAP Analytics Cloud Enterprise

Reproducing the Issue

  1. Create or use a Model that contains a Public Dimension.
  2. Create an Import Job.
  3. Select 'Clean & Replace Subset of Data' as the import method.
  4. Select a Public Dimension as the scope for the method (+ Add Scope button).
  5. Run the Import Job and observe it fails with the error mentioned in the Symptom section.
  6. Repeat the above steps using a Private Dimension as the scope and observe it completes successfully.

Cause

  • This behavior is expected and by design.
  • Import jobs inside a model can only modify data in Private Dimensions that belong to that model.
  • Because Public Dimensions are shared across multiple models, import jobs associated with a specific model are not permitted to modify data within Public Dimensions.

Resolution

  • To update or modify data in a Public Dimension, create a separate import job in the Public Dimension itself (Modeler -> Public Dimensions tab).
  • Public Dimensions cannot be modified from within a specific model.

See Also

Keywords

KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0