[Dspace-tech] ORA-01408 and ORA-00942 errors while installing Dspace 1.5.2

2009-10-09 Thread Brouns, Francis
Hi, We have been running Dspace with Postgresql for some years now. Our IT department would like to move to Oracle. I've been trying to do a fresh-install of Dspace 1.5.2 using an Oracle 10.2.2.0.2 database, on a SLES10 server. The Oracle database is located on a separate database server. The

[Dspace-tech] Unable to create collections in new installation Dspace 1.5.2

2009-10-09 Thread Brouns, Francis
Hi all, We just installed Dspace 1.5.2 (new installation) using Oracle as database. Ant reports a succesfull build, although there are errors during database setup (indexes of the Eperson table are not created, and the tables WorkflowItem and TasklistItem are not created). However, I can

Re: [Dspace-tech] Unable to create collections in new installation Dspace 1.5.2

2009-10-12 Thread Brouns, Francis
-Oorspronkelijk bericht- Van: Stuart Lewis [mailto:s.le...@auckland.ac.nz] Verzonden: zondag 11 oktober 2009 10:14 Aan: Brouns, Francis CC: dspace-tech@lists.sourceforge.net Onderwerp: Re: [Dspace-tech] Unable to create collections in new installation Dspace 1.5.2 Hi Francis, The error message

Re: [Dspace-tech] ORA-01408 and ORA-00942 errors while installing Dspace 1.5.2 due to errors in database_schema.sql

2009-10-13 Thread Brouns, Francis
Hi all, The ORA-01408 errors seem to be caused because column (email) is defined with a Unique key constraint. Our DBA tells me that Oracle implements unique key constraints by creating an index (SYS_C007537). The create index statement than results in an error, because the unique index

Re: [Dspace-tech] Unable to create collections in new installation Dspace 1.5.2

2009-10-13 Thread Brouns, Francis
, the errors below no longer occurred. Thanks, Francis -Oorspronkelijk bericht- Van: Stuart Lewis [mailto:s.le...@auckland.ac.nz] Verzonden: zondag 11 oktober 2009 10:14 Aan: Brouns, Francis CC: dspace-tech@lists.sourceforge.net Onderwerp: Re: [Dspace-tech] Unable to create collections in new

[Dspace-tech] problems with metadata and bitstream registries despite succesful build

2009-10-13 Thread Brouns, Francis
Hi, In the past I have installed and upgraded Dspace on Linux using Postgresql without problems. Now we are trying to install Dspace 1.5.2 on Oracle (Linux SLES environments) and run in many problems. Although there are several errors reported during the set-up of the database, ant reports

Re: [Dspace-tech] Unable to compile class for JSP

2009-10-20 Thread Brouns, Francis
Hi all, Thanks for all your advice. Our java version installed via SLES yast was java-1_5_0-ibm. Installing the java1.6 did not help. javava version 1.5.0 Java(TM) 2 Runtime Environment, Standard Edition (build pxi32dev-20090707 (SR10 )) IBM J9 VM (build 2.3, J2RE 1.5.0 IBM J9 2.3 Linux

[Dspace-tech] Remove subscriptions

2009-10-22 Thread Brouns, Francis
Hi all, Is it possible as admin to remove subscriptions for certain accounts, other than directly working in the database? We have accounts for which the email address no longer is functioning. When they have subscribed to a collection, this results in errors. We are running Dspace 1.4. Kind

Re: [Dspace-tech] Remove subscriptions

2009-10-22 Thread Brouns, Francis
Hi Claudia, Thanks for your fast response. Francis -Oorspronkelijk bericht- Van: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Verzonden: donderdag 22 oktober 2009 10:57 Aan: Brouns, Francis CC: dspace-tech@lists.sourceforge.net Onderwerp: Re: [Dspace-tech] Remove

[Dspace-tech] Lucene errors with batch import into 1.5.2

2009-10-23 Thread Brouns, Francis
Hi all, We have been running Dspace for some years now and now are trying to upgrade to 1.5.2 and at the same time move from Postgresql to Oracle. I'm looking at the batch import whether that would be an option to migrate data from Postgresql to Oracle. As I do not have access to the server,

[Dspace-tech] Differences in db with upgrade and fresh install

2009-12-15 Thread Brouns, Francis
Hi, We are in the process of upgrading from Dspace 1.4.2 to 1.5.2, at the same time moving from Postgresql to Oracle. When I perform an upgrade from 1.4 to 1.5.2 and run the database_schema_142-15.sql on Postgresql the tables history and history_state are dropped. However, when I do a clean

[Dspace-tech] Update Messages.properties

2010-01-06 Thread Brouns, Francis
Hi, I need to change some of the default messages and add a new one. Previously I made these changes in Messages.properties. According to the manual that still should be possible in 1.5.2. The updated file should be placed in

[Dspace-tech] Visibility rss feeds

2010-01-13 Thread Brouns, Francis
Hi all, In 1.5.2 it seems possible to restrict which items are provided via the rss feeds. So, in dspace.cfg I've set harvest.includerestricted.rss = false Restricted items are not included in the RSS feed at the homepage, but when I check the RSS feed from the community page or the

Re: [Dspace-tech] Visibility rss feeds

2010-01-15 Thread Brouns, Francis
] Verzonden: donderdag 14 januari 2010 20:53 Aan: Brouns, Francis CC: dspace-tech@lists.sourceforge.net Onderwerp: Re: [Dspace-tech] Visibility rss feeds Hi Francis, In 1.5.2 it seems possible to restrict which items are provided via the rss feeds. So, in dspace.cfg I've set

[Dspace-tech] Import Postgresql timestamp data into Oracle

2010-01-18 Thread Brouns, Francis
Hi all, We are in the process of migrating our Dspace 1.4.2 instance that is running on Postgresql to an Oracle database. One of the (many) issues we encounter is the TIMESTAMP. Several tables contain a field of type TIMESTAMP. In the Postgresql database_schema.sql the type TIMESTAMP is used

Re: [Dspace-tech] Import Postgresql timestamp data into Oracle

2010-01-18 Thread Brouns, Francis
* from item; ITEM_ID SUBMITTER_ID IN_ARCHIVE WITHDRAWN LAST_MODIFIED OWNING_COLLECTION - 397 91 0 1 01-11-05 16:42:01,00 3 Best wishes, Francis -Oorspronkelijk bericht- Van: Brouns, Francis [mailto:francis.bro...@ou.nl

[Dspace-tech] Table columns not exported in same order

2010-01-19 Thread Brouns, Francis
Hi all, We are running Dspace for some years now, started at Dspace 1.1. When I export the item table, order of the columns is last_modified after owning_collection. CREATE TABLE item ( item_id integer NOT NULL, submitter_id integer, in_archive boolean, withdrawn boolean,

Re: [Dspace-tech] Collection Administrators

2010-01-22 Thread Brouns, Francis
Hello Richard, I don't know yet how it should work in DSpace 1.5.2, but what you describe is how it works in earlier versions. They can do most of the admin tasks, but can not replace bitstreams. Only site-wide admins can do that. Best wishes, Francis Van:

[Dspace-tech] Table epersongroup2workspaceitem

2010-01-22 Thread Brouns, Francis
Hi all, When I dump our database the table epersongroup2workspaceitem only contains three records. All these records refer to workspace_item_id that do not exist in table workspaceitem. The workspaceitem table contains many records, but no records to which the table epersongroup2workspaceitem

Re: [Dspace-tech] New to Dspace

2010-02-02 Thread Brouns, Francis
Hi, For Oracle this also works the same as for Postgresql. Only the db.url is different. Please note that the syntax for this db.url is not correct in the documentation, but is correct in dspace.cfg The documentation mentions db.url= jdbc.oracle.thin:@//host:port/dspace It should be

[Dspace-tech] Empty strings in most_recent_checksum

2010-02-03 Thread Brouns, Francis
Hi, We are in the process of migrating our Postgresql database to Oracle and encounter a problem with the most_recent_checksum table. This table contains records with '' (empty strings) for expected_checksum and current_checksum when to_be_processed=0. Oracle returns an ORA-01400 error on

Re: [Dspace-tech] Database and Server Migration

2010-02-09 Thread Brouns, Francis
Hi, we are doing the same, although we run SLES. Migrating the data to Oracle is a pain, as I do not have a ICT developer who could assist and we are manually importing the data. We dumped every table from Postgresql using the insert into values syntax. Be sure to do that, because columns

Re: [Dspace-tech] Database and Server Migration

2010-02-10 Thread Brouns, Francis
... --- Salut, Ricardo Borillo Domenech http://xml-utils.com On Tue, Feb 9, 2010 at 10:46, Brouns, Francis francis.bro...@ou.nl wrote: Hi, we are doing the same, although we run SLES. Migrating the data to Oracle is a pain, as I do not have a ICT developer

[Dspace-tech] Problem submitting new item using Oracle

2010-02-24 Thread Brouns, Francis
Hi, We are testing Dspace 1.5.2 on an Oracle database. When we try to submit a new item, we receive an internal error after the upload step. We are able to upload files, but the error occurs when moving to the next step. According to the log file, the sql statements tries to insert values for

[Dspace-tech] Selection of Creative Commons takes forever

2010-03-12 Thread Brouns, Francis
Hi all, I'm testing our DSpace 1.5.2 installation. When I submit an item, choose a CC licence and click on proceed, I need to wait very long for the screen to return to dspace. The last time, it took almost 10 minutes. Any idea what would be causing this? We are running DSpace 1.5.2 on a

[Dspace-tech] Authorisation error on rss feeds

2010-07-23 Thread Brouns, Francis
Hi, Last week we upgraded our DSpace 1.4.2 server to DSpace 1.5.2. The tests at the testserver went all fine. Now on the production server we are running into problems we did not encounter at the testserver. For example with the RSS feeds. The configuration in dspace.cfg is:

[Dspace-tech] Dspace out of memory errors

2010-07-23 Thread Brouns, Francis
Hi, Last week we completed the upgrade of our DSpace 1.4.2 instance to DSpace 1.5.2, but now are encountering lots of memory problems, which we did not encounter on our test server. DSpace is installed on a SLES11 server, the Oracle database is located at a different machine. We are running

Re: [Dspace-tech] Dspace out of memory errors

2010-07-23 Thread Brouns, Francis
:01 Aan: Brouns, Francis; 'dspace-tech@lists.sourceforge.net' Onderwerp: RE: Dspace out of memory errors Hi Francis, It's the memory allocated to Tomcat rather than the total available to the server that is the problem. The memory required by DSpace has increased over the years

Re: [Dspace-tech] Authorisation error on rss feeds

2010-07-23 Thread Brouns, Francis
normally. Only the RSS feeds were giving errors. Regards, Francis Brouns Van: bluy...@gmail.com [mailto:bluy...@gmail.com] Namens Bram Luyten Verzonden: vrijdag 23 juli 2010 13:57 Aan: Brouns, Francis CC: dspace-tech@lists.sourceforge.net Onderwerp: Re: [Dspace-tech

Re: [Dspace-tech] Authorisation error on rss feeds

2010-07-25 Thread Brouns, Francis
Java 1.5. Any ideas on how to solve this? Best regards, Francis Brouns From: Brouns, Francis [francis.bro...@ou.nl] Sent: 23 July 2010 16:14 To: 'Bram Luyten' Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Authorisation error on rss feeds

Re: [Dspace-tech] Authorisation error on rss feeds

2010-07-26 Thread Brouns, Francis
for the database pool and connections parameters are being used. Best wishes, Francis Brouns -Oorspronkelijk bericht- Van: Brouns, Francis [mailto:francis.bro...@ou.nl] Verzonden: zondag 25 juli 2010 18:32 Aan: dspace-tech@lists.sourceforge.net Onderwerp: Re: [Dspace-tech] Authorisation error

Re: [Dspace-tech] Authorisation error on rss feeds

2010-07-27 Thread Brouns, Francis
2010 16:44 Aan: Brouns, Francis CC: dspace-tech@lists.sourceforge.net Onderwerp: Re: [Dspace-tech] Authorisation error on rss feeds Francis, That error does not seem to be related to OutOfMemory problems or even database connection problems (especially since you said everything else is working

Re: [Dspace-tech] Authorisation error on rss feeds

2010-07-27 Thread Brouns, Francis
/2010 7:09 AM, Brouns, Francis wrote: Hallo Tim, Thanks for your response. We have numerous error messages, and I have not yet been able to trace them to a single cause. At first I thought they were related to the outofmemory error because of the time the RSS errors occurred. That seemed

[Dspace-tech] Timing subscription email cronjob

2010-09-13 Thread Brouns, Francis
Hi all, For some time now, we have been getting subscription emails for new and modified items on at least two (sometimes three) consecutive days. This happened on our previous Dspace 1.4.2 server, but is still happening after we migrated to Dspace 1.5.2. I assume that has to day with the time

Re: [Dspace-tech] Timing subscription email cronjob

2010-09-14 Thread Brouns, Francis
Claudia Jürgen Am 13.09.2010 11:25, schrieb Brouns, Francis: Hi all, For some time now, we have been getting subscription emails for new and modified items on at least two (sometimes three) consecutive days. This happened on our previous Dspace 1.4.2 server, but is still happening after we

Re: [Dspace-tech] Oracle users - 64bit or 32bit? freshly built database?, (Claudia J?rgen)

2010-10-01 Thread Brouns, Francis
Dear Marvin, When I tried do a fresh-install of Dspace 1.5.2 on Oracle, I discovered that their are differences between the SQL schema scripts for creating a new database and when you would upgrade a database. See my posts about this topic earlier this year. It looks like either the registry

[Dspace-tech] How to enable creative commons

2012-09-21 Thread Brouns, Francis
Hi, I'm in the process of upgrading our Dspace 1.5.2 server to 1.8. Most seem to be working fine. However, I no longer can apply a creative commons license to any submission. We are using jspui, but the CC licence is missing from the steps. In previous versions I had to enable this step in

Re: [Dspace-tech] How to enable creative commons

2012-09-22 Thread Brouns, Francis
best luck Emilio Lorenzo El 21/09/2012 17:51, Brouns, Francis escribió: Hi, I'm in the process of upgrading our Dspace 1.5.2 server to 1.8. Most seem to be working fine. However, I no longer can apply a creative commons license to any submission. We are using jspui, but the CC licence

[Dspace-tech] Constraints in Oracle database

2012-09-25 Thread Brouns, Francis
Hi all, We are in the process of upgrading our dspace from 1.5.2. to 1.8.2 and notice many differences between a newly created dspace 1.8 schema (Oracle) and when we upgrade an existing Oracle schema. Most of the issues we can resolve. However, it is not clear to us whether there should be 3

Re: [Dspace-tech] SOLR converting old stats data

2012-09-25 Thread Brouns, Francis
From: Hilton Gibson [mailto:hilton.gib...@gmail.com] Sent: Tuesday, September 25, 2012 4:15 PM To: Brouns, Francis Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] SOLR converting old stats data Perhaps this will help: http://wiki.lib.sun.ac.za/index.php/SUNScholar

[Dspace-tech] When is an item considered to be updated

2012-10-09 Thread Brouns, Francis
Hi all, We recently upgraded to Dspace 1.8.2 and noticed that users who subscribed now received a message about many items that supposedly have changed. We have configured Dspace to send out notifications when items are changed, because in our workflow some of the metadata fields are updated

[Dspace-tech] SWORD ingestion of Creative Commons

2012-10-31 Thread Brouns, Francis
Hello, We are developing a tool that allows users to submit items to Dspace from within another webapplication. We use the SWORD ingester for that. Importing the item and metadata is working. But we would also like to attach a Creative Commons licence in the package. How can we do that? In a

Re: [Dspace-tech] SWORD ingestion of Creative Commons

2012-10-31 Thread Brouns, Francis
Dear helix84, Thank you for your very quick reply. We will look into it. Best wishes, Francis -Original Message- From: ivan.ma...@gmail.com [mailto:ivan.ma...@gmail.com] On Behalf Of helix84 Sent: Wednesday, October 31, 2012 11:39 AM To: Brouns, Francis Cc: dspace-tech

Re: [Dspace-tech] Creative commons in edit item tool

2013-01-21 Thread Brouns, Francis
. Best wishes, Francis -Original Message- From: ivan.ma...@gmail.com [mailto:ivan.ma...@gmail.com] On Behalf Of helix84 Sent: Monday, January 21, 2013 2:12 PM To: Jordan Piščanc; Brouns, Francis Cc: DSpace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Creative commons in edit item

[Dspace-tech] accepted submission still in unfinished submission

2013-07-18 Thread Brouns, Francis
Hi all, We are running Dspace 1.8.2 on Oracle, using the default JSP version. One of our users has submitted an item in January this year. This item has been approved and is accessible in the collection. However, the user still has this item in the list of Unfinished Submission that appears on

[Dspace-tech] build.properties not reflected in dspace.cfg

2014-01-09 Thread Brouns, Francis
Hi all, I'm trying out the Dspace 3.2 installation on a Windows machine, and am using build.properties as instructed in the manual. It turns out that the settings from build.properties are not copied to [dspace-source]/dspace/config/dspace.cfg as mentioned in the PDF manual (pg 50), but only

Re: [Dspace-tech] build.properties not reflected in dspace.cfg

2014-01-10 Thread Brouns, Francis
Hi Bram, yesterday I tried at least 5 times and did not succeed. This morning I tried to reproduce it to get you the output of maven en ant, but now everything seems fine. Now the config directory also contain a dspace.cfg.old and a dspace.cfg.default, which did not occur yesterday. This is

[Dspace-tech] again problems with build.properties, dspace.cfg and install directories

2014-01-13 Thread Brouns, Francis
Hi all, I'm trying out a DSpace 3.2 install and update on a Windows machine and encounter many problems. Our server will be running on Linux, but I'm looking into new features using my own laptop, running Windows 7. Today I finished our JSP customisations, copied those into the [dspace-source]

Re: [Dspace-tech] again problems with build.properties, dspace.cfg and install directories

2014-01-15 Thread Brouns, Francis
to test out the update from 1.8 to 3.2 as well as explore new features and explore the switch from the current jspui to xmlui. best wishes, Francis From: bluy...@gmail.com [mailto:bluy...@gmail.com] On Behalf Of Bram Luyten Sent: 14 January 2014 11:46 To: Brouns, Francis Cc: dspace-tech

Re: [Dspace-tech] again problems with build.properties, dspace.cfg and install directories

2014-01-15 Thread Brouns, Francis
Hi Bram, attached my local.properties file. I'm running Windows 7 Entreprise, maven 3.10.0, ant 1.9.2, tomcat 6.0.37, Sun java SE 1.7.0_21 best wishes, Francis From: bluy...@gmail.com [mailto:bluy...@gmail.com] On Behalf Of Bram Luyten Sent: 15 January 2014 15:51 To: Brouns, Francis Cc

Re: [Dspace-tech] again problems with build.properties, dspace.cfg and install directories

2014-01-15 Thread Brouns, Francis
Hi Tim and Bram, thank you very much for spotting this. I could not find the differences. best wishes, Francis -Original Message- From: Tim Donohue [mailto:tdono...@duraspace.org] Sent: 15 January 2014 16:25 To: Brouns, Francis Cc: 'Bram Luyten'; dspace-tech@lists.sourceforge.net

[Dspace-tech] problems with stats-log-converter

2014-01-24 Thread Brouns, Francis
Hi all, we are in the process of upgrading our Dspace 1.8.3 server to Dspace 3.2 and also want to switch to the new statistics module based on Solr. That means that we need to convert the old logs and import those into Solr. It seems that a full path needs to be specified for the location of

Re: [Dspace-tech] problems with stats-log-converter

2014-01-27 Thread Brouns, Francis
] Sent: 24 January 2014 17:51 To: Brouns, Francis Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] problems with stats-log-converter Hi Francis Here is something I used quite a while ago that worked: http://wiki.lib.sun.ac.za/index.php/SUNScholar/Asset_Statistics/Old_Versions

[Dspace-tech] legacy statistics shown in jspui but not in xmlui

2014-02-04 Thread Brouns, Francis
Hi all, I'm confused about the statistics module in Dspace. We are currently running Dspace 1.8.3, but have not yet migrated to SOLR. So, we are still running the legacy stats module. I am referring to the statistics that are access through the admin menu. Crontabs are set up and the jspui

Re: [Dspace-tech] [Dspace-general] Database Migration Postgresql-- Oracle

2014-02-21 Thread Brouns, Francis
Hi Emilio, we did this migration when we moved from Dspace 1.4 to Dspace 1.5. Dump every table separately. Ensure that you dump every table using INSERT INTO and not COPY. Be sure to do that, because columns positions have changed over time. Then we ran into all kinds of problems, when using

Re: [Dspace-tech] OAI set specification

2014-03-31 Thread Brouns, Francis
Hi Joan, did you get an answer to your question? We also have this problem, in that our harvester URL needs to stay the same as it was before in order for our site to be harvested. best wishes, Francis Brouns From: Joan Caparrós [mailto:joan.capar...@csuc.cat] Sent: 28 January 2014 17:17

Re: [Dspace-tech] OAI set specification

2014-04-02 Thread Brouns, Francis
| Valkenburgerweg 177 6419 AT Heerlen | P.O. Box 2960 6401 DL Heerlen | Phone + 31 45 5762152 | Fax +31 45 5762800 | e-mail francis.bro...@ou.nl From: Kim Shepherd [mailto:kim.sheph...@gmail.com] Sent: 31 March 2014 21:29 To: Brouns, Francis Cc: Joan Caparrós; dspace-tech@lists.sourceforge.net Subject

[Dspace-tech] DSpace 5.3 SOLR can't find libs

2015-08-18 Thread Brouns, Francis
Hi all, I am testing out the DSpace 5.3 upgrade on my local Windows machine. The solr.log reports many warnings when trying to add lib dirs. to classloader. Is this a Windows specific problem? Where do I correct this path? 2015-08-18 14:08:40,792 INFO org.apache.solr.core.SolrResourceLoader @

Re: [Dspace-tech] OAI no matches for this query because of typo in build.properties

2015-08-18 Thread Brouns, Francis
My apologies, this was my own mistake, the original build.properties, when downloaded is correct. -Original Message- From: Brouns, Francis [mailto:francis.bro...@ou.nl] Sent: 18 August 2015 14:47 To: dspace-tech@lists.sourceforge.net Subject: [Dspace-tech] OAI no matches

[Dspace-tech] OAI no matches for this query because of typo in build.properties

2015-08-18 Thread Brouns, Francis
Hi all, when testing the upgrade to Dspace 5.3 I again encountered many problems with OAI. Identify worked, and it would list Sets, but any request for ListRecords would result in No matches for this query. In the end I tracked it down to a typo in build.properties that resulted in an

[Dspace-tech] DSpace 5.3 OAI webapp MBean missing

2015-08-18 Thread Brouns, Francis
Hi all, I am preparing the upgrade to DSpace 5.3 and noticed a NullpointerException in Tomcat localhost logfiles. Is this related to the Jira DS-2078? That should have been fixed in version 5.0. Despite the warnings in the log, I finally managed to get OAI working. When loading the oai webapp

[Dspace-tech] DSpace 5.3 SQLNestedException: Cannot get a connection

2015-08-26 Thread Brouns, Francis
Hi all, we encounter a lot of db connection errors while testing a clean install of Dspace 5.3 on SLES Linux, using Oracle11g. I did a clean install of Dspace 5.3, using jspui as ROOT context, created a few communities and collections, imported some collections from our production server and

[Dspace-tech] DSpace 5.3 missing link in Inactive account error message

2015-08-26 Thread Brouns, Francis
Hi all, a minor issue in Dspace 5.3. When an user with an account that has not yet been verified asks for a new password, a message is shown about the account being inactive. The message contains a link to register. This link is not set, instead {0} is shown. Inactive Account The e-mail