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

HTTP Status 500 Error when downloading audio file from audio question in Tests & Quizzes

    XMLWordPrintable

    Details

    • 2.9 Status:
      Resolved
    • Conversion Script Required:
      Yes
    • Previous Issue Keys:
      SAK-19971, SAM-1216

      Description

      I created a test with an audio file question in a project site.
      I submitted as access role.
      I went to the test as maintain user.
      I went to the question (Scores > Questions > selected the question > clicked the "here" link to download the file)
      Received the following error:
      HTTP Status 500 -
      ________________________________________
      type Exception report
      message
      description The server encountered an internal error () that prevented it from fulfilling this request.
      exception
      org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not load an entity: org.sakaiproject.tool.assessment.data.dao.grading.MediaData#1; uncategorized SQLException for SQL [select mediadata0_.MEDIAID as MEDIAID190_1_, mediadata0_.ITEMGRADINGID as ITEMGRAD2_190_1_, mediadata0_.MEDIA as MEDIA190_1_, mediadata0_.FILESIZE as FILESIZE190_1_, mediadata0_.MIMETYPE as MIMETYPE190_1_, mediadata0_.DESCRIPTION as DESCRIPT6_190_1_, mediadata0_.LOCATION as LOCATION190_1_, mediadata0_.FILENAME as FILENAME190_1_, mediadata0_.ISLINK as ISLINK190_1_, mediadata0_.ISHTMLINLINE as ISHTMLI10_190_1_, mediadata0_.STATUS as STATUS190_1_, mediadata0_.CREATEDBY as CREATEDBY190_1_, mediadata0_.CREATEDDATE as CREATED13_190_1_, mediadata0_.LASTMODIFIEDBY as LASTMOD14_190_1_, mediadata0_.LASTMODIFIEDDATE as LASTMOD15_190_1_, mediadata0_.DURATION as DURATION190_1_, itemgradin1_.ITEMGRADINGID as ITEMGRAD1_185_0_, itemgradin1_.ASSESSMENTGRADINGID as ASSESSME2_185_0_, itemgradin1_.PUBLISHEDITEMID as PUBLISHE3_185_0_, itemgradin1_.PUBLISHEDITEMTEXTID as PUBLISHE4_185_0_, itemgradin1_.AGENTID as AGENTID185_0_, itemgradin1_.SUBMITTEDDATE as SUBMITTE6_185_0_, itemgradin1_.PUBLISHEDANSWERID as PUBLISHE7_185_0_, itemgradin1_.RATIONALE as RATIONALE185_0_, itemgradin1_.ANSWERTEXT as ANSWERTEXT185_0_, itemgradin1_.AUTOSCORE as AUTOSCORE185_0_, itemgradin1_.OVERRIDESCORE as OVERRID11_185_0_, itemgradin1_.COMMENTS as COMMENTS185_0_, itemgradin1_.GRADEDBY as GRADEDBY185_0_, itemgradin1_.GRADEDDATE as GRADEDDATE185_0_, itemgradin1_.REVIEW as REVIEW185_0_, itemgradin1_.ATTEMPTSREMAINING as ATTEMPT16_185_0_, itemgradin1_.LASTDURATION as LASTDUR17_185_0_ from SAM_MEDIA_T mediadata0_ left outer join SAM_ITEMGRADING_T itemgradin1_ on mediadata0_.ITEMGRADINGID=itemgradin1_.ITEMGRADINGID where mediadata0_.MEDIAID=?]; SQL state [99999]; error code [17027]; Stream has already been closed; nested exception is java.sql.SQLException: Stream has already been closed
      org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
      org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
      org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
      org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
      org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
      org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
      org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
      org.springframework.orm.hibernate3.HibernateTemplate.load(HibernateTemplate.java:563)
      org.springframework.orm.hibernate3.HibernateTemplate.load(HibernateTemplate.java:557)
      org.sakaiproject.tool.assessment.facade.AssessmentGradingFacadeQueries.getMedia(AssessmentGradingFacadeQueries.java:713)
      sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      java.lang.reflect.Method.invoke(Method.java:597)
      org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
      org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
      org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
      org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      $Proxy80.getMedia(Unknown Source)
      org.sakaiproject.tool.assessment.services.GradingService.getMedia(GradingService.java:423)
      org.sakaiproject.tool.assessment.ui.servlet.delivery.ShowMediaServlet.doPost(ShowMediaServlet.java:87)
      org.sakaiproject.tool.assessment.ui.servlet.delivery.ShowMediaServlet.doGet(ShowMediaServlet.java:67)
      javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
      javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
      org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:653)
      note The full stack trace of the root cause is available in the Apache Tomcat/5.5.28 logs.
      ________________________________________
      Apache Tomcat/5.5.28

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  samigoteam SAMIGO TEAM (Inactive)
                  Reporter:
                  alanregan Alan Regan
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  6 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration