SAP Knowledge Base Article - Public

3149522 - File in xlsx format can not be uploaded, because of an internal server error in SAP Analytics Cloud (SAC) & SAP Digital Boardroom

Symptom

The following behavior occurs in SAP Analytics Cloud (SAC):

  • While uploading the file in a new data model the error message comes up, that file can´t be uploaded, because of an internal server error in the data import service.
  • The job failed due to an unexpected internal server error. Please contact your system administrator.
  • Filename.xlsx has failed to upload because the data acquisition service encountered an internal error. Correlation ID: 18362223-7033-4258-9335-418318480853

Environment

  • SAP Analytics Cloud (Enterprise) Version 2021.20

Reproducing the Issue

    1. Open Apps-Modeler.
    2. Create New - From a CSV or Excel Fie
    3. Observe that import starts.
    4. Observe that the import is loading an then being processed.
    5. Filename.xlsx has failed to upload because the data acquisition service encountered an internal error.
    6. Correlation ID: 62149851-0583-4614-b512-928347169241
    7. Resave the same file CSV format.
    8. Observe that filename.csv upload has completed successfully.

    Cause

     The issue is with a column that was formatted as "Number" data type in Excel, but the column contained values that also had letters in them. Specifically, the issue was the value 12345678 which can be read in scientific notation. Any numbers with "E" between would be parsed as Infinity and lead to error. 

    Since it is formatted as a number, SAC parses this value as Infinity which leads to error. 

    Resolution

    The solution is to format the column as "Text" in Excel before upload.

    To format: right click on the column and select "Format Cells...".

     
     

    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, sap analyst cloud, connected, failure, stopped, sap analyst cloud,has failed to upload because the data acquisition service encountered an internal error, internal error, upload, xlsx,csv, failed, upload, format,  , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

    Product

    SAP Analytics Cloud 1.0