When searching for User IDs, over a 1000 records are placed using IDs seperated by commas, an error appears.
SuccessFactors Learning Management System (LMS) - All Supported Versions
Reproducing the Issue
- Go to Users
- Search by User ID
- Make sure that the type of search is for ANY
- Place 1000+ User ID's seperated by commas in the search field box
- Click on Search
This error is due to a configuration having been changed from the default value
To fix this issue, a configuration file needs to be editided as it has been changed from the default value.
- Go to System Admin
- System Configuration
- edit SEARCH configuration file
- Look for maxInListItems
- Please change to 1000
Now the configuration file will be maxInListItems=1000
Attempting the same reproduction steps, the error will not appear.
ORA-01795, maximum number of expressions in a list is 1000, user search, ID search, User ID search, user, search, error ORA, ORA error , KBA , LOD-SF-LMS-ADM , Admin Tools , Problem