Re: [Dspace-tech] Upgrading form DSpace 1.3.2 to 1.6
hello, i tried to upgrade the database step by step(for upgrading my DSpace form 1.3.2 to 1.7.0) using the scripts in the dspace-1.7.0-release/dspace/etc/postgres/ i issue the command: psql -f database_schema_13-14.sql dspace -h localhost -U dspace and i got errors... please help...below is my output psql:database_schema_13-14.sql:59: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index group2group_pkey for table group2group psql:database_schema_13-14.sql:59: ERROR: permission denied for relation epersongroup psql:database_schema_13-14.sql:75: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index group2groupcache_pkey for table group2groupcache psql:database_schema_13-14.sql:75: ERROR: permission denied for relation epersongroup psql:database_schema_13-14.sql:91: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index metadataschemaregistry_pkey for table metadataschemaregistry psql:database_schema_13-14.sql:91: NOTICE: CREATE TABLE / UNIQUE will create implicit index metadataschemaregistry_namespace_key for table metadataschemaregistry psql:database_schema_13-14.sql:101: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index metadatafieldregistry_pkey for table metadatafieldregistry psql:database_schema_13-14.sql:112: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index metadatavalue_pkey for table metadatavalue psql:database_schema_13-14.sql:112: ERROR: permission denied for relation item psql:database_schema_13-14.sql:115: ERROR: relation metadatavalue does not exist psql:database_schema_13-14.sql:116: ERROR: relation metadatavalue does not exist psql:database_schema_13-14.sql:126: ERROR: permission denied for relation dctyperegistry psql:database_schema_13-14.sql:130: ERROR: relation metadatavalue does not exist LINE 1: INSERT INTO MetadataValue (item_id, metadata_field_id, text_... ^ psql:database_schema_13-14.sql:132: ERROR: must be owner of relation dcvalue psql:database_schema_13-14.sql:139: ERROR: relation metadatavalue does not exist LINE 5: FROM MetadataValue, MetadataFieldRegistry ^ psql:database_schema_13-14.sql:142: ERROR: relation metadatavalue does not exist LINE 1: ...'metadatavalue_seq', max(metadata_value_id)) FROM metadatava... ^ psql:database_schema_13-14.sql:145: ERROR: must be owner of relation dctyperegistry psql:database_schema_13-14.sql:151: ERROR: must be owner of relation bitstream psql:database_schema_13-14.sql:152: ERROR: column size_bytes of relation bitstream does not exist LINE 1: UPDATE bitstream SET size_bytes = size; ^ psql:database_schema_13-14.sql:153: ERROR: must be owner of relation bitstream psql:database_schema_13-14.sql:165: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index checksum_results_pkey for table checksum_results psql:database_schema_13-14.sql:185: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index most_recent_checksum_pkey for table most_recent_checksum psql:database_schema_13-14.sql:185: ERROR: permission denied for relation bitstream psql:database_schema_13-14.sql:200: NOTICE: CREATE TABLE will create implicit sequence checksum_history_check_id_seq for serial column checksum_history.check_id psql:database_schema_13-14.sql:200: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index checksum_history_pkey for table checksum_history psql:database_schema_13-14.sql:291: ERROR: relation most_recent_checksum does not exist LINE 1: insert into most_recent_checksum ^ psql:database_schema_13-14.sql:302: ERROR: relation most_recent_checksum does not exist LINE 1: update most_recent_checksum ^ psql:database_schema_13-14.sql:322: ERROR: relation most_recent_checksum does not exist LINE 14: from most_recent_checksum; ^ psql:database_schema_13-14.sql:336: ERROR: must be owner of relation community psql:database_schema_13-14.sql:353: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index itemsbysubject_pkey for table itemsbysubject psql:database_schema_13-14.sql:353: ERROR: permission denied for relation item psql:database_schema_13-14.sql:356: ERROR: relation itemsbysubject does not exist psql:database_schema_13-14.sql:365: ERROR: relation itemsbysubject does not exist LINE 3: FROM ItemsBySubject, Collection2Item ^ psql:database_schema_13-14.sql:374: ERROR: relation itemsbysubject does not exist LINE 3: FROM ItemsBySubject, Communities2Item *Thanks Regards,* * * *Nikhil George * *Net-X Technologies* Cochin, Kerela, India On Tue, Apr 19, 2011 at 10:41 PM, Jimmy Ghaphery jghap...@vcu.edu wrote: If you are working with two servers, production (1.4) and future-production (1.7), would it be possible or advisable to 1. Copy 1.4 to the future-production server, and go through the full upgrade steps until there is a working copy of 1.6 or 1.7 2. Before switching to
[Dspace-tech] index init
Hi Everybody After I did mvn -U clean Pakage and ant update for dspace .cfg inputform.xml I just run index init but this error comes Anybody helps me Exception: Unknown format version: -9 org.apache.lucene.index.CorruptIndexException: Unknown format version: -9 at org.apache.lucene.index.SegmentInfos.read(SegmentInfos.java:211) at org.apache.lucene.index.IndexFileDeleter.init(IndexFileDeleter.java:16 8) at org.apache.lucene.index.IndexWriter.init(IndexWriter.java:722) at org.apache.lucene.index.IndexWriter.init(IndexWriter.java:452) at org.dspace.search.DSIndexer.openIndex(DSIndexer.java:781) at org.dspace.search.DSIndexer.createIndex(DSIndexer.java:425) at org.dspace.search.DSIndexer.main(DSIndexer.java:539) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:212) swebshet@ilrivm2:~$ sudo /home/dspace/bin/dspace index-update swebshet@ilrivm2:~$ sudo /home/dspace/bin/dspace index-init Exception: Unknown format version: -9 org.apache.lucene.index.CorruptIndexException: Unknown format version: -9 at org.apache.lucene.index.SegmentInfos.read(SegmentInfos.java:211) at org.apache.lucene.index.IndexFileDeleter.init(IndexFileDeleter.java:16 8) at org.apache.lucene.index.IndexWriter.init(IndexWriter.java:722) at org.apache.lucene.index.IndexWriter.init(IndexWriter.java:452) at org.dspace.search.DSIndexer.openIndex(DSIndexer.java:781) at org.dspace.search.DSIndexer.createIndex(DSIndexer.java:425) at org.dspace.search.DSIndexer.main(DSIndexer.java:539) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:212) swebshet@ilrivm2:~$ sudo /home/dspace/bin/dspace index-init -v Exception: Unknown format version: -9 org.apache.lucene.index.CorruptIndexException: Unknown format version: -9 at org.apache.lucene.index.SegmentInfos.read(SegmentInfos.java:211) at org.apache.lucene.index.IndexFileDeleter.init(IndexFileDeleter.java:16 8) at org.apache.lucene.index.IndexWriter.init(IndexWriter.java:722) at org.apache.lucene.index.IndexWriter.init(IndexWriter.java:452) at org.dspace.search.DSIndexer.openIndex(DSIndexer.java:781) at org.dspace.search.DSIndexer.createIndex(DSIndexer.java:425) at org.dspace.search.DSIndexer.main(DSIndexer.java:539) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:212) * -- Fulfilling the Lean Software Promise Lean software platforms are now widely adopted and the benefits have been demonstrated beyond question. Learn why your peers are replacing JEE containers with lightweight application servers - and what you can gain from the move. http://p.sf.net/sfu/vmware-sfemails ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Upgrading form DSpace 1.3.2 to 1.6
On Mon, Apr 25, 2011 at 01:59:05PM +0530, Nikhil George wrote: psql:database_schema_13-14.sql:59: ERROR: permission denied for relation epersongroup It looks as though database user 'dspace' doesn't own or have permission to alter the objects in that database. The first thing I'd do is use 'psql -l' to see what DB user owns the database itself. -- Mark H. Wood, Lead System Programmer mw...@iupui.edu Asking whether markets are efficient is like asking whether people are smart. pgplvfnyaOa2d.pgp Description: PGP signature -- Fulfilling the Lean Software Promise Lean software platforms are now widely adopted and the benefits have been demonstrated beyond question. Learn why your peers are replacing JEE containers with lightweight application servers - and what you can gain from the move. http://p.sf.net/sfu/vmware-sfemails___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Missing search this community/recent submissions
Hello, We are testing 1.7.1 and have noticed the following are missing from our sub-community collection pages: The Search within this community and its collections section. The Recent Submissions Our dspace.cfg is configured appropriately to display recent submissions. Any help understanding this issue would be helpful since we will not proceed to upgrade our production server until we figure this out. Richard Jizba Health Sciences Library Creighton University (402) 280-5142 rji...@creighton.ed -- WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Missing search this community/recent submissions
Richard, Reposting my response in the list for posterity. You will want to review that your xmlui.xconf looks similar to the following, having ArtifactBrowser disabled and the individual aspects for Browse, Search and Display enabled. aspects !-- @deprecated: the Artifact Browser has been devided into ViewArtifacts, BrowseArtifacts, SearchArtifacts aspect name=Artifact Browser path=resource://aspects/ArtifactBrowser/ / -- aspect name=Displaying Artifacts path=resource://aspects/ViewArtifacts/ / aspect name=Browsing Artifacts path=resource://aspects/BrowseArtifacts/ / aspect name=Searching Artifacts path=resource://aspects/SearchArtifacts/ / aspect name=Administration path=resource://aspects/Administrative/ / aspect name=E-Person path=resource://aspects/EPerson/ / aspect name=Submission and Workflow path=resource://aspects/Submission/ / aspect name=Statistics path=resource://aspects/Statistics/ / !-- To enable Discovery, uncomment this Aspect that will enable it within your existing XMLUI Also make sure to comment the SearchArtifacts aspect as leaving it on together with discovery will cause UI overlap issues aspect name=Discovery path=resource://aspects/Discovery/ / -- !-- This aspect tests the various possible DRI features, it helps a theme developer create themes -- !-- aspect name=XML Tests path=resource://aspects/XMLTest// -- /aspects Best, Mark On Apr 25, 2011, at 11:17 AM, Jizba, Richard wrote: Hello, We are testing 1.7.1 and have noticed the following are missing from our sub-community collection pages: The “Search within this community and its collections” section. The “Recent Submissions” Our dspace.cfg is configured appropriately to display recent submissions. Any help understanding this issue would be helpful since we will not proceed to upgrade our production server until we figure this out. Richard Jizba Health Sciences Library Creighton University (402) 280-5142 rji...@creighton.ed -- WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech -- Mark R. Diggory @mire - www.atmire.com 2888 Loker Avenue East - Suite 305 - Carlsbad - CA - 92010 Technologielaan 9 - 3001 Heverlee - Belgium -- WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Missing search this community/recent submissions
Hi Richard, I'm wondering if you're encountering some complications with caching and recent submissions (amoung others) -- https://jira.duraspace.org/browse/DS-871 (I'll post my works-well-enough-for-me resolution for caching to Jira). https://jira.duraspace.org/browse/DS-871 Peter Dietz On Mon, Apr 25, 2011 at 2:42 PM, Mark Diggory mdigg...@atmire.com wrote: Richard, Reposting my response in the list for posterity. You will want to review that your xmlui.xconf looks similar to the following, having ArtifactBrowser disabled and the individual aspects for Browse, Search and Display enabled. aspects !-- @deprecated: the Artifact Browser has been devided into ViewArtifacts, BrowseArtifacts, SearchArtifacts aspect name=Artifact Browser path=resource://aspects/ArtifactBrowser/ / -- aspect name=Displaying Artifacts path=resource://aspects/ViewArtifacts/ / aspect name=Browsing Artifacts path=resource://aspects/BrowseArtifacts/ / aspect name=Searching Artifacts path=resource://aspects/SearchArtifacts/ / aspect name=Administration path=resource://aspects/Administrative/ / aspect name=E-Person path=resource://aspects/EPerson/ / aspect name=Submission and Workflow path=resource://aspects/Submission/ / aspect name=Statistics path=resource://aspects/Statistics/ / !-- To enable Discovery, uncomment this Aspect that will enable it within your existing XMLUI Also make sure to comment the SearchArtifacts aspect as leaving it on together with discovery will cause UI overlap issues aspect name=Discovery path=resource://aspects/Discovery/ / -- !-- This aspect tests the various possible DRI features, it helps a theme developer create themes -- !-- aspect name=XML Tests path=resource://aspects/XMLTest// -- /aspects Best, Mark On Apr 25, 2011, at 11:17 AM, Jizba, Richard wrote: Hello, We are testing 1.7.1 and have noticed the following are missing from our sub-community collection pages: The “Search within this community and its collections” section. The “Recent Submissions” Our dspace.cfg is configured appropriately to display recent submissions. Any help understanding this issue would be helpful since we will not proceed to upgrade our production server until we figure this out. *Richard Jizba* Health Sciences Library Creighton University (402) 280-5142 rji...@creighton.ed -- WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech -- Mark R. Diggory @mire - www.atmire.com 2888 Loker Avenue East - Suite 305 - Carlsbad - CA - 92010 Technologielaan 9 - 3001 Heverlee - Belgium -- WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech -- WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech