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

Samigo is broken for students in oracle

    Details

    • 11 status:
      Resolved
    • Previous Issue Keys:
      SAM-2742

      Description

      Click the Samigo tool link as student. Samigo fails. Stacktrace:

      Stacktrace:
          at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:476)
      caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select distinct assessment0_.ASSESSMENTGRADINGID as col_0_0_, publisheda1_.ID as col_1_0_, publisheda1_.TITLE as col_2_0_, assessment0_.AGENTID as col_3_0_, assessment0_.SUBMITTEDDATE as col_4_0_, assessment0_.ISLATE as col_5_0_, assessment0_.FORGRADE as col_6_0_, assessment0_.TOTALAUTOSCORE as col_7_0_, assessment0_.TOTALOVERRIDESCORE as col_8_0_, assessment0_.FINALSCORE as col_9_0_, assessment0_.COMMENTS as col_10_0_, assessment0_.STATUS as col_11_0_, assessment0_.GRADEDBY as col_12_0_, assessment0_.GRADEDDATE as col_13_0_, assessment0_.ATTEMPTDATE as col_14_0_, assessment0_.TIMEELAPSED as col_15_0_ from SAM_ASSESSMENTGRADING_T assessment0_, SAM_PUBLISHEDASSESSMENT_T publisheda1_, SAM_AUTHZDATA_T authorizat2_ where assessment0_.PUBLISHEDASSESSMENTID=publisheda1_.ID and assessment0_.FORGRADE=? and assessment0_.AGENTID=? and (authorizat2_.AGENTID=? or authorizat2_.AGENTID in (? , ?)) and authorizat2_.FUNCTIONID=? and authorizat2_.QUALIFIERID=publisheda1_.ID and (publisheda1_.STATUS=? or publisheda1_.STATUS=?) order by publisheda1_.ID DESC, assessment0_.SUBMITTEDDATE DESC]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
          at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:414)
      caused by: org.hibernate.exception.SQLGrammarException: could not execute query
          at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
      caused by: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got CLOB
      
          at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
          at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
          at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
      

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  jonespm Matthew Jones
                  Reporter:
                  raulsv Raúl Sánchez Vegas
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration