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?