Kuali Rice Development
  1. Kuali Rice Development
  2. KULRICE-8404

KR-SAP namespace is in the server bootstrap master dataset

    Details

    • Type: Bug Fix Bug Fix
    • Status: Closed Closed
    • Priority: Critical Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.1.2
    • Component/s: Database
    • Security Level: Public (Public: Anyone can view)
    • Labels:
      None
    • Similar issues:
      KULRICE-7427Provide "cleaned" master Rice dataset for client applications
      KULRICE-9000guest principal and entity were stripped from the server bootstrap dataset
      KULRICE-4126Update demo and bootstrap dataset cleanup for the 1.0.2 release
      KULRICE-11623Implement additive dataset database structure
      KULRICE-3413Add dataset packaging to the Rice packaging scripts
      KULRICE-7410Rice Upgrade scripts should not have "demo" or sample data or tables
      KULRICE-12382Peopleflow Summery Type KR-SAP Sample Type utilizes deleted Travel Fiscal Officer Id
      KULRICE-4333Typo in the Rice Server and binary distribution of impex-build.properties.sample
      KULRICE-12892Dataset Cleanup: Move TRV_ATT_SAMPLE and TRV_MULTI_ATT_SAMPLE to correct dataset
      KULRICE-10997Analysis: Improve cleanup scripts so that all sample data is removed from bootstrap datasets
    • Application Requirement:
      KFS
    • KAI Review Status:
      Not Required
    • KTI Review Status:
      Not Required

      Description

      After loading the Rice impex data via Maven (in rice\db\impex\server\bootstrap dir), I noticed that the KR-SAP (Sample App) namespace was still in the krcr_nmspc_t table. I needed to manually delete it before exporting the data to pull into KFS. This record shouldn't be in the bootstrap data.

        Issue Links

          Activity

          Hide
          Shannon Hess added a comment -

          Assigning this to myself since I have the other DB issues. Feel free to re-assign if I shouldn't have it.

          Show
          Shannon Hess added a comment - Assigning this to myself since I have the other DB issues. Feel free to re-assign if I shouldn't have it.
          Hide
          Shannon Hess added a comment -

          Bryan,
          When we talked yesterday you mentioned how you were updating your server database but it has already slipped my mind. Could you remind me again?

          Thanks,
          Shannon

          The following SQL is in bootstrap-server-dataset-cleanup.sql

          DELETE FROM krcr_nmspc_t WHERE nm IN ( 'KR-RULE-TEST', 'KR-SAP' )
          /
          

          bootstrap-server-dataset-cleanup.sql is then called in target dist-server-datasets in build.xml, which I'm not sure is used anymore.

          <echo>Running the bootstrap dataset cleanup against the RICEPACKAGING database.</echo>
          
          <ant dir="${impex.home.directory}" inheritall="false">
            <property name="import.torque.database.password" value="${dist.database.password}"/>
            <property name="post.import.script.files" value="${basedir}/scripts/dataset/bootstrap-server-dataset-cleanup.sql"/>
            <property file="scripts/dataset/server-dataset-impex-build.properties"/>
            <target name="inittasks"/>
            <target name="post-import-sql"/>
          </ant>
          

          dist-server --> dist-database --> dist-server-datasets

          Show
          Shannon Hess added a comment - Bryan, When we talked yesterday you mentioned how you were updating your server database but it has already slipped my mind. Could you remind me again? Thanks, Shannon The following SQL is in bootstrap-server-dataset-cleanup.sql DELETE FROM krcr_nmspc_t WHERE nm IN ( 'KR-RULE-TEST', 'KR-SAP' ) / bootstrap-server-dataset-cleanup.sql is then called in target dist-server-datasets in build.xml, which I'm not sure is used anymore. <echo>Running the bootstrap dataset cleanup against the RICEPACKAGING database.</echo> <ant dir= "${impex.home.directory}" inheritall= " false " > <property name= " import .torque.database.password" value= "${dist.database.password}" /> <property name= "post. import .script.files" value= "${basedir}/scripts/dataset/bootstrap-server-dataset-cleanup.sql" /> <property file= "scripts/dataset/server-dataset-impex-build.properties" /> <target name= "inittasks" /> <target name= "post- import -sql" /> </ant> dist-server --> dist-database --> dist-server-datasets
          Hide
          Shannon Hess added a comment -

          The KR-SAP namespce is in https://svn.kuali.org/repos/rice/sandbox/branches/rice-2.1-kfs\db\impex\server\bootstrap\src\main\resources\KRCR_NMSPC_T.xml,

          Peter, what is the process to remove it only from the server KRCR_NMSPC_T.xml file and not the demo and master databases files?

          Thanks,
          Shannon

          Show
          Shannon Hess added a comment - The KR-SAP namespce is in https://svn.kuali.org/repos/rice/sandbox/branches/rice-2.1-kfs\db\impex\server\bootstrap\src\main\resources\KRCR_NMSPC_T.xml , Peter, what is the process to remove it only from the server KRCR_NMSPC_T.xml file and not the demo and master databases files? Thanks, Shannon
          Hide
          Peter Giles (Inactive) added a comment - - edited

          Hi Shannon, Since it should be in the master database, but just not in the server dataset, we'll need to modify the scripts that strip out the demo data to cover that namespace as well. The scripts that do this type of work live in db/sql/src/main/resources under the rice project, and I believe that the one you'll want to modify is "bootstrap-server-dataset-cleanup.sql". Thanks, Peter

          Show
          Peter Giles (Inactive) added a comment - - edited Hi Shannon, Since it should be in the master database, but just not in the server dataset, we'll need to modify the scripts that strip out the demo data to cover that namespace as well. The scripts that do this type of work live in db/sql/src/main/resources under the rice project, and I believe that the one you'll want to modify is "bootstrap-server-dataset-cleanup.sql". Thanks, Peter
          Hide
          Shannon Hess added a comment -

          Bryan,

          After Peter's comment I realized that the SQL to delete the namespaces in bootstrap-server-dataset-cleanup.sql was not correct. I have changed it to the following so that should fix this issue.

          DELETE FROM krcr_nmspc_t WHERE NMSPC_CD IN ( 'KR-RULE-TEST', 'KR-SAP' )
          /
          

          Thanks,
          Shannon

          Show
          Shannon Hess added a comment - Bryan, After Peter's comment I realized that the SQL to delete the namespaces in bootstrap-server-dataset-cleanup.sql was not correct. I have changed it to the following so that should fix this issue. DELETE FROM krcr_nmspc_t WHERE NMSPC_CD IN ( 'KR-RULE-TEST', 'KR-SAP' ) / Thanks, Shannon
          Hide
          Bryan Hutchinson added a comment -

          Shannon,

          Ok, that makes sense. We had a similar cleanup script on the KFS side and I had to make the same change there, sorry I didn't think of that earlier. In case this is still helpful info, what I was doing to update the Rice data in KFS was:

          1) Loading the Rice Impex Data via Maven into a local Oracle XE schema. I mostly followed the directions on this confluence page: https://wiki.kuali.org/x/vSqREg, except I ran in server/bootstrap rather than master.
          2) Then I exported the data via the KFS ant export target

          I can certainly provide more details (exact commands, properties, etc.) if you're interested.

          Thanks,
          Bryan

          Show
          Bryan Hutchinson added a comment - Shannon, Ok, that makes sense. We had a similar cleanup script on the KFS side and I had to make the same change there, sorry I didn't think of that earlier. In case this is still helpful info, what I was doing to update the Rice data in KFS was: 1) Loading the Rice Impex Data via Maven into a local Oracle XE schema. I mostly followed the directions on this confluence page: https://wiki.kuali.org/x/vSqREg , except I ran in server/bootstrap rather than master. 2) Then I exported the data via the KFS ant export target I can certainly provide more details (exact commands, properties, etc.) if you're interested. Thanks, Bryan
          Hide
          Shannon Hess added a comment -

          Bryan,

          Thanks for the details. It definitely sounds like the fix to the sql should correct the problem you were seeing. If that's not the case after your next impex data load feel free to re-open this issue.

          Thanks,
          Shannon

          Show
          Shannon Hess added a comment - Bryan, Thanks for the details. It definitely sounds like the fix to the sql should correct the problem you were seeing. If that's not the case after your next impex data load feel free to re-open this issue. Thanks, Shannon
          Hide
          Jessica Coltrin (Inactive) added a comment -

          closing all 2.1.2 Jiras

          Show
          Jessica Coltrin (Inactive) added a comment - closing all 2.1.2 Jiras

            People

            • Assignee:
              Shannon Hess
              Reporter:
              Bryan Hutchinson
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Structure Helper Panel