SAP Knowledge Base Article - Public

2901158 - Change Audit Reports fail with application errors "could not insert" or "SQLException caught"

Symptom

When attempting to request a Change Audit Report with Person field defined as a filter, request fails and one of the application error messages below is displayed:

  • could not insert: [com.successfactors.jobscheduler.bean.JobScheduleRequestEO]
  • SQLException caught: SAP DBTech JDBC: [274]: inserted value too large for column: Failed in "JOB_NAME" column

Environment

SAP SuccessFactors HXM Suite

Reproducing the Issue

  1. Go to the Change Audit Report Tool
  2. Select Create Personal Data Report and then any of the options available
  3. Mark either Change on Subject User or Change By User
  4. Provide the respective Person information and the additional filters (Modules, Functional Areas, Time Range, etc)
  5. Click Submit and see the error message

Cause

There is a known limitation for the Change Audit Report to support Person as criteria for a personal data report. Currently, the person name cannot exceed 67 characters.

Resolution

A code fix for this, aiming to remove this limitation, will be rolled out on system release b2011, planned for October/November 2020.

In the meantime, as a workaround, please temporarily adjust the person name on the User Data File (to make its length not exceed 67 characters) and then re-attempt submitting the report. You can add the previous name back to the User Data File after that.

See Also

Keywords

change audit report, audit framework, error, application error, fails, failure, problem, change on, changed by, exception, value too large, SQLException, PRB0041898, PLC-24129 , KBA , LOD-SF-PLT-AUDR , Request Audit Report (Not Change Audit) , Problem

Product

SAP SuccessFactors HCM Suite all versions