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

Create sequence statement missing from conversion script

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.9.0
    • Fix Version/s: 2.9.0
    • Component/s: Messages Tool
    • Labels:
    • 2.9 Status:
      Resolved
    • Conversion Script Required:
      Yes
    • Previous Issue Keys:
      MSGCNTR-647

      Description

      The statement for creating the sequence for the new MFR_HIDDEN_GROUPS_T table is absent from the 3.0.0 conversion scripts. This feature is failing on qa3 with the following error:

      \f0\fs24 \cf0 org.sakaiproject.portal.api.PortalHandlerException: org.sakaiproject.tool.api.ToolException: javax.servlet.ServletException: #{PrivateMessagesTool.processPvtMsgSettingsSave}: javax.faces.el.EvaluationException: org.springframework.dao.InvalidDataAccessResourceUsageException: could not get next sequence value; nested exception is org.hibernate.exception.SQLGrammarException: could not get next sequence value\
      at org.sakaiproject.portal.charon.handlers.ToolHandler.doPost(ToolHandler.java:73)\
      caused by: org.sakaiproject.tool.api.ToolException: javax.servlet.ServletException: #{PrivateMessagesTool.processPvtMsgSettingsSave}: javax.faces.el.EvaluationException: org.springframework.dao.InvalidDataAccessResourceUsageException: could not get next sequence value; nested exception is org.hibernate.exception.SQLGrammarException: could not get next sequence value\
      at org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1467)\
      caused by: javax.servlet.ServletException: #{PrivateMessagesTool.processPvtMsgSettingsSave}: javax.faces.el.EvaluationException: org.springframework.dao.InvalidDataAccessResourceUsageException: could not get next sequence value; nested exception is org.hibernate.exception.SQLGrammarException: could not get next sequence value\
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)\
      caused by: javax.faces.FacesException: #{PrivateMessagesTool.processPvtMsgSettingsSave}: javax.faces.el.EvaluationException: org.springframework.dao.InvalidDataAccessResourceUsageException: could not get next sequence value; nested exception is org.hibernate.exception.SQLGrammarException: could not get next sequence value\
      at javax.faces.component.UICommand.broadcast(UICommand.java:332)\
      caused by: javax.faces.el.EvaluationException: org.springframework.dao.InvalidDataAccessResourceUsageException: could not get next sequence value; nested exception is org.hibernate.exception.SQLGrammarException: could not get next sequence value\
      at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:92)\
      caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not get next sequence value; nested exception is org.hibernate.exception.SQLGrammarException: could not get next sequence value\
      at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)\
      caused by: org.hibernate.exception.SQLGrammarException: could not get next sequence value\
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)\
      caused by: java.sql.SQLException: ORA-02289: sequence does not exist\
      \

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  baholladay Bryan Holladay
                  Reporter:
                  arwhyte Anthony Whyte
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration