3059124 - Application Error when Enable Distinct is on and Field is a Comments field in Table report - Recruiting Management

When Running or Previewing a Table report based on Recruiting and the Comments field from Application is selected combined with Enable Distinct, the following error occurs:

"An application error occurred. Please try again later, or notify support (with the error information of errorId=b5546239-9562-4a9b-80b4-64ffdc9c9f7a, timestamp=20xxxx-xxT11:45:43.043+0000, and the version information from the current screen) if the issue keeps occurring.
Click Cancel to continue. "

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental

SAP SuccessFactors Recruiting

1. Go to Reporting
2. Create a new Table report and ensure that Comments field from Application (or similar field from other tables) are selected
3. Select Enable Distinct option under columns
4. Preview the report
   Result: Error
5. If trying to generate the report, the csv file does not have any data
   
   

The data type of the column is not supported when combined with Enable Distinct. You will see the following error in the backend:

Error encountered in getting the data.com.successfactors.analytics.queryengine.exceptions.QueryEngineException: Error encountered in executing the query. SAP DBTech JDBC: [264]: invalid datatype: LOB type in distinct select clause...

We suggest removing the Comments field (e.g. Reference Comments or anything similar) from the report since this field contains a long string or perhaps paragraphs and cannot be processed for distinct checking.  Also, if this field contains more than 4000 characters for comments, then it will hit a database limitation for reporting.

After removing the field that is causing data type and enable distinct issues, the report will start working again - Preview and Run will display data.

Another alternative is to disable "Enable Distinct" selection under columns. It does not work well with fields of this type.

enable distinct, data type error,  ad hoc, table report, invalid datatype, LOB type in distinct , KBA , LOD-SF-RCM-REP , Reporting & Analytics, Data Imports & Exports , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem