2420588 - Error raised by Connection Server service for Input String in BusinessObjects Cloud when loading negative values into a model

SAP Knowledge Base Article - Public

2420588 - Error raised by Connection Server service for Input String in BusinessObjects Cloud when loading negative values into a model

Symptom

  • "An error occurred in Connection Server service: For input string: "<number>-""  error appears when loading data from ERP infoset.
  • Problem occurs when creating new model or when importing data into the model.
  • The infoset contains a field with data type of "I: Integer number (4-byte integer with sign)" and also negative values defined in it.
  • Issue is not reproducible with the data type of "P: Packed Number".

Environment

  • SAP BusinessObjects Cloud 2016.24.3
  • Import Data Connection
  • SAP ERP 6.0 EHP 0

Reproducing the Issue

  1. Create an infoset and define a field with "I: Integer number (4-byte integer with sign)"
  2. Make sure this field contains negative values, for example "1-"
  3. Create a model in SAP BusinessObjects Cloud based on that ERP query
  4. Error appears while loading the data:
    An error occurred in Connection Server service: For input string: "1-"

Cause

SAP ERP's version is not supported by the PAM for BusinessObjects Cloud.

Resolution

Upgrade the ERP to the supported version or change the affected field's data type as "P: Packed Number".

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating facility at the top right-hand corner of this article.
Thank you.

Keywords

EPM, 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,  , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0