Uploaded image for project: 'DSpace'
  1. DSpace
  2. DS-2678

DSpace on Oracle 11g

    XMLWordPrintable

    Details

    • Attachments:
      0
    • Comments:
      2
    • Documentation Status:
      Needed

      Description

      I completed all the installation steps as per the manual. After complete setup I found that there are errors in Views e.g. CollectionItemsByDate, CollectionItemsByAuthor and more. All views depend on tables like ItemsbyAuthor, ItemsByTitle but it seems like they are dropped by FlyWay as per the following syntax.

      DROP TABLE ItemsByAuthor CASCADE CONSTRAINTS;
      DROP TABLE ItemsByTitle CASCADE CONSTRAINTS;
      DROP TABLE ItemsByDate CASCADE CONSTRAINTS;
      DROP TABLE ItemsByDateAccessioned CASCADE CONSTRAINTS;
      DROP TABLE ItemsBySubject CASCADE CONSTRAINTS;

      So giving error in views. Also find duplicate constraint issue in
      V1.6__Upgrade_to_DSpace_1.6_schema.sql as per the following statements,

      ALTER TABLE community2collection ADD CONSTRAINT comm2coll_collection_fk FOREIGN KEY (collection_id) REFERENCES collection DEFERRABLE;
      ALTER TABLE community2community ADD CONSTRAINT com2com_child_fk FOREIGN KEY (child_comm_id) REFERENCES community DEFERRABLE;
      ALTER TABLE collection2item ADD CONSTRAINT coll2item_item_fk FOREIGN KEY (item_id) REFERENCES item DEFERRABLE;

      So request you to fix it soon or do you have any other solution for the same?

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              jitesh_0149 Jitesh Jadav
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: