3801343 - Error when setup upload job in model Data Management

• Error "Failed to validate" in screen.
• Error message in HAR trace: "ERROR: Failed to create table from view (Error Code: 1039)"

• SAP Analytics Cloud Enterprise

1. Open the target model
2. Create an upload job using load file.
3. Click Set Up Upload of the created upload job.
4. Proceed to mapping and map the source columns to model dimensions/measures.
5. Click Next button to go to Step 3 and see the error

• The model Version dimension is mapped to a default value, while the job source has another column that is literally called "Version" and is mapped to another dimension. This is causing an error when we process the data in backend because of duplicate column name: Version.

1. In the Step 1: Prepare Data, duplicate the Version column with a different name, like Version_1.
2. Go to Step 2: Map to Facts, do the data mappings and use Version_1 to map to model dimension.

upload job, validation error, error code 1039, failed to create table from view, duplicate column name, version dimension, import model, csv upload, mapping, fixed value, date dimension, data preparation, validation stage, sac model, wrangling , KBA , LOD-ANA-ML-DE , SAC Data Wrangling , Problem