SAP Knowledge Base Article - Public

3513925 - Failure in Generating User Change Report in SAP SuccessFactors Platform

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

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

Product

SAP SuccessFactors Platform all versions