3592903 - Application error when trying to access "Employee Associated With Invalid Data"

You receive an application error when trying to access Employees Associated With Invalid HR Data.

• The application error for Employees associated with invalid HR Data page is throwing JDBC error on a Ajax call. ManageInvalidFOController.getPageInitializer
• Please open a ticket and include the service trace files which cover the time of the query execution

 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 Employee Central - Foundation Objects

1. Go to admin center 
2. Select :Employees Associated With Invalid HR Data
3. Error message:
   Result: An application error occurred. Please try again later, or notify support (with the error information of errorId=XXXXXXXX, timestamp= XXXXX

SAP Internal log: 

Caused by :SAP DBTech JDBC: [X]: general error: Internal error. Please open a ticket and include the service trace files which cover the time of the query execution

This is considered as a defect in 2411 release

Internal Error log: Caused by :SAP DBTech JDBC: [X]: general error: Internal error. Please open a ticket and include the service trace files which cover the time of the query execution

• JDBC error on a AJaxcall.`ManageInvalidFOController.getPageInitializer'
• The old admin alerts available in "Employees Associated With Invalid HR Data" are broken because the SQL query generated in EmpJobInfoDAOImpl.getSeperateCountJobInfoWithInValidFOs() can no longer be executed. 

The issue is currently under investigation (potentially enhance the admin alerts with 2511) by our Engineering team and a fix will be delivered. 

The aimed fix date is the H1 2025 release 2505.12 (2505) :

• Release reference: ECT-249672 / View: Release and Patch Schedules

Planned Release date:

1. Preview:  14 April 2025
2. Production: 16 May 2025

This KBA will be updated with more information as it becomes available.

• 2472648 - Using the Check Tool to Check a SuccessFactors Configuration
• 2761632 - Application Error appearing in Employees Associated with Invalid HR Data - Employee Central 

INC12091019, ECT-249672,Fix broken SQL query for old Admin Alerts transaction, Employees Associated With Invalid HR Data , EmpJobInfoDAOImpl.getSeperateCountJobInfoWithInValidFOs(), SAP DBTech JDBC: [X]: general error: Internal error. Please open a ticket and include the service trace files which cover the time of the query execution,JD BC error on a AJaxcall.`ManageInvalidFOController.getPageInitializer , KBA , LOD-SF-EC-ADM , Admin Tools (EC Core only) , Problem