Symptom
- The User Change Report in SAP SuccessFactors Platform fails to execute for a specified period.
- The failure triggers an email notification to the user. The associated error message is "java.sql.SQLException: Internal error processing the query. Please try again later."
Environment
SAP SuccessFactors HCM 2405
Reproducing the Issue
1. Access the SAP SuccessFactors Platform.
2. Navigate to Change Audit Report.
3. Proceed to Create Business Data Report.
4. Select User Change.
5. Execute the report for a specific period, for instance, from January 1st 12:00 AM till January 15th 11:59 PM.
6. Click on submit.
Cause
This typically would tell that an expensive request was run in the backend causing the failure.
Resolution
The ENG team has made adjustments to the system in the backend to prevent future occurrences. If this issue happens again, we recommend trying to run the report after some time as this should resolve the problem. If the issue persists, please submit a support case under component LOD-SF-PLT-CHA and the ENG team will be engaged afterwards
See Also
- KBA 3473463 - Audit Data Transition to BTP Audit Log Service in 1H 2024
- Community thread - DRTM Audit Data Purge Deprecation and Transition to BTP Audit Log Service in 1H 2024
Keywords
SAP SuccessFactors, Change Audit Report, User Change Report, Failure, Execution, java.sql.SQLException, Internal error, Query processing, sf, sfsf , sf sf, SuccessFactors, SuccessFactor, Success Factor, bizx, NGPBUG-400786, EDP-1451, EDP-1469, Provider NonGDPR.USER_REL_MAP (MODULE_ADMIN) failed. Root error: java.sql.SQLException: Internal error processing the query. Please try again later, retrieving audit logs in many ALS regions, INC9243819 , KBA , LOD-SF-PLT-CHA , Change Audit , LOD-SF-PLT-AUDR , Request Audit Report (Not Change Audit) , Problem
SAP Knowledge Base Article - Public