SAP Knowledge Base Article - Public

2188180 - Unable to run job - "The action you are trying to perform is affecting too many records and it exceeds the threshold for online processing."

Symptom

While attempting to run a job, for example the Manage Assignments tool, a validation error is shown:

Validation Error

You must correct the following error(s) before proceeding:

The action you are trying to perform is affecting too many records and it exceeds the threshold for online processing. Please schedule this action to run in the background

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Access Learning Administration >
  2. Schedule any background job (for example, Manage User Learning > Manage Assignments) >
  3. Select an option from the Add menus to assign Curriculum/Items/Programs etc to the Users >
  4. Add more than 5 users and click next step >
  5. Add the Curriculum/Items/Programs to be assigned to the Users >
  6. Continue through the tool >
  7. In the final step, to run the job immediately select "Run Job Now" button. You will get Validation error on the page that the Job cannot be run immediately.

Cause

The online processing threshold is defind by configuration setting "onlineOperationMaxRecordsCount" in LMS_ADMIN configuration file. By default the value is set to 5.

Resolution

By default the application will look at the amount of records that will be impacted by a job and cross reference the "onlineOperationMaxRecordsCount" setting.

This flag can be modified in the LMS_ADMIN under System configuration (System Administration > Configuration > System Configuration > LMS_Admin).

It is not recommended to choose a value greater than 100.

Most jobs that have the ability to "Run Job Now" and "Schedule Job" will be impacted by this setting. Examples include:

  • Manage Assignments
  • Edit Required Dates
  • Add Learning History
  • Import Content

There are some jobs that do not adhere to this setting such as:

  • Reports
  • Connectors
  • Automatic Processes

It is advised that if seeing the above validation error, to choose to schedule the job.

Note: As of 1H 2021 release, onlineOperationMaxRecordsCount is no longer used for Curricula and is controlled by the system for performance.

Keywords

User Needs Management, validation error, affecting too many records, exceeds the threshold for online processing, onlineOperationMaxRecordsCount, learning, SuccessFactors. , KBA , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-BCJ , Assign (bulk), Add/ Delete Sub/ Cur, Revise, Import , Problem

Product

SAP SuccessFactors Learning all versions