Symptom
You are attempting to import data to SAP Analytics Cloud and experience the following error:
Temporary storage does not contain valid records. Every record sent is incorrect. Please review all records and retry. [1011]
Environment
SAP Analytics Cloud Revision 2023 and higher
Reproducing the Issue
- Create a FactData Import Job.
- Post an invalid row to the job. For example, the below screenshot contains the value 'abc' for the 'DecimalMeasure' column, which is an incorrect datatype. The expected datatype is a decimal in this case.
- The response indicates the reason for rejection of this row.
-
For scenarios where data is uploaded through a browser, requests can be seen within the "Network Tab" of Developer Tools.
In the response of the job request, (/job/jobID), the reason for rejection is provided.
Cause
This error occurs when all of the rows that were posted to the Data Import API job are not accepted by the Data Import API.
The most common cause for this is when a particular value in the row does not comply with the data type of the column.
For example:
- The source data is not compatible with the backend database staging table, due to, for example, datatype mismatches, where the source is a character datatype and the target is a decimal datatype.
Resolution
Change the value of the row to a compatible value and post the row to the job to see the results have been successfully imported.
See Also
SAP Analytics Cloud REST API Importing Data - API Request Details
SAP Analytics Cloud REST API Error Codes and Troubleshooting
Keywords
Data Import API, Data Integration, SAC, Data Import Service, SAP Analytics Cloud, /jobs/{jobID}/invalidRows, /jobs/{jobID}/validate, /api/v1/dataimport/jobs, Every record sent is incorrect , KBA , LOD-ANA-ML-DI , Data Integration, Data Export API, Data Import API , LOD-ANA-ML , SAC Modelling , How To