ELM9.2: Error Occurs When Dropping From A Class Via ESS If Learner Group Security Removed From Class
(Doc ID 3066128.1)
Last updated on JANUARY 13, 2025
Applies to:
PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
Learners are getting a SQL error when attempting to drop classes through Employee Self Service pages. This occurs for classes that have had their Learner Group security removed.
Fatal SQL error occurred.
LM_DB.DBAccess.OnExecute Name:Update PCPC:1315 Statement:31
Called from:LERM_MAINTAIN_ACTIVITY.ActivityTotals.OnExecute Name:Update Statement:42
Called from:LEE_ENROLLMENT.LEE_ENROLLMENT.OnExecute Name:lockActivity Statement: 1832
Called from:LEE_ENROLLMENT.LEE_ENROLLMENT.OnExecute Name:drop Statement:543
Called from:LM_PROGRAM_SS_FLU.GBL.LM_CI_EN_FL_WRK.LM_DROP_BTN.FieldChange Statement:40
LM_DB.DBAccess.OnExecute Name:Update PCPC:1315 Statement:31
Called from:LERM_MAINTAIN_ACTIVITY.ActivityTotals.OnExecute Name:Update Statement:42
Called from:LEE_ENROLLMENT.LEE_ENROLLMENT.OnExecute Name:lockActivity Statement: 1832
Called from:LEE_ENROLLMENT.LEE_ENROLLMENT.OnExecute Name:drop Statement:543
Called from:LM_PROGRAM_SS_FLU.GBL.LM_CI_EN_FL_WRK.LM_DROP_BTN.FieldChange Statement:40
The issue can be reproduced at will with the following steps:
1. Navigate to ESS > Learning tile > My Learning > View all
2. Select a program and try to drop yourself from a class in the program
3. Fatal SQL error will occur
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |