Uploaded image for project: 'Kuali Rice Development'
  1. Kuali Rice Development
  2. KULRICE-8404

KR-SAP namespace is in the server bootstrap master dataset

    Details

    • Type: Bug Fix
    • Status: Closed
    • Priority: 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
    • 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.

        Attachments

          Issue Links

            Activity

            Hide
            shahess 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
            shahess 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
            shahess 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
            shahess 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
            shahess 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
            shahess 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
            gilesp 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
            gilesp 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
            shahess 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
            shahess 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
            bhutchinson 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
            bhutchinson 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
            shahess 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
            shahess 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
            jcoltrin Jessica Coltrin (Inactive) added a comment -

            closing all 2.1.2 Jiras

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

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: