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
- Create or use a Model that contains a Public Dimension.
- Create an Import Job.
- Select 'Clean & Replace Subset of Data' as the import method.
- Select a Public Dimension as the scope for the method (+ Add Scope button).
- Run the Import Job and observe it fails with the error mentioned in the Symptom section.
- 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
SAP Knowledge Base Article - Public