SAP Knowledge Base Article - Public

2903110 - An error occurred in Connection Server service: Value out of range happens when importing data in SAP Analytics Cloud (SAC)

Symptom

The following error occurs in SAP Analytics Cloud (SAC) when importing data to models from SAP ERP connection:

  • An error occurred in Connection Server service:
    Value out of range. Value:"XXXX" (Where XXXX is a number larger than 32767)

Environment

  • SAP Analytics Cloud (Enterprise) 2020.4.5

Reproducing the Issue

  1. Logon to SAC tenant and create a model based on imported SAP ERP connection.
  2. Select the connection name and choose to create a new query or using existing query.
  3. Select the query name and choose objects to import.
  4. There's no error happens in preview page.
  5. Once you click OK and the data will start to import.
  6. Notice the data import failed with above error.

Cause

  • This issue is with the Jco driver which transform the ERP datatypes into java types to create a temporary buffer to hold the resultset that is received from the ERP, in order to be able to process it and transfer it to the acquisition layer.
  • The adapter deduces from the metadata of the query that the values for the field fit into a Short java type (holding values from -32768 to 32767) by mistake.
  • If the field of ERP datatype has a number of decimal places that is not 0, the field will be retrieved as a String.
  • If the field of ERP datatype has no decimal places, it will be retrieved as an Integer, and the adapter will try to store the values into a Java type that is just "big enough" to save memory.

Resolution

Change ERP datatype to switch to the field with at least 1 decimal place should resolve the issue.

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-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0