SAP Knowledge Base Article - Public

3513170 - Error: "Data validation ended unexpectedly. Error code: 1032" when importing from BW in SAC.

Symptom

The below errors occur when importing data from BW to SAP Analytics Cloud:

  • "Failed to validate".
  • "Data validation ended unexpectedly. Error code: 1032"

Environment

SAP Analytics Cloud

Reproducing the Issue

  1. Login to SAP Analytics Cloud.
  2. Navigate to the Modeler.
  3. Open a model based on BW acquired connection.
  4. Refresh an existing import job.
    >>Notice the below error in the Data Timeline Panel: "Data validation ended unexpectedly. Error code: 1032"

Cause

  • The date column was generated using a custom function "now()", which is not officially supported and not included in the list of standard functions.
  • This led to the date format being "MMYYY".

Resolution

  • Clean the data in the date column to ensure all values are in the correct format for example "DDMMYYY".
  • Reapply the transforms after cleaning the data.

Keywords

 SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud, BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, import, refresh, error, query , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0