Symptom
- Import using the Clean & Replace Subset of Data method fails when a public dimension is selected as scope; the same import succeeds when a private dimension is used as scope.
- Error shown: "Import to model ended unexpectedly. Error code: 1019".
- Import settings opened from the Data Management page show a different number of scopes than the import settings opened via the job’s Edit > Import settings (ratchet icon)
- A newly created job with identical mapping and scopes runs successfully when scopes are maintained via the job’s import settings (ratchet icon) rather than from the Data Management page.
Environment
SAP Analytics Cloud
Reproducing the Issue
- Open a model that has an import job configured with Clean & Replace Subset of Data and a public dimension selected in the scope.
- Modify the scopes of an import job from Data Management page.
- Run the import job.
- Observe that the job fails with "Import to model ended unexpectedly. Error code: 1019".
- Compare the scopes shown in Import settings opened from the Data Management page versus Import settings opened via the job’s Edit > Import settings (ratchet icon); note they differ.
Cause
The Data Management wrangling UI drop-down can display incorrect scope values, causing a mismatch between scopes shown in Data Management and scopes configured in the job’s Import settings. This mismatch can lead to failure of Clean & Replace Subset of Data when public dimensions are used as scope.
Resolution
- Recreate the import job.
- Define and maintain the scope dimensions only within the job’s Import settings (ratchet icon). Do not add or modify scopes from the Data Management page.
- Save the job and run the import again to confirm it completes without error 1019.
See Also
Keywords
Clean & Replace Subset of Data, error 1019, Import to model ended unexpectedly, Public Dimension, Private Dimension, scope mismatch, Data Management, wrangling UI, import job, subset scope, job settings, ratchet icon, BW import, model import, scope configuration , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , LOD-ANA-ML-DE , SAC Data Wrangling , Problem
SAP Knowledge Base Article - Public