Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-35585

Duplicate assessment throws an error when assessment's title is too long

    XMLWordPrintable

    Details

    • 10 status:
      Resolved
    • Previous Issue Keys:
      SAM-2571

      Description

      Steps to reproduce the issue:

      1. Create an assessment which title has 255 characters.
      2. Try to duplicate the assessment by clicking the "Duplicate" option. The duplication fails and that stack trace is shown:

      Caused by: java.lang.RuntimeException: org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [insert into SAM_ASSESSMENTBASE_T (PARENTID, TITLE, DESCRIPTION, COMMENTS, TYPEID, INSTRUCTORNOTIFICATION, TESTEENOTIFICATION, MULTIPARTALLOWED, STATUS, CREATEDBY, CREATEDDATE, LASTMODIFIEDBY, LASTMODIFIEDDATE, ASSESSMENTTEMPLATEID, isTemplate, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '0', ?)]; SQL state [72000]; error code [12899]; Could not execute JDBC batch update; nested exception is org.hibernate.QueryTimeoutException: Could not execute JDBC batch update
      at org.sakaiproject.tool.assessment.services.assessment.AssessmentService.copyAssessment(AssessmentService.java:1036)
      at org.sakaiproject.tool.assessment.ui.listener.author.CopyAssessmentListener.processAction(CopyAssessmentListener.java:23)
      at javax.faces.event.ActionEvent.processListener(ActionEvent.java:88)
      at javax.faces.component.UIComponentBase.broadcast(UIComponentBase.java:774)

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  samigoteam SAMIGO TEAM (Inactive)
                  Reporter:
                  raulsv Raúl Sánchez Vegas
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration