Details

    • Type: Bug Fix Bug Fix
    • Status: Closed Closed
    • Priority: Blocker Blocker
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.9.3
    • Component/s: Development
    • Labels:
      None
    • Similar issues:
      KULRICE-1468Errors when bootstrapping DDL into fresh and empty schema
      KULRICE-991Add KIM DDL to rice_db_bootstrap.sql
      KULRICE-2169KR_QRTZ_PAUSED_TRIGGER_GRPS.table.ddl contains wrong table name
      KULRICE-1940Post 0.9.3 JPA Merge Cleanup Tasks
      KULRICE-1202Write a test to verify our rice_db_bootstrap.sql and db_destroy.sql scripts work
      KULRICE-2179Verify if EN_RTE_NODE_T.CONTENT_FRAGMENT is used anywhere and remove it if it is not
      KULRICE-1588Merge 0.9.1.3 into 0.9.3
      KULRICE-1557Merge 0.9.3 JPA branch into 0.9.3
      KULRICE-1641Merge 0.9.3-kra into 0.9.3
      KULRICE-1558Merge 0.9.2 into 0.9.3
    • Rice Module:
      Rice Core, KSB, KNS, KEW, KEN, KIM, KOM
    • Application Requirement:
      Rice

      Description

      From Bob...

      I just finished spending 90 minutes or so finding all the places that need to be updated so that the dball script generates a usable bootstrap SQL file. Lacking commit access, I can't make the changes myself.

      Here are the required changes (I'll trust you can locate the files using Eclipse so I won't specify the entire path):

      – The following files need to be updated so that the command terminator does not have any spaces following it: EN_DOC_HDR_EXT_LONG_T.index.ddl, FS_CODES_DESC_T.table.ddl, FS_LOOKUP_SELECTIONS_MT.table.ddl

      – The following files need to be updated so that the command terminator does not have any spaces preceding it: EN_DOC_HDR_T.index.ddl, EN_USR_T.index.ddl

      – The following file needs the duplicate terminator removed: KIM_PERSON_QUALIFIED_ROLE_T.constraints.ddl

      (NOTE: If we were using the Oracle standard command terminator (";") none of the above would have been a problem.)

      The following changes need to be made to rice_data.sql:

      – The insert into KIM_PERSONS_T needs to be removed since the columns USERNAME and PASSWORD no longer appear in the table (this insert also appears in several other files which don't seem to be used by the dball script)

      – The insert of document group KR into FP_DOC_GROUP_T needs to be moved from the rice_sample_app.sql file into this file

      – A blank line needs to be added to the end of the file so that the next file is added correctly (right now, we end up with a line starting with "/CREATE")

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            Aaron Godert (Inactive)
            Reporter:
            Aaron Godert (Inactive)
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Due:
              Created:
              Updated:
              Resolved:

              Time Tracking

              Estimated:
              Original Estimate - Not Specified
              Not Specified
              Remaining:
              Time Spent - 1 hour, 15 minutes Remaining Estimate - 15 minutes
              15m
              Logged:
              Time Spent - 1 hour, 15 minutes Remaining Estimate - 15 minutes
              1h 15m

                Structure Helper Panel