Unable to Run Ad Hoc Report of Foundation Object domain
Error Message- numeric or value error: character string buffer too small
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
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.
Data Type clob is not supported.
Please use lesser number of associations as workaround.
Ad Hoc Report
character string buffer
Clob , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem