SAP Knowledge Base Article - Public

2859633 - Import data load rejects rows in SAP Analytics Cloud (SAC)

Symptom

  • The Import data load is rejecting rows.  Download the Rejected rows it shows as "Invalid Data Type".

Environment

  • SAP Analytics Cloud 2019
  • Import Connection

Reproducing the Issue

  1. Create a Import Connection 
  2. Create a model
  3. Schedule to load data to the above model
  4. The load data rejects rows.  Download the Rejected rows it shows as "Invalid Data Type".

Cause

All of the row value of for a particular column were changed from "dd.mm.yyyy hh:mm:ss" to "mm/dd/yyyy hh:mm:ss" on the source system ( for this case, SAP Cloud for Customer system)

Resolution

Data is being rejected because the format of the new data does not match the existing data.

You can create a new import job from the same source and map the new columns to the existing columns;

Alternatively you could rebuild your model:

    1. Open the model to the "model" tab
    2. Click icon "Rebuild Model" in the toolbar at the top
    3. Select the column that was changed
    4. In the side panel, change the date format from DD.MM.YYYY to MM/DD/YYYY
    5. Note that this will highlight all of the existing row values as red.
    6. Click button "Rebuild Model" on the bottom right.
    7. You will notice the initial load will reject all rows because the original data is in DD.MM.YYYY format. But after the initial load, upcoming loads will be successful. If data format is changed on C4C side again, you will also have to rebuild again.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem

Product

SAP Analytics Cloud 1.0