Re: [Dspace-tech] xmlui / creative commons / cert issue
What certificate would it be looking for here? I don't use any certificates in our Tomcat installation. I proxy using mod_ajp, so my only certs are in Apache. That's fine and I use the same setup successfully (though I don't use CC licenses). If you still wanted Tomcat to know about your keystore, I'm not sure you used the right procedure. The documented procedure (works for me, too) as per http://tomcat.apache.org/tomcat-5.5-doc/ssl-howto.html is to define the connector as follows: Connector port=8443 maxHttpHeaderSize=8192 maxThreads=150 minSpareThreads=25 maxSpareThreads=75 enableLookups=false disableUploadTimeout=true acceptCount=100 scheme=https secure=true clientAuth=false sslProtocol=TLS keystoreFile=keystore.p12 keystorePass= keystoreType=PKCS12 / Again, I don't know how this would help you since in your case Tomcat shouldn't care about certificates, but neither would your JAVA_OPTS approach. Which DSpace version are you using? I tried to look at the line mentioned in the error but in 1.8.0 that line doesn't have so many characters (or just paste the line here). Regards, ~~helix84 -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2 ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Making DSpace read only
Hello, Sorry for the lack of information previously, so buried in the issue that I forgot people wouldn't know! :) What we are after is to make our current DSpace (version 1.7.1 using Mirage) installation completely read-only, no submissions of new items and no edits of old. We've been told we need to migrate the data to a new system so need to baseline it for the export. I've only been using DSpace for a few months having inherited it for the upgrade to 1.7.1 so detailed instructions for a newby would be good if possible. ;) Many thanks to Matt for his response so far. kind regards, Claire On 02/02/2012 13:06, Henry, Matt - OPS District Computer Technician wrote: When you say read only do you mean that no one is able to submit or edit new items? Or do you mean that no one should be able to just edit items? I have never tried that before but if you want to just disallow submissions you can change permissions for anonymous and authenticated to deny 'add.' If you need to simply prevent the editing of items this can be done via group permissions as well. It would be helpful for people to know what version you are using, what environment you are in, and more detail on what you are trying to accomplish. Hope this helps! Matt Henry On 2/2/12 6:51 AM, Claire Websterclaire.webs...@bristol.ac.uk wrote: Hello, I need to make our DSpace installation read-only is there an easy way to do this, or instructions available? Any help very gratefully received. kind regards, Claire -- Claire Webster (nee Lumber) Developer, Library Systems University of Bristol Email: claire.webs...@bristol.ac.uk Tel: (0117) 331 6739 (internal: 16739) -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech -- Claire Webster (nee Lumber) Developer, Library Systems University of Bristol Email: claire.webs...@bristol.ac.uk Tel: (0117) 331 6739 (internal: 16739) -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2 ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Making DSpace read only
Hello Claire, you could set your underlying database to transaction read only. This would prevent any change on communities, collections, epeople, groups ... Anything would be viewable, but no new users, changed/new items etc. Note, this would prevent some of the cron jobs from working, too. Hope that helps Claudia Jürgen Am 03.02.2012 10:52, schrieb Claire Webster: Hello, Sorry for the lack of information previously, so buried in the issue that I forgot people wouldn't know! :) What we are after is to make our current DSpace (version 1.7.1 using Mirage) installation completely read-only, no submissions of new items and no edits of old. We've been told we need to migrate the data to a new system so need to baseline it for the export. I've only been using DSpace for a few months having inherited it for the upgrade to 1.7.1 so detailed instructions for a newby would be good if possible. ;) Many thanks to Matt for his response so far. kind regards, Claire On 02/02/2012 13:06, Henry, Matt - OPS District Computer Technician wrote: When you say read only do you mean that no one is able to submit or edit new items? Or do you mean that no one should be able to just edit items? I have never tried that before but if you want to just disallow submissions you can change permissions for anonymous and authenticated to deny 'add.' If you need to simply prevent the editing of items this can be done via group permissions as well. It would be helpful for people to know what version you are using, what environment you are in, and more detail on what you are trying to accomplish. Hope this helps! Matt Henry On 2/2/12 6:51 AM, Claire Websterclaire.webs...@bristol.ac.uk wrote: Hello, I need to make our DSpace installation read-only is there an easy way to do this, or instructions available? Any help very gratefully received. kind regards, Claire -- Claire Webster (nee Lumber) Developer, Library Systems University of Bristol Email: claire.webs...@bristol.ac.uk Tel: (0117) 331 6739 (internal: 16739) -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech -- Claudia Juergen Universitaetsbibliothek Dortmund Eldorado 0231/755-4043 https://eldorado.tu-dortmund.de/ -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2 ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Making DSpace read only
On Fri, Feb 3, 2012 at 10:52, Claire Webster claire.webs...@bristol.ac.uk wrote: What we are after is to make our current DSpace (version 1.7.1 using Mirage) installation completely read-only, no submissions of new items and no edits of old. We've been told we need to migrate the data to a new system so need to baseline it for the export. I wonder what would happen if you locked the database (removed write permissions from the dspace user). I doubt anyone has tried that and I'd expect to get unusual error emssages in the user interface, but it should have the inteded effect. Regards, ~~helix84 -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2 ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Help for extend/enhance solr statistics
Dear Dspace-tech community, in our institution, Universitat Pompeu Fabra (http://repositori.upf.edu/), we're using Dspace 1.7.1 (XMLUI). We want to modify/add more information in the statistics-home page (based on Solr). Particularly we want to add one section which shows all visits and downloads in the entire repository, not only the top 10 items as is shown now. We're trying to debug the Java code, and seems this information is difficult to show. If someone could tell us how do this... any help/trick/hint will be appreciated. Thanks in advance. Robert Ruiz -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2 ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] XMLUI Video Preview
Dear All I am looking for video preview module that I can use to play video files from video collection that we have, without users having to install video players on their machine, even if there is commercial one that you may be aware of please send it to me. I have tried http://blog.stuartlewis.com/2009/05/27/easy-pseudo-video-streaming-for-d space-repositories/ and is working fine but I want the one for jspui. Regards, Lewatle htmlpfont face = verdana size = 0.8 color = navyThis communication is intended for the addressee only. It is confidential. If you have received this communication in error, please notify us immediately and destroy the original message. You may not copy or disseminate this communication without the permission of the University. Only authorized signatories are competent to enter into agreements on behalf of the University and recipients are thus advised that the content of this message may not be legally binding on the University and may contain the personal views and opinions of the author, which are not necessarily the views and opinions of The University of the Witwatersrand, Johannesburg. All agreements between the University and outsiders are subject to South African Law unless the University agrees in writing to the contrary./font/p/html -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] discovery command error
Hello All, I m using dspace-1.8.1. For xmlui interface I want to unable Discovery feature. wen i m going to run this command it gives me error like this: D:\dspace-1.8\dspace-ins\bin*dspace update-discovery-index* Using DSpace installation in: D:\dspace-1.8\dspace-ins Exception: Error executing query org.dspace.discovery.SearchServiceException: Error executing query at org.dspace.discovery.SolrServiceImpl.cleanIndex(SolrServiceImpl.java: 375) at org.dspace.discovery.IndexClient.main(IndexClient.java:119) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:183) how do i solve this ? one more thing that Check that the port is correct for solr.search.server in config/* dspace-solr-search.cfg* 1. If all of your traffic runs over port 80, then you need to remove the port from the URL # Search Indexing #*solr.search.server = http://localhost/solr/search* there is one modification for dspace-1.7.0 version. i didnt find this file in dspace-1.8.1 n can any one tell that how do i make this change in dspace-1.8.1??? -- Thanks in advance Abhishek Raval Ph no.-+919601077584 -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] discovery command error
Hello All, I m using dspace-1.8.1. For xmlui interface I want to unable Discovery feature. wen i m going to run this command it gives me error like this: D:\dspace-1.8\dspace-ins\bin*dspace update-discovery-index* Using DSpace installation in: D:\dspace-1.8\dspace-ins Exception: Error executing query org.dspace.discovery.SearchServiceException: Error executing query at org.dspace.discovery.SolrServiceImpl.cleanIndex(SolrServiceImpl.java: 375) at org.dspace.discovery.IndexClient.main(IndexClient.java:119) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:183) how do i solve this ? one more thing that Check that the port is correct for solr.search.server in config/* dspace-solr-search.cfg* 1. If all of your traffic runs over port 80, then you need to remove the port from the URL # Search Indexing #*solr.search.server = http://localhost/solr/search* there is one modification for dspace-1.7.0 version. i didnt find this file in dspace-1.8.1 n can any one tell that how do i make this change in dspace-1.8.1??? -- Thanks in advance Abhishek Raval Ph no.-+919601077584 -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Hindi language search unable
Hello All In my dspace-1.7.2 i have lots of metadata in Hindi language. I want to unable search for hindi language so i can get my items with help of those hindi words. How do i do that ??? -- Thanks in advance Abhishek Raval Ph no.-+919601077584 -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] discovery command error
On Fri, Feb 3, 2012 at 14:02, Abhishek Raval abhis...@webinito.com wrote: I m using dspace-1.8.1. For xmlui interface I want to unable Discovery feature. wen i m going to run this command it gives me error like this: This issue was raised several times on this list. Did you just copy over your configuration from a pre-1.8 version? Because there have been significant changes - both to Discovery and to the config files which are now beign split up into [dspace]/config/modules/. I'd recommend you to start with fresh 1.8.1 configuration and transfer your changes one by one into the new files. If that alone doesn't help, try to look at the previous answers: http://www.mail-archive.com/find.php?cx=partner-pub-7266757337600734%3A2228981072cof=FORID%3A9ie=UTF-8q=%22SearchServiceException%3A+Error+executing+query%22sa=Search Check that the port is correct for solr.search.server in config/dspace-solr-search.cfg If all of your traffic runs over port 80, then you need to remove the port from the URL # Search Indexing # solr.search.server = http://localhost/solr/search In this case, the new config variable is located in [dspace]/config/modules/discovery.cfg and is called only search.server. Regards, ~~helix84 -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2 ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Hindi language search unable
On Fri, Feb 3, 2012 at 14:04, Abhishek Raval abhis...@webinito.com wrote: In my dspace-1.7.2 i have lots of metadata in Hindi language. I want to unable search for hindi language so i can get my items with help of those hindi words. How do i do that ??? You should be able to search in all metadata, regardless of its language. Did you check your index is created (index-init) or updated correctly (index-update)? If you're using Discovery, also update that index (update-discovery-index). Regards, ~~helix84 -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2 ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Hindi language search unable
Another thing that comes to mind if only the Hindi metadata is affected - Hindi uses a different script, which may not be encoded correctly when passed to DSpace, so check your UTF-8 configuration: https://wiki.duraspace.org/display/DSDOC18/Installation#Installation-ServletEngine%3A%28ApacheTomcat5.5or6%2CJetty%2CCauchoResinorequivalent%29. Regards, ~~helix84 -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2 ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1
Hi Claudia, I don't remember getting these errors when upgrading from 1.5 to 1.6, but we never really implemented 1.6 - I ran what I needed to run for database changes from 1.5 -- 1.6 -- 1.7 and implemented 1.7.1, so I may have missed it. So is this what you're saying I need to do? ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT community2collection_collection_id_fkey; Thanks a bunch, Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Thursday, February 02, 2012 3:31 AM To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, while updating to 1.6 did you get some errors like that: psql:database_schema_15-16.sql:105: ERROR: constraint community2collection_collection_id_fkey of relation community2collection does not exist ALTER TABLE psql:database_schema_15-16.sql:108: ERROR: constraint community2community_child_comm_id_fkey of relation community2community does not exist ALTER TABLE psql:database_schema_15-16.sql:111: ERROR: constraint collection2item_item_id_fkey of relation collection2item does not exist If so, inspect your database and use the references for the foreign keys to delete them, e.g:: psql [YourDBName] \d [TableName] will show you the foreign keys, e.g.: \d community2collection Table public.community2collection Column | Type | Modifiers ---+-+--- id| integer | not null community_id | integer | collection_id | integer | Indexes: community2collection_pkey PRIMARY KEY, btree (id) community2collection_collection_id_idx btree (collection_id) community2collection_community_id_idx btree (community_id) Foreign-key constraints: $1 FOREIGN KEY (community_id) REFERENCES community(community_id) $2 FOREIGN KEY (collection_id) REFERENCES collection(collection_id) In that case you got to run: ALTER TABLE collection2item DROP CONSTRAINT $2; ALTER TABLE community2community DROP CONSTRAINT $2; ALTER TABLE community2collection DROP CONSTRAINT $2; The reason for this is: In Step 7 Update the database it can happen that not all the commands in the database_schema_15-16.sql are executed properly. The commands to drop foreign keys: ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT community2collection_collection_id_fkey; assume that the keys got default names, whereas depending on the database version and operating system on which your instance started, they can have no names and just be counted internally. If you got no names or other names the script will skip the commands, with the above mentioned ERROR. This will lead to errors running DSpace as now 2 contraints exist and one is unable to delete items, collections etc. Hope that helps Claudia Jürgen Am 01.02.2012 20:46, schrieb Thornton, Susan M. (LARC-B702)[LITES]: Hello, After recently upgrading from DSpace 1.5.1 to 1.7.1, we are getting the following error whenever we try to delete an Item online: 2012-02-01 14:40:17,883 WARN org.dspace.app.webui.servlet.DSpaceServlet @ susan.m.thorn...@nasa.gov:session_id=B6C011F3369B678E2FB9ED4B0050:ip_addr=999.99.99.999:database_error:org.postgresql.util.PSQLException\colonmailto:susan.m.thorn...@nasa.gov:session_id=B6C011F3369B678E2FB9ED4B0050:ip_addr=999.99.99.999:database_error:org.postgresql.util.PSQLException\colon; ERROR\colon; update or delete on table item violates foreign key constraint $2 on table collection2item Detail\colon; Key (item_id)=(429349) is still referenced from table collection2item. org.postgresql.util.PSQLException: ERROR: update or delete on table item violates foreign key constraint $2 on table collection2item Detail: Key (item_id)=(429349) is still referenced from table collection2item. I found some old dspace-tech postings regarding this error and am wondering if the recommended fix is correct? Not sure how this one happened: after upgrading to dspace 1.6, we're having trouble deleting items from dspace. We get an error message explaining that 'update or delete on item violates foreign key constraint $2 on collection2item'. Describing collection2item yields: Table public.collection2item Column | Type | Modifiers ---+-+--- id| integer | not null collection_id | integer | item_id | integer | Indexes: collection2item_pkey
Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1
Hello Susan, no, in the case you ran into the below mentioned problem, you got to drop the nameless constraints, e.g.: ALTER TABLE collection2item DROP CONSTRAINT $2 The error you posted org.postgresql.util.PSQLException: ERROR: update or delete on table item violates foreign key constraint $2 on table collection2item Detail: Key (item_id)=(429349) is still referenced from table collection2item indicates that these constraints were not dropped. Hope that helps Claudia Jürgen Am 03.02.2012 15:52, schrieb Thornton, Susan M. (LARC-B702)[LITES]: Hi Claudia, I don't remember getting these errors when upgrading from 1.5 to 1.6, but we never really implemented 1.6 - I ran what I needed to run for database changes from 1.5 -- 1.6 -- 1.7 and implemented 1.7.1, so I may have missed it. So is this what you're saying I need to do? ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT community2collection_collection_id_fkey; Thanks a bunch, Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Thursday, February 02, 2012 3:31 AM To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, while updating to 1.6 did you get some errors like that: psql:database_schema_15-16.sql:105: ERROR: constraint community2collection_collection_id_fkey of relation community2collection does not exist ALTER TABLE psql:database_schema_15-16.sql:108: ERROR: constraint community2community_child_comm_id_fkey of relation community2community does not exist ALTER TABLE psql:database_schema_15-16.sql:111: ERROR: constraint collection2item_item_id_fkey of relation collection2item does not exist If so, inspect your database and use the references for the foreign keys to delete them, e.g:: psql [YourDBName] \d [TableName] will show you the foreign keys, e.g.: \d community2collection Table public.community2collection Column | Type | Modifiers ---+-+--- id| integer | not null community_id | integer | collection_id | integer | Indexes: community2collection_pkey PRIMARY KEY, btree (id) community2collection_collection_id_idx btree (collection_id) community2collection_community_id_idx btree (community_id) Foreign-key constraints: $1 FOREIGN KEY (community_id) REFERENCES community(community_id) $2 FOREIGN KEY (collection_id) REFERENCES collection(collection_id) In that case you got to run: ALTER TABLE collection2item DROP CONSTRAINT $2; ALTER TABLE community2community DROP CONSTRAINT $2; ALTER TABLE community2collection DROP CONSTRAINT $2; The reason for this is: In Step 7 Update the database it can happen that not all the commands in the database_schema_15-16.sql are executed properly. The commands to drop foreign keys: ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT community2collection_collection_id_fkey; assume that the keys got default names, whereas depending on the database version and operating system on which your instance started, they can have no names and just be counted internally. If you got no names or other names the script will skip the commands, with the above mentioned ERROR. This will lead to errors running DSpace as now 2 contraints exist and one is unable to delete items, collections etc. Hope that helps Claudia Jürgen Am 01.02.2012 20:46, schrieb Thornton, Susan M. (LARC-B702)[LITES]: Hello, After recently upgrading from DSpace 1.5.1 to 1.7.1, we are getting the following error whenever we try to delete an Item online: 2012-02-01 14:40:17,883 WARN org.dspace.app.webui.servlet.DSpaceServlet @ susan.m.thorn...@nasa.gov:session_id=B6C011F3369B678E2FB9ED4B0050:ip_addr=999.99.99.999:database_error:org.postgresql.util.PSQLException\colonmailto:susan.m.thorn...@nasa.gov:session_id=B6C011F3369B678E2FB9ED4B0050:ip_addr=999.99.99.999:database_error:org.postgresql.util.PSQLException\colon; ERROR\colon; update or delete on table item violates foreign key constraint $2 on table collection2item Detail\colon; Key (item_id)=(429349) is still referenced from table collection2item. org.postgresql.util.PSQLException: ERROR: update or delete on table item violates foreign key constraint $2 on table collection2item Detail: Key (item_id)=(429349) is still referenced from table collection2item. I found
[Dspace-tech] Multiple bitstreams while submitting a new item
Hi all, I am using DSpace 1.8.0. I notice that while submitting a new item, there is no functionality for uploading multiple files (bitstreams) at once. However, after uploading the file, at the page where you can edit its metadata (edit-item) from the admin ui, at the bottom of the page, the ability for adding/removing/ordering the bitstreams is present! So, I would like to ask: 1. Is there an “orthodox” way to enable multiple bitstream submission during the item submission process? (I did not see such an option in dspace.cfg, input-forms.xml, or item-submission.xml) 2. Are there any plans to include this functionality in future DSpace releases? 3. Although this seems like a trivial functionality (DSpace is after all an asset management system, so one would expect to find out-of-the-box support for multiple files per entry), is there a specific reason why this functionality is not present? Am I the only one with the need for this? 4. In case of 3 NO’s in the questions above, are there any guidelines for a custom implementation, without messing up much DSpace’s internal functionality? Thanks in advance, Nikolaos Konstantinou, PhD National Documentation Centre/NHRF-- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Docushare-to-DSpace interface
Hello, We have a Docushare instance in which we store open, active projects. Once the projects are complete, we export the files/documents from Docushare to DSpace for archival (we are currently running the JSPUI version of DSpace 1.7.1 on a Sun Solaris server with PostgreSQL). For some time now, we've had a very piecemeal process that accomplishes this and we would like to automate it. Of course, the objective is to create the directory structure that DSpace needs in order to import content into specified collections. I'd like to hear from anyone who's done this or something like it and what your ultimate solution was. Has anyone used SWORD for this and, if so, what kind of development effort was required? Any other solutions we might be able to implement in a fairly short period of time? I hesitate to just write an interface between Docushare and DSpace when it's entirely possible that we might want to migrate content from another source (not just Docushare) in the future. We also periodically receive new collections to import in the form of a disk of documents and a spreadsheet of metadata where we use a similar, somewhat piecemeal process to match documents to metadata and convert to the required DSpace import directory structure. Any helpful suggestions/solutions would be appreciated! Thanks and Best regards, Sue Sue Walker-Thornton Software Developer/Database Administrator NASA Langley Research Center - LITES Contract susan.m.thorn...@nasa.gov (W) 757-864-2368 (M) 757-506-9903 -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1
Thanks so much Claudia! This fixed our problem!! Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Friday, February 03, 2012 10:07 AM To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, no, in the case you ran into the below mentioned problem, you got to drop the nameless constraints, e.g.: ALTER TABLE collection2item DROP CONSTRAINT $2 The error you posted org.postgresql.util.PSQLException: ERROR: update or delete on table item violates foreign key constraint $2 on table collection2item Detail: Key (item_id)=(429349) is still referenced from table collection2item indicates that these constraints were not dropped. Hope that helps Claudia Jürgen Am 03.02.2012 15:52, schrieb Thornton, Susan M. (LARC-B702)[LITES]: Hi Claudia, I don't remember getting these errors when upgrading from 1.5 to 1.6, but we never really implemented 1.6 - I ran what I needed to run for database changes from 1.5 -- 1.6 -- 1.7 and implemented 1.7.1, so I may have missed it. So is this what you're saying I need to do? ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT community2collection_collection_id_fkey; Thanks a bunch, Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Thursday, February 02, 2012 3:31 AM To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, while updating to 1.6 did you get some errors like that: psql:database_schema_15-16.sql:105: ERROR: constraint community2collection_collection_id_fkey of relation community2collection does not exist ALTER TABLE psql:database_schema_15-16.sql:108: ERROR: constraint community2community_child_comm_id_fkey of relation community2community does not exist ALTER TABLE psql:database_schema_15-16.sql:111: ERROR: constraint collection2item_item_id_fkey of relation collection2item does not exist If so, inspect your database and use the references for the foreign keys to delete them, e.g:: psql [YourDBName] \d [TableName] will show you the foreign keys, e.g.: \d community2collection Table public.community2collection Column | Type | Modifiers ---+-+--- id| integer | not null community_id | integer | collection_id | integer | Indexes: community2collection_pkey PRIMARY KEY, btree (id) community2collection_collection_id_idx btree (collection_id) community2collection_community_id_idx btree (community_id) Foreign-key constraints: $1 FOREIGN KEY (community_id) REFERENCES community(community_id) $2 FOREIGN KEY (collection_id) REFERENCES collection(collection_id) In that case you got to run: ALTER TABLE collection2item DROP CONSTRAINT $2; ALTER TABLE community2community DROP CONSTRAINT $2; ALTER TABLE community2collection DROP CONSTRAINT $2; The reason for this is: In Step 7 Update the database it can happen that not all the commands in the database_schema_15-16.sql are executed properly. The commands to drop foreign keys: ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT community2collection_collection_id_fkey; assume that the keys got default names, whereas depending on the database version and operating system on which your instance started, they can have no names and just be counted internally. If you got no names or other names the script will skip the commands, with the above mentioned ERROR. This will lead to errors running DSpace as now 2 contraints exist and one is unable to delete items, collections etc. Hope that helps Claudia Jürgen Am 01.02.2012 20:46, schrieb Thornton, Susan M. (LARC-B702)[LITES]: Hello, After recently upgrading from DSpace 1.5.1 to 1.7.1, we are getting the following error whenever we try to delete an Item online: 2012-02-01 14:40:17,883 WARN org.dspace.app.webui.servlet.DSpaceServlet @ susan.m.thorn...@nasa.gov:session_id=B6C011F3369B678E2FB9ED4B0050:ip_addr=999.99.99.999:database_error:org.postgresql.util.PSQLException\colonmailto:susan.m.thorn...@nasa.gov:session_id=B6C011F3369B678E2FB9ED4B0050:ip_addr=999.99.99.999:database_error:org.postgresql.util.PSQLException\colon; ERROR\colon; update or delete on table item violates
Re: [Dspace-tech] Multiple bitstreams while submitting a new item
Hello Nikolaos, you can add multiple bitstreams to an item during the submission process. You only got to check the initial question: The item consists of more than one file during the submission process. Hope that helps Claudia Jürgen Hi all, I am using DSpace 1.8.0. I notice that while submitting a new item, there is no functionality for uploading multiple files (bitstreams) at once. However, after uploading the file, at the page where you can edit its metadata (edit-item) from the admin ui, at the bottom of the page, the ability for adding/removing/ordering the bitstreams is present! So, I would like to ask: 1. Is there an âorthodoxâ way to enable multiple bitstream submission during the item submission process? (I did not see such an option in dspace.cfg, input-forms.xml, or item-submission.xml) 2. Are there any plans to include this functionality in future DSpace releases? 3. Although this seems like a trivial functionality (DSpace is after all an asset management system, so one would expect to find out-of-the-box support for multiple files per entry), is there a specific reason why this functionality is not present? Am I the only one with the need for this? 4. In case of 3 NOâs in the questions above, are there any guidelines for a custom implementation, without messing up much DSpaceâs internal functionality? Thanks in advance, Nikolaos Konstantinou, PhD National Documentation Centre/NHRF-- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech Mit freundlichen Gruessen Claudia Juergen Universitaetsbibliothek Dortmund Eldorado 0231/755-4043 https://eldorado.tu-dortmund.de/ Tel.: 0049-231-755-4043 -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2 ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1
Hello Susan, to be precise, there shoul have been 3 constraints referenced as $n to be deleted in: collection2item community2community community2collection as mentioned in my first post. Claudia Thanks so much Claudia! This fixed our problem!! Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Friday, February 03, 2012 10:07 AM To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, no, in the case you ran into the below mentioned problem, you got to drop the nameless constraints, e.g.: ALTER TABLE collection2item DROP CONSTRAINT $2 The error you posted org.postgresql.util.PSQLException: ERROR: update or delete on table item violates foreign key constraint $2 on table collection2item Detail: Key (item_id)=(429349) is still referenced from table collection2item indicates that these constraints were not dropped. Hope that helps Claudia Jürgen Am 03.02.2012 15:52, schrieb Thornton, Susan M. (LARC-B702)[LITES]: Hi Claudia, I don't remember getting these errors when upgrading from 1.5 to 1.6, but we never really implemented 1.6 - I ran what I needed to run for database changes from 1.5 -- 1.6 -- 1.7 and implemented 1.7.1, so I may have missed it. So is this what you're saying I need to do? ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT community2collection_collection_id_fkey; Thanks a bunch, Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Thursday, February 02, 2012 3:31 AM To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, while updating to 1.6 did you get some errors like that: psql:database_schema_15-16.sql:105: ERROR: constraint community2collection_collection_id_fkey of relation community2collection does not exist ALTER TABLE psql:database_schema_15-16.sql:108: ERROR: constraint community2community_child_comm_id_fkey of relation community2community does not exist ALTER TABLE psql:database_schema_15-16.sql:111: ERROR: constraint collection2item_item_id_fkey of relation collection2item does not exist If so, inspect your database and use the references for the foreign keys to delete them, e.g:: psql [YourDBName] \d [TableName] will show you the foreign keys, e.g.: \d community2collection Table public.community2collection Column | Type | Modifiers ---+-+--- id| integer | not null community_id | integer | collection_id | integer | Indexes: community2collection_pkey PRIMARY KEY, btree (id) community2collection_collection_id_idx btree (collection_id) community2collection_community_id_idx btree (community_id) Foreign-key constraints: $1 FOREIGN KEY (community_id) REFERENCES community(community_id) $2 FOREIGN KEY (collection_id) REFERENCES collection(collection_id) In that case you got to run: ALTER TABLE collection2item DROP CONSTRAINT $2; ALTER TABLE community2community DROP CONSTRAINT $2; ALTER TABLE community2collection DROP CONSTRAINT $2; The reason for this is: In Step 7 Update the database it can happen that not all the commands in the database_schema_15-16.sql are executed properly. The commands to drop foreign keys: ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT community2collection_collection_id_fkey; assume that the keys got default names, whereas depending on the database version and operating system on which your instance started, they can have no names and just be counted internally. If you got no names or other names the script will skip the commands, with the above mentioned ERROR. This will lead to errors running DSpace as now 2 contraints exist and one is unable to delete items, collections etc. Hope that helps Claudia Jürgen Am 01.02.2012 20:46, schrieb Thornton, Susan M. (LARC-B702)[LITES]: Hello, After recently upgrading from DSpace 1.5.1 to 1.7.1, we are getting the following error whenever we try to delete an Item online: 2012-02-01 14:40:17,883 WARN org.dspace.app.webui.servlet.DSpaceServlet @
Re: [Dspace-tech] Docushare-to-DSpace interface
Hello Susan, you could use Sword (http://swordapp.org/) to deposit from Docushare to DSpace or OAI-ORE to harvest from Docushare, if Docushare supports it. Hope that helps Claudia Jürgen Hello, We have a Docushare instance in which we store open, active projects. Once the projects are complete, we export the files/documents from Docushare to DSpace for archival (we are currently running the JSPUI version of DSpace 1.7.1 on a Sun Solaris server with PostgreSQL). For some time now, we've had a very piecemeal process that accomplishes this and we would like to automate it. Of course, the objective is to create the directory structure that DSpace needs in order to import content into specified collections. I'd like to hear from anyone who's done this or something like it and what your ultimate solution was. Has anyone used SWORD for this and, if so, what kind of development effort was required? Any other solutions we might be able to implement in a fairly short period of time? I hesitate to just write an interface between Docushare and DSpace when it's entirely possible that we might want to migrate content from another source (not just Docushare) in the future. We also periodically receive new collections to import in the form of a disk of documents and a spreadsheet of metadata where we use a similar, somewhat piecemeal process to match documents to metadata and convert to the required DSpace import directory structure. Any helpful suggestions/solutions would be appreciated! Thanks and Best regards, Sue Sue Walker-Thornton Software Developer/Database Administrator NASA Langley Research Center - LITES Contract susan.m.thorn...@nasa.gov (W) 757-864-2368 (M) 757-506-9903 -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech Mit freundlichen Gruessen Claudia Juergen Universitaetsbibliothek Dortmund Eldorado 0231/755-4043 https://eldorado.tu-dortmund.de/ Tel.: 0049-231-755-4043 -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2 ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] search can't sort by date issued
Hi Sue, I've been diagnosing this issue in Luke (a Java GUI that allows you browse your lucene index). And while digging around, it looked like the sort_dateissued field is having trouble with certain date metadata. In our repository, we have our date metadata values scattered all about. 1981-12-07T16:56:12Z 1981-12-07 1981-12 1981 Each one of them is a valid ISO8601 date. However, that doesn't mean each of them is a valid date in Lucene (your search and browse index). A metadata person might see 1981-12 as meaning some type of range or approximation. However, when you are searching and sorting, it must be able to sort the values precisely. So is 1981-12 before or after 1981-12-07? Is 1981-12 before, after, or equal to 1981-12-01? I'll ask my metadata people if we can flatten our metadata for dates, and stuff them to have a day (of the first of the month). And I'll dig further into the DSpace reindexing code to see if when we are processing DSpace metadata dates, that might be valid iso8601, that we convert them to an appropriate lucene date. Peter Dietz On Thu, Feb 2, 2012 at 11:55 PM, Thornton, Susan M. (LARC-B702)[LITES] susan.m.thorn...@nasa.gov wrote: Thanks Peter. I've spent several hours researching this issue, especially why we have it in one DSpace instance and not another (running same versions). Although I'm not 100% sure, I suspect the issue is caused by invalid data in the date.issued field(s) in the respository. The solution for this, of course, would be to clean up the bad dates we have and then put some edits on the date fields that end up in DSpace so we do not allow bad dates to get IN our repository. But again, I'm not 100% sure of this and I won't be able to get back to looking into this for awhile. Best regards, Sue Sue Walker-Thornton Software Developer|Database Administrator NASA Langley Research Center SGT, Inc.|LITES Contract 130 Research Drive Hampton, VA 23666 Office: (757) 864-2368|Fax: (757) 224-4001|Mobile: (757) 506-9903 Email: susan.m.thorn...@nasa.gov -- *From:* Peter Dietz [pdiet...@gmail.com] *Sent:* Wednesday, February 01, 2012 12:29 PM *To:* Cristian Romanescu *Cc:* dspace-tech@lists.sourceforge.net *Subject:* Re: [Dspace-tech] search can't sort by date issued Hi All, I've just started digging into this as well. Its really unfortunate to only get relevance results for searches. In digging in, I've spit out the stack trace, and its telling me a few things. 1) Do we have bad metadata for dc.date.issued? -- (I've already harassed my content folks to have them review all our metadata) ;) 2) Are we doing the comparison of dates incorrectly. The error below says is the value of dateissued an INT. -- I've been reading this thread, which is very similar: http://www.gossamer-threads.com/lists/lucene/java-user/109530 2012-01-31 17:47:02,475 ERROR org.dspace.search.DSQuery @ Unable to use speficied sort option: dateissued 2012-01-31 17:47:02,475 ERROR org.dspace.search.DSQuery @ Invalid shift value in prefixCoded string (is encoded value really an INT?) 2012-01-31 17:47:02,476 ERROR org.dspace.search.DSQuery @ java.lang.NumberFormatException: Invalid shift value in prefixCoded string (is encoded value really an INT?) at org.apache.lucene.util.NumericUtils.prefixCodedToInt(NumericUtils.java:233) at org.apache.lucene.search.FieldCache$7.parseInt(FieldCache.java:237) at org.apache.lucene.search.FieldCacheImpl$IntCache.createValue(FieldCacheImpl.java:457) at org.apache.lucene.search.FieldCacheImpl$Cache.get(FieldCacheImpl.java:224) at org.apache.lucene.search.FieldCacheImpl.getInts(FieldCacheImpl.java:430) at org.apache.lucene.search.FieldCacheImpl$IntCache.createValue(FieldCacheImpl.java:447) at org.apache.lucene.search.FieldCacheImpl$Cache.get(FieldCacheImpl.java:224) at org.apache.lucene.search.FieldCacheImpl.getInts(FieldCacheImpl.java:430) at org.apache.lucene.search.FieldComparator$IntComparator.setNextReader(FieldComparator.java:332) at org.apache.lucene.search.TopFieldCollector$MultiComparatorNonScoringCollector.setNextReader(TopFieldCollector.java:435) at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:249) at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:240) at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:181) at org.apache.lucene.search.Hits.getMoreDocs(Hits.java:113) at org.apache.lucene.search.Hits.init(Hits.java:90) at org.apache.lucene.search.Searcher.search(Searcher.java:63) at org.dspace.search.DSQuery.doQuery(DSQuery.java:151) at org.dspace.search.DSQuery.doQuery(DSQuery.java:309) at org.dspace.app.xmlui.aspect.artifactbrowser.AbstractSearch.performSearch(AbstractSearch.java:438) Just for fun, I enabled Discovery on our development machines, and sorting by date issued works perfectly in a search. So, a quick-fix would be to switch to using discovery. But, none-the-less, I look
Re: [Dspace-tech] search can't sort by date issued
I'll also add that we have two repositories, and one of them can you can search, and it will sort properly. And the other has the problems identified in this thread. I'm sure both repositories has equally screwy metadata for dates. So I'm not entirely sure this is going to be the end of it. Peter Dietz On Fri, Feb 3, 2012 at 2:51 PM, Peter Dietz pdiet...@gmail.com wrote: Hi Sue, I've been diagnosing this issue in Luke (a Java GUI that allows you browse your lucene index). And while digging around, it looked like the sort_dateissued field is having trouble with certain date metadata. In our repository, we have our date metadata values scattered all about. 1981-12-07T16:56:12Z 1981-12-07 1981-12 1981 Each one of them is a valid ISO8601 date. However, that doesn't mean each of them is a valid date in Lucene (your search and browse index). A metadata person might see 1981-12 as meaning some type of range or approximation. However, when you are searching and sorting, it must be able to sort the values precisely. So is 1981-12 before or after 1981-12-07? Is 1981-12 before, after, or equal to 1981-12-01? I'll ask my metadata people if we can flatten our metadata for dates, and stuff them to have a day (of the first of the month). And I'll dig further into the DSpace reindexing code to see if when we are processing DSpace metadata dates, that might be valid iso8601, that we convert them to an appropriate lucene date. Peter Dietz On Thu, Feb 2, 2012 at 11:55 PM, Thornton, Susan M. (LARC-B702)[LITES] susan.m.thorn...@nasa.gov wrote: Thanks Peter. I've spent several hours researching this issue, especially why we have it in one DSpace instance and not another (running same versions). Although I'm not 100% sure, I suspect the issue is caused by invalid data in the date.issued field(s) in the respository. The solution for this, of course, would be to clean up the bad dates we have and then put some edits on the date fields that end up in DSpace so we do not allow bad dates to get IN our repository. But again, I'm not 100% sure of this and I won't be able to get back to looking into this for awhile. Best regards, Sue Sue Walker-Thornton Software Developer|Database Administrator NASA Langley Research Center SGT, Inc.|LITES Contract 130 Research Drive Hampton, VA 23666 Office: (757) 864-2368|Fax: (757) 224-4001|Mobile: (757) 506-9903 Email: susan.m.thorn...@nasa.gov -- *From:* Peter Dietz [pdiet...@gmail.com] *Sent:* Wednesday, February 01, 2012 12:29 PM *To:* Cristian Romanescu *Cc:* dspace-tech@lists.sourceforge.net *Subject:* Re: [Dspace-tech] search can't sort by date issued Hi All, I've just started digging into this as well. Its really unfortunate to only get relevance results for searches. In digging in, I've spit out the stack trace, and its telling me a few things. 1) Do we have bad metadata for dc.date.issued? -- (I've already harassed my content folks to have them review all our metadata) ;) 2) Are we doing the comparison of dates incorrectly. The error below says is the value of dateissued an INT. -- I've been reading this thread, which is very similar: http://www.gossamer-threads.com/lists/lucene/java-user/109530 2012-01-31 17:47:02,475 ERROR org.dspace.search.DSQuery @ Unable to use speficied sort option: dateissued 2012-01-31 17:47:02,475 ERROR org.dspace.search.DSQuery @ Invalid shift value in prefixCoded string (is encoded value really an INT?) 2012-01-31 17:47:02,476 ERROR org.dspace.search.DSQuery @ java.lang.NumberFormatException: Invalid shift value in prefixCoded string (is encoded value really an INT?) at org.apache.lucene.util.NumericUtils.prefixCodedToInt(NumericUtils.java:233) at org.apache.lucene.search.FieldCache$7.parseInt(FieldCache.java:237) at org.apache.lucene.search.FieldCacheImpl$IntCache.createValue(FieldCacheImpl.java:457) at org.apache.lucene.search.FieldCacheImpl$Cache.get(FieldCacheImpl.java:224) at org.apache.lucene.search.FieldCacheImpl.getInts(FieldCacheImpl.java:430) at org.apache.lucene.search.FieldCacheImpl$IntCache.createValue(FieldCacheImpl.java:447) at org.apache.lucene.search.FieldCacheImpl$Cache.get(FieldCacheImpl.java:224) at org.apache.lucene.search.FieldCacheImpl.getInts(FieldCacheImpl.java:430) at org.apache.lucene.search.FieldComparator$IntComparator.setNextReader(FieldComparator.java:332) at org.apache.lucene.search.TopFieldCollector$MultiComparatorNonScoringCollector.setNextReader(TopFieldCollector.java:435) at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:249) at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:240) at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:181) at org.apache.lucene.search.Hits.getMoreDocs(Hits.java:113) at org.apache.lucene.search.Hits.init(Hits.java:90) at org.apache.lucene.search.Searcher.search(Searcher.java:63) at
Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1
I did go ahead and delete the other 2 constraints you mentioned, however I was able to delete a record online once I dropped just the collection2item $2 constraint. Thanks again for helping us solve this outstanding problem we've had since implementing 1.7.1! Best regards, Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Juergen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Friday, February 03, 2012 12:51 PM To: Thornton, Susan M. (LARC-B702)[LITES] Cc: DSpace-tech@lists.sourceforge.net; Dedmond, Nicole K. (LARC-B702)[LITES] Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, to be precise, there shoul have been 3 constraints referenced as $n to be deleted in: collection2item community2community community2collection as mentioned in my first post. Claudia Thanks so much Claudia! This fixed our problem!! Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Friday, February 03, 2012 10:07 AM To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, no, in the case you ran into the below mentioned problem, you got to drop the nameless constraints, e.g.: ALTER TABLE collection2item DROP CONSTRAINT $2 The error you posted org.postgresql.util.PSQLException: ERROR: update or delete on table item violates foreign key constraint $2 on table collection2item Detail: Key (item_id)=(429349) is still referenced from table collection2item indicates that these constraints were not dropped. Hope that helps Claudia Jürgen Am 03.02.2012 15:52, schrieb Thornton, Susan M. (LARC-B702)[LITES]: Hi Claudia, I don't remember getting these errors when upgrading from 1.5 to 1.6, but we never really implemented 1.6 - I ran what I needed to run for database changes from 1.5 -- 1.6 -- 1.7 and implemented 1.7.1, so I may have missed it. So is this what you're saying I need to do? ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT community2collection_collection_id_fkey; Thanks a bunch, Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Thursday, February 02, 2012 3:31 AM To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, while updating to 1.6 did you get some errors like that: psql:database_schema_15-16.sql:105: ERROR: constraint community2collection_collection_id_fkey of relation community2collection does not exist ALTER TABLE psql:database_schema_15-16.sql:108: ERROR: constraint community2community_child_comm_id_fkey of relation community2community does not exist ALTER TABLE psql:database_schema_15-16.sql:111: ERROR: constraint collection2item_item_id_fkey of relation collection2item does not exist If so, inspect your database and use the references for the foreign keys to delete them, e.g:: psql [YourDBName] \d [TableName] will show you the foreign keys, e.g.: \d community2collection Table public.community2collection Column | Type | Modifiers ---+-+--- id| integer | not null community_id | integer | collection_id | integer | Indexes: community2collection_pkey PRIMARY KEY, btree (id) community2collection_collection_id_idx btree (collection_id) community2collection_community_id_idx btree (community_id) Foreign-key constraints: $1 FOREIGN KEY (community_id) REFERENCES community(community_id) $2 FOREIGN KEY (collection_id) REFERENCES collection(collection_id) In that case you got to run: ALTER TABLE collection2item DROP CONSTRAINT $2; ALTER TABLE community2community DROP CONSTRAINT $2; ALTER TABLE community2collection DROP CONSTRAINT $2; The reason for this is: In Step 7 Update the database it can happen that not all the commands in the database_schema_15-16.sql are executed properly. The commands to drop foreign keys: ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT community2collection_collection_id_fkey; assume that the keys got default names, whereas depending on the database version and operating system on which your instance started, they can have no names and just be counted internally. If you got no names or other
Re: [Dspace-tech] Docushare-to-DSpace interface
Thanks for your reply Claudia. I'm going to definitely look at SWORD as a solution for us! Best regards, Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Juergen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Friday, February 03, 2012 2:45 PM To: Thornton, Susan M. (LARC-B702)[LITES] Cc: DSpace-tech@lists.sourceforge.net; Dedmond, Nicole K. (LARC-B702)[LITES] Subject: Re: [Dspace-tech] Docushare-to-DSpace interface Hello Susan, you could use Sword (http://swordapp.org/) to deposit from Docushare to DSpace or OAI-ORE to harvest from Docushare, if Docushare supports it. Hope that helps Claudia Jürgen Hello, We have a Docushare instance in which we store open, active projects. Once the projects are complete, we export the files/documents from Docushare to DSpace for archival (we are currently running the JSPUI version of DSpace 1.7.1 on a Sun Solaris server with PostgreSQL). For some time now, we've had a very piecemeal process that accomplishes this and we would like to automate it. Of course, the objective is to create the directory structure that DSpace needs in order to import content into specified collections. I'd like to hear from anyone who's done this or something like it and what your ultimate solution was. Has anyone used SWORD for this and, if so, what kind of development effort was required? Any other solutions we might be able to implement in a fairly short period of time? I hesitate to just write an interface between Docushare and DSpace when it's entirely possible that we might want to migrate content from another source (not just Docushare) in the future. We also periodically receive new collections to import in the form of a disk of documents and a spreadsheet of metadata where we use a similar, somewhat piecemeal process to match documents to metadata and convert to the required DSpace import directory structure. Any helpful suggestions/solutions would be appreciated! Thanks and Best regards, Sue Sue Walker-Thornton Software Developer/Database Administrator NASA Langley Research Center - LITES Contract susan.m.thorn...@nasa.gov (W) 757-864-2368 (M) 757-506-9903 -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2__ _ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech Mit freundlichen Gruessen Claudia Juergen Universitaetsbibliothek Dortmund Eldorado 0231/755-4043 https://eldorado.tu-dortmund.de/ Tel.: 0049-231-755-4043 -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2 ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] SOLR statistics
We're running DSpace 7.1. We have never, however, gotten our SOLR statistics to actually work. The old statistics module still shows its spott data, but nothing ever shows up for our SOLR statistics. The settings in our config file seem to be right, and I can connect to the SOLR statistics module from the server using wget or lynx. But I never, ever see any statistics. I know I am probably missing something simple here. What is it? Thanks in advance. *Jason Fowler* The Southern Baptist Theological Seminary -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] SOLR statistics
I'm having the same problem, I think is something I'm not copying into the Apache scope. I read the documentation and tried this: wget http://127.0.0.1/solr/statistics/select?q=*:* to find out which is the correct solr.server path, but I keep getting Error 404 or Error 500. Any help? -- La pureza del alma no se pierde sin consentimiento -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1
Hello Susan, good, otherwise you wouldn't have been able to to delete a collection or communitiy. This will most likely occur less frequently, allthough with regards to persistent id's deleting an item shouldn't occur too, rather withdrawing it. cu Claudia Jürgen I did go ahead and delete the other 2 constraints you mentioned, however I was able to delete a record online once I dropped just the collection2item $2 constraint. Thanks again for helping us solve this outstanding problem we've had since implementing 1.7.1! Best regards, Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Juergen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Friday, February 03, 2012 12:51 PM To: Thornton, Susan M. (LARC-B702)[LITES] Cc: DSpace-tech@lists.sourceforge.net; Dedmond, Nicole K. (LARC-B702)[LITES] Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, to be precise, there shoul have been 3 constraints referenced as $n to be deleted in: collection2item community2community community2collection as mentioned in my first post. Claudia Thanks so much Claudia! This fixed our problem!! Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Friday, February 03, 2012 10:07 AM To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, no, in the case you ran into the below mentioned problem, you got to drop the nameless constraints, e.g.: ALTER TABLE collection2item DROP CONSTRAINT $2 The error you posted org.postgresql.util.PSQLException: ERROR: update or delete on table item violates foreign key constraint $2 on table collection2item Detail: Key (item_id)=(429349) is still referenced from table collection2item indicates that these constraints were not dropped. Hope that helps Claudia Jürgen Am 03.02.2012 15:52, schrieb Thornton, Susan M. (LARC-B702)[LITES]: Hi Claudia, I don't remember getting these errors when upgrading from 1.5 to 1.6, but we never really implemented 1.6 - I ran what I needed to run for database changes from 1.5 -- 1.6 -- 1.7 and implemented 1.7.1, so I may have missed it. So is this what you're saying I need to do? ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT community2collection_collection_id_fkey; Thanks a bunch, Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Thursday, February 02, 2012 3:31 AM To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, while updating to 1.6 did you get some errors like that: psql:database_schema_15-16.sql:105: ERROR: constraint community2collection_collection_id_fkey of relation community2collection does not exist ALTER TABLE psql:database_schema_15-16.sql:108: ERROR: constraint community2community_child_comm_id_fkey of relation community2community does not exist ALTER TABLE psql:database_schema_15-16.sql:111: ERROR: constraint collection2item_item_id_fkey of relation collection2item does not exist If so, inspect your database and use the references for the foreign keys to delete them, e.g:: psql [YourDBName] \d [TableName] will show you the foreign keys, e.g.: \d community2collection Table public.community2collection Column | Type | Modifiers ---+-+--- id| integer | not null community_id | integer | collection_id | integer | Indexes: community2collection_pkey PRIMARY KEY, btree (id) community2collection_collection_id_idx btree (collection_id) community2collection_community_id_idx btree (community_id) Foreign-key constraints: $1 FOREIGN KEY (community_id) REFERENCES community(community_id) $2 FOREIGN KEY (collection_id) REFERENCES collection(collection_id) In that case you got to run: ALTER TABLE collection2item DROP CONSTRAINT $2; ALTER TABLE community2community DROP CONSTRAINT $2; ALTER TABLE community2collection DROP CONSTRAINT $2; The reason for this is: In Step 7 Update the database it can happen that not all the commands in the database_schema_15-16.sql are executed properly. The commands to drop foreign keys: ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT
