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

Missing semi-colon in Oracle script prevents startup

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 19.0, 20.0 [Tentative]
    • Fix Version/s: 19.0, 20.0 [Tentative]
    • Component/s: Kernel
    • Labels:
      None
    • 19 status:
      Resolved
    • Test Plan:
      Hide

      Ensure Oracle 19 or 20 instance is running after fix is applied

      Show
      Ensure Oracle 19 or 20 instance is running after fix is applied

      Description

      The script committed in SAK-40967 was missing a semi-colon in the Oracle SQL so it's failing startup. 

       I also made a commit direct to the conversion on https://github.com/sakaiproject/sakai-reference/pull/41

      16-Jan-2019 00:33:25.266 WARN [main] org.sakaiproject.db.impl.BasicSqlService.dbWriteCount Sql.dbWrite(): error code: 933 sql: INSERT INTO SAKAI_REALM_RL_FN VALUES((select REALM_KEY from SAKAI_REALM where REALM_ID = '!site.template.course'), (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = 'Instructor'), (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = 'rubrics.evaluee')) INSERT INTO SAKAI_REALM_RL_FN VALUES((select REALM_KEY from SAKAI_REALM where REALM_ID = '!site.template.course'), (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = 'Instructor'), (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = 'rwiki.admin')) binds: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  jonespm Matthew Jones
                  Reporter:
                  jonespm Matthew Jones
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code