2586663 - Encountered error "numeric or value error: character string buffer too small" while running Ad Hoc report of Foundation Object

SAP Knowledge Base Article - Public

2586663 - Encountered error "numeric or value error: character string buffer too small" while running Ad Hoc report of Foundation Object

Symptom

  • Unable to Run Ad Hoc Report of Foundation Object domain
  • Error Message- numeric or value error: character string buffer too small

Environment

Ad Hoc Report Builder

Reproducing the Issue

  • Home > Analytics > Reporting > Ad Hoc Report > Create New Report
  • Select "Foundation Object" Sub domain Schema
  • Generate or Preview the Ad Hoc Report.
  • Error Message encountered

Error Message - com.successfactors.analytics.queryengine.exceptions.QueryEngineException: Error encountered in executing the query Error encountered in executing the query.ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "SYS.XMLTYPE", line 169

Cause

  • As per code design, the query internally uses xmlagg function to show multiple values under a column in same row. 
  • Currently the data type used is VARCHAR2 which won't allow more than 4000 characters. 
  • In order to support more than 4000 chars we should have data type as clob which is not supported by Adhoc Report.

Resolution

  • Data Type clob is not supported.
  • Please use lesser number of associations as workaround.

See Also

Below Engineering Tickets can be visible only to SAP Employees for further references on the same:
https://jira.successfactors.com/browse/ECT-88171
https://jira.successfactors.com/browse/ECT-74654

Keywords

Ad Hoc
Ad Hoc Report
Adhoc
Foundation Object
ORA-06512
ORA-06502
SYS.XMLTYPE
character string buffer
4000 Chars
Clob , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

Product

SAP SuccessFactors HCM Core all versions