SAP Knowledge Base Article - Public

3287800 - 900-001-6 Error when accessing Executive Review

Symptom

900-001-6 Error when trying to sort data in EXR compensation and variable pay template. 

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

Environment

SAP SucessFactors Compensation

SAP SucessFactors Variable Pay

Reproducing the Issue

Navigate to EXR > click on the template > Sort based on one of the columns ((totalRaise, mgrFirstName, mgrLastName, totalIncrease, totalComp) > the following error is received. 

Support can check in splunk with <Company ID> AND AcmeServlet , the logs should like below
SQLException SAP DBTech JDBC: [260]: invalid column name: not included in SELECT DISTINCT column list: 

Cause

Engineering team is aware of this issue and are working on the fix. 

Resolution

Workaround : To create custom column OR not use the fields(totalRaise, mgrFirstName, mgrLastName, totalIncrease, totalComp) for sorting. For mgrFirstName, mgrLastName fields a custom reportable field mapped to Employee Profile > Manager field can be used to sort.

This issue has been resolved as part of patch23 released on Jan 23rd (prev) and Jan 25th(prod).

Keywords

sorting in EXR, error in EXR, KI2211 , CMP-30038 , KBA , LOD-SF-CMP-EXR , Executive Review , Problem

Product

SAP SuccessFactors HXM Core 2211