Symptom
When searching Users in the LMS administrator there is a an error thrown when view details the following line is seen.
"Error message = Cannot initialize the value object: Invalid column name
java.sql.SQLException: Invalid column name"
Environment
SAP SuccessFactors Learning
Cause
This was made aware during an update for the product, but this error can be generated if the search selector is customized.
Resolution
- Revert the search selector, From the LMS Administrator go to System Administration -> Configuration -> Search Selectors -> Edit the "User" selection. Revert all changes back to default. This can be done by selecting view configuration changes and copying Everything below "Default configuration" and above "You Configuration Changes" , then pasting that into the configuration field, this will restore the support default search.
- Customizations to the search selector is something that customers are allowed to do, but are not supported and as such not validated in tests for any new releases. If there are changes to the code that changes the search selector, a redesign of the custom search selector may need to be done, this will need to be handled by the Partner or individual that created the custom search selector.
Additional Information
From feedback we have received from other customers and development below information may be taken to the creator of the search selector as additional information to provide to see if it helps find a solution for this customization. This is just informational data being provided and does not encapsulate that support knows how to implement the below information as this is out side of what support is trained on since we only support the default function of this feature.
Some customers have reported the following was added by their partners or person(s) whom created this search selector and has resolved their issue, again, please reach out to creator of the search selector before implementing anything listed below. We will add more if we get any additional feedback from development or customers that find other solutions.
- Append "PA_STUDENT.LICENSE_USER_TYPE" to "selectClause.mainSqlClause" in Admin -> System Administration -> Configuration -> Search Selector -> User
Keywords
Learning Management System, b2011, Preview, Generic Error, Assignment Profile. AP , KBA , LOD-SF-LMS-ADM , System Admin, Global Variables, References , Problem