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

Three 2.6.0 Conversion script problems

    Details

    • Type: Task
    • Status: CLOSED
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.6.0
    • Fix Version/s: 2.6.0
    • Component/s: Install/Upgrade
    • Labels:
      None

      Description

      There's 3 errors in the 2.6.0 conversion script. 2 SAK's have been already merged into 2.5.2 but were not added to a previous conversion script or missed in the merge. One of them is an error. I'm bundling them all together in one request.

      NOTE: This jira is oracle specific, see the SAK's for the mysql lines/files to modify (they should be similar)
      1) In SAK-15040, site.viewRoster function was added. This was added a long time ago (by SAK-2084) remove this line from the file, it's not needed.
      INSERT INTO SAKAI_REALM_FUNCTION VALUES (SAKAI_REALM_FUNCTION_SEQ.NEXTVAL, 'site.viewRoster');

      2) SAK-12016 and SAK-13345 are already merged into 2.5.2. If you run auto.ddl or have a new instance the associated sql is executed. The following lines should be removed from the 2.6.0 conversion script and added to a 2.5.5 conversion script.

      – OSP SAK-12016
      INSERT INTO SAKAI_REALM_RL_FN VALUES((select REALM_KEY from SAKAI_REALM where REALM_ID = '!group.template.portfolio'), (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = 'CIG Coordinator'), (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = 'content.all.groups'));
      INSERT INTO SAKAI_REALM_RL_FN VALUES((select REALM_KEY from SAKAI_REALM where REALM_ID = '!group.template.portfolio'), (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = 'CIG Coordinator'), (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = 'content.hidden'));
      INSERT INTO SAKAI_REALM_RL_FN VALUES((select REALM_KEY from SAKAI_REALM where REALM_ID = '!site.template.portfolio'), (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = 'CIG Coordinator'), (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = 'content.all.groups'));
      INSERT INTO SAKAI_REALM_RL_FN VALUES((select REALM_KEY from SAKAI_REALM where REALM_ID = '!site.template.portfolio'), (select ROLE_KEY from SAKAI_REALM_ROLE where ROLE_NAME = 'CIG Coordinator'), (select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = 'content.hidden'));

      SAK-13345
      create index ISEARCHBUILDERITEM_STA_ACT on searchbuilderitem (SEARCHSTATE,SEARCHACTION);

      3) The ISEARCHBUILDERITEM_STA made it in at 46546 (2.5.1) and was removed at 48240 (2.5.2) so people running auto.ddl won't even see it in 2.5.5 might as well just let it fail. Move it out of the 2.6.0 into the 2.5.5 with a note
      --SAK-13345
      – This might not exist if you started running sakai at 2.5.2+
      drop index ISEARCHBUILDERITEM_STA;

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

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

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code