NPE When trying to Delete Assignments with Comments
Description
Attachments
- 14 Oct 2021, 12:35 PM
- 14 Oct 2021, 12:34 PM
Activity
Andrea Schmidt March 7, 2022 at 11:23 PM
Verified on 22x: https://qa22-mysql.nightly.sakaiproject.org/, build: 8947e9b0 using LTI 1.3
Andrea Schmidt November 1, 2021 at 11:27 PM
Verified on 23x: https://trunk-mysql.nightly.sakaiproject.org/, build: 727a61ea for LTI 1.3.
Tested with an assignment sent to the GB and one not sent to the GB. No stacktrace - messages in logs:
01-Nov-2021 19:17:30.232 INFO [http-nio-20013-exec-65] o.s.b.u.SakaiBLTIUtil.handleAssignment Submitted submission=1eb3b6d4-8d2a-4363-a538-d2d3922e3db0 userId=64e161f1-99c5-41f5-b2f6-a354e235c7b1 log=Mon, 1 Nov 2021 19:17:30 -0400 LTI 90.0 Instructor comment to student
01-Nov-2021 19:21:52.677 INFO [http-nio-20013-exec-45] o.s.c.g.GradebookExternalAssessmentServiceImpl.lambda$removeExternalAssessment$1 Deleted 1 externally defined scores
01-Nov-2021 19:21:52.679 INFO [http-nio-20013-exec-45] o.s.c.g.GradebookExternalAssessmentServiceImpl.lambda$removeExternalAssessment$1 Deleted 1 externally defined comments
01-Nov-2021 19:21:52.679 INFO [http-nio-20013-exec-45] o.s.c.g.GradebookExternalAssessmentServiceImpl.removeExternalAssessment External assessment removed from gradebookUid=59a283dc-6f28-4ee1-9606-e7a573f1c376, externalId=/assignment/a/59a283dc-6f28-4ee1-9606-e7a573f1c376/2e36acde-afff-4b6d-ab4c-1f26dd9cb1ad by userUid=b6b32874-cafc-451c-a2e5-a372a2029206
Shawn Foster November 1, 2021 at 3:22 PM
Thanks for clarifying!
Charles R Severance October 31, 2021 at 2:38 PM
@Shawn Foster - The error only appears in the logs. In the UI - it simply fails to work with no error message at all. It comes pack to the same page.
Shawn Foster October 18, 2021 at 6:33 PM
@Charles R Severance - does the error appear on the page to the end-user? Or is the error only in the logs? What does the user experience?
Make an assignment, add a submission with a comment then try to delete the comment - See full traceback in attachment.
Caused by: java.sql.SQLSyntaxErrorException: (conn=1883) Unknown column 'gradableObject' in 'where clause'
…
org.sakaiproject.component.gradebook.GradebookExternalAssessmentServiceImpl.lambda$removeExternalAssessment$1(GradebookExternalAssessmentServiceImpl.java:281) ~[?:?]
…
at org.sakaiproject.assignment.tool.AssignmentAction.deleteAssignmentObjects(AssignmentAction.java:10142) ~[classes/:?]
at org.sakaiproject.assignment.tool.AssignmentAction.doDelete_assignment(AssignmentAction.java:10112) ~[classes/:?