• Type: Bug Fix Bug Fix
    • Status: Closed Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 0.9.3
    • Fix Version/s: 0.9.3
    • Component/s: Database
    • Labels:
    • Similar issues:
      KULRICE-1547rice_db_bootstrap.sql problems on 0.9.3
      KULRICE-6930Invalid javascript in jscalendar language files
      KULRICE-7031Create javascript constants file
      KULRICE-12843AFT Failure LabsSubCollectionAddLineAft incident report Invalid property addViaLightBox
      KULRICE-3699Lingering keystore.location properties are causing projects created with createproject.groovy to have invalid property values
      KULRICE-12755Create Demo for file upload collections
      KULRICE-7327Fix invalid XML in spring files due to monitoring maven config
      KULRICE-7203Go through KRAD script files and create constants
      KULRICE-4525Create 1.0.3 download file
      KULRICE-2169KR_QRTZ_PAUSED_TRIGGER_GRPS.table.ddl contains wrong table name


      Bob Allison noted some problems with create the bootstrap.sql file:

      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")


        There are no comments yet on this issue.


          • Assignee:
            George Lindholm (Inactive)
            George Lindholm (Inactive)
          • Votes:
            0 Vote for this issue
            0 Start watching this issue


            • Created:

              Structure Helper Panel