[Dspace-tech] DSpace 1.4.2 with Oracle, statistics
Hi all (trying dspace-tech after first attempt with dspace-dev...),
not sure if it's a bug, but when I'm trying to execute the scripts about
monthly stats or initial stats, I'm getting this Oracle error :
Exception in thread main java.sql.SQLException: ORA-01841: (full) year must
be between -4713 and +, and not be 0
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:952)
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1054)
at
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at
org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:259)
at
org.dspace.storage.rdbms.DatabaseManager.querySingle(DatabaseManager.java:384)
at
org.dspace.storage.rdbms.DatabaseManager.querySingle(DatabaseManager.java:395)
at
org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1264)
at
org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1293)
at
org.dspace.app.statistics.LogAnalyser.processLogs(LogAnalyser.java:532)
at org.dspace.app.statistics.LogAnalyser.main(LogAnalyser.java:327)
I'm pretty sure that all my accessioned dates are OK in my metadatas, since
it is filled automatically by DSpace. I've picked up the generated query that
is executed in that code and it's pretty difficult to see why Oracle doesn't
seem to like it, unless it is related to the CLOB change for the TEXT_VALUE
column. Here's an example of the query :
select count(*) as num
from item
where in_archive = 1
and withdrawn = 0
and item_id in
(
select item_id
from metadatavalue
where metadata_field_id =
(
select metadata_field_id
from metadatafieldregistry
where element = 'date'
and qualifier = 'accessioned'
)
and to_timestamp( to_char(text_value),
'-mm-ddthh24:mi:ssz' ) to_date('2007-09-01', '-mm-dd')
and to_timestamp( to_char(text_value),
'-mm-ddthh24:mi:ssz' ) to_date('2007-09-30', '-mm-dd')
)
Doesn't anyone have an idea at what is causing this and did someone has
experienced the same issue?
Thanks for your time.
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now http://get.splunk.com/___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Advanced search problems
Shane, That is odd... Have you double-checked all your log files, to make sure you're not getting any errors underneath after performing a search? So, checking the [dspace]/log/dspace.log and your Tomcat log file (e.g. [tomcat]/logs/catalina.out) If there's nothing strange in the log files after a search, you may also want to rerun your 'index-all', and check the logs after re-indexing (to make sure the indexer isn't running into strange issues). If nothing strange is happening in your logs, the next step you could take is to see what Lucene (underlying DSpace search engine) is actually indexing underneath. A good tool for this is Luke (http://www.getopt.org/luke/). You can point Luke at your [dspace]/search/ directory (where the DSpace Lucene Index is), and it will tell you all the documents you have indexed, and let you perform some basic browsing or searches directly against Lucene. However, I will admit, Luke does not have the *easiest* interface to understand. You'd mostly want to look at the Documents tab, to see all the documents Lucene indexed, and see if you can browse-by your custom field. Hopefully this gives you a few more things to look at. Let us know if you figure out what is going on! - Tim Shane Beers wrote: Unfortunately (or perhaps fortunately, as I would feel pretty dumb if that was the problem) that was just a typo on my own part in the email - not in dspace.cfg I'm still at a loss... Shane Beers Digital Repository Services Librarian George Mason University [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 703-993-3742 On Oct 12, 2007, at 3:23 AM, Claudia Jürgen wrote: Hi Shane, if this is a cut'n paste of your changes you simply got a typo there, search.index.13 = edt_disc:thesis.degree.discipline should be search.index.13 = etd_disc:thesis.degree.discipline sunny greetings Claudia Shane Beers schrieb: I am having issues with my search results when using the advanced search in our archive. I have added the thesis metadata schema to handle ETD documents, and these documents work great normally. I have edited the dspace.cfg to add: search.index.13 = edt_disc:thesis.degree.discipline Following that, I edited the advanced.jsp in dspace-source to add the appropriate element, with the following section in each of the three search box areas: option value=etd_disc %= field1.equals(etd_disc) ? selected=\selected\\ : %fmt:message key=jsp.search.advanced.type.etd_disc//option And then added in the appropriate element in Messages.properties, rebuilt, reindexed and all that. The field appears correctly, but when searching for terms that I know are there, I get no results. Additionally, a strange thing happens when no results are found that does not happen with any other search field - all 3 search boxes switch to Degree Discipline (the term I used in Messages.properties). This is just something I noticed that may help in a diagnosis. I'm not certain if I'm missing something or not, but I would really like this search index to function correctly. Shane Beers Digital Repository Services Librarian George Mason University [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 703-993-3742 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net mailto:DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech -- Tim Donohue Research Programmer, Illinois Digital Environment for Access to Learning and Scholarship (IDEALS) 135 Grainger Engineering Library University of Illinois at Urbana-Champaign email: [EMAIL PROTECTED] web: http://www.ideals.uiuc.edu phone: (217) 333-4648 fax: (217) 244-7764
[Dspace-tech] Completed install but page cannot be displayed
Hello. We are working on our first solo DSpace installation and have completed all the documented steps. However, when we launch a browser and try to access the site usinng http:// http://ipaddress:8080/dspace ipaddress:8080/dspace, we get a 'page cannot be displayed' message. We are running on Ubuntu Server 7.04. Tomcat 5.5 is started and set to port 8080. Everything during installation seemed to go fine. I am a Linux newbie and don't know where to begin to troubleshoot this. Any help is appreciated. -Peter - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Completed install but page cannot be displayed
Am 15.10.2007 um 21:39 schrieb Peter Urban: when we launch a browser and try to access the site usinng http:// ipaddress:8080/dspace, we get a 'page cannot be displayed' message. What do you get under http://ipaddress:8080 ? The Tomcat Homepage? So, is Tomcat actually running? If not, stick with this problem. Can you start it manually using catalina.sh? If this is not your issue, did you get any error msgs during your ant fresh-install? (ant-optional pkg is installed?). Does your automatic deployment work properly? So, if you drop your dspace.war into the webapps dir, does it get unpacked to a dspace subdir to the webapps dir? You are not yet at the point where the trouble with the database and the jdbc connector usually starts ;-) - no, sorry, I did not say that, I do not want you to shy away. There is really no reason to do so, just work through it step by step with getting tomcat up and running being the very first of them. Bye, Christian - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Completed install but page cannot be displayed
Thanks Christian. When I run http://ipaddress:8080, I get Internet Explorer cannot display the webpage. As best I can tell, Tomcat is running. I don't know much more about Tomcat to be able to troubleshoot further on my own. I get no errors when I start it using sudo /etc/init.d/tomcat5.5 start I installed Tomcat using Ubuntu's tomcat5.5 package. Initially, I had an error during installation * no JDK found - please set JAVA_HOME invoke-rc.d: initscript tomcat5.5, action start failed. dpkg: error processing tomcat5.5 (--configure): subprocess post-installation script returned error exit status 1 Errors were encountered while processing: tomcat5.5 E: Sub-process /usr/bin/dpkg returned an error code (1) Then, I realized that I had JRE (j2re1.4), not JDK, so I installed sun-java5-jdk package and reinstalled Tomcat. That seemed to work fine. I don't see a catalina.sh. I looked for it in /usr/local/tomcat, but I have no tomcat folder in local. Did I do the Tomcat installation wrong? On to your other questions... Yes ant-optional package is installed. When I copy the dspace*.war files to the webapps directory, they do not unpack. All I see are 2 war files, no dspace directory. Thanks for your help so far. -Peter -Original Message- From: Christian Voelker [mailto:[EMAIL PROTECTED] Sent: Monday, October 15, 2007 5:01 PM To: Peter Urban Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Completed install but page cannot be displayed Am 15.10.2007 um 21:39 schrieb Peter Urban: when we launch a browser and try to access the site usinng http:// ipaddress:8080/dspace, we get a 'page cannot be displayed' message. What do you get under http://ipaddress:8080 ? The Tomcat Homepage? So, is Tomcat actually running? If not, stick with this problem. Can you start it manually using catalina.sh? If this is not your issue, did you get any error msgs during your ant fresh-install? (ant-optional pkg is installed?). Does your automatic deployment work properly? So, if you drop your dspace.war into the webapps dir, does it get unpacked to a dspace subdir to the webapps dir? You are not yet at the point where the trouble with the database and the jdbc connector usually starts ;-) - no, sorry, I did not say that, I do not want you to shy away. There is really no reason to do so, just work through it step by step with getting tomcat up and running being the very first of them. Bye, Christian - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Item records that show pdf and html versions with html's images hidden
Hi folks, I have items with a pdf and html version. Each pdf is complete with all the images embedded. The html version has linked images. Is there any way to store a pdf and an html in the same item record so that only the pdf and html bitstreams show (with the html's gifs hidden in background)? I know I can do this with only an html by setting the html as the primary bitstream, but I want the pdf to be listed also. (I thought I saw this at someone's site, but can't find the example now.) Thank you, Sunny Pai University of Hawaii at Manoa - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Completed install but page cannot be displayed
Hi Peter, Something to try to see if tomcat really is running: What happens when you type: telnet localhost 8080 If you get a message something like 'connection refused' then it sounds like tomcat either isn't running, or is not listening on port 8080. Have you looked at 'ps' to see if it is listed as a running process? If the telnet command does work (you'll not see any output, just a blank prompt) try typing: GET / HTTP/1.0 And hit enter twice. Hopefully this will return some HTML (the tomcat homepage). This would show that tomcat is working. If tomcat is working, it might be that your server is firewalled from your computer running the browser. I don't know what a default Ubuntu firewall config looks like, but assuming they give you one, it is possible (likely) that a non-standard port such as 8080 is blocked by default, and you'll need to unblock it. Good luck! Stuart _ Gwasanaethau Gwybodaeth Information Services Prifysgol Aberystwyth Aberystwyth University E-bost / E-mail: [EMAIL PROTECTED] Ffon / Tel: (01970) 622860 _ On 15/10/07 23:33, Peter Urban [EMAIL PROTECTED] wrote: Thanks Christian. When I run http://ipaddress:8080, I get Internet Explorer cannot display the webpage. As best I can tell, Tomcat is running. I don't know much more about Tomcat to be able to troubleshoot further on my own. I get no errors when I start it using sudo /etc/init.d/tomcat5.5 start I installed Tomcat using Ubuntu's tomcat5.5 package. Initially, I had an error during installation * no JDK found - please set JAVA_HOME invoke-rc.d: initscript tomcat5.5, action start failed. dpkg: error processing tomcat5.5 (--configure): subprocess post-installation script returned error exit status 1 Errors were encountered while processing: tomcat5.5 E: Sub-process /usr/bin/dpkg returned an error code (1) Then, I realized that I had JRE (j2re1.4), not JDK, so I installed sun-java5-jdk package and reinstalled Tomcat. That seemed to work fine. I don't see a catalina.sh. I looked for it in /usr/local/tomcat, but I have no tomcat folder in local. Did I do the Tomcat installation wrong? On to your other questions... Yes ant-optional package is installed. When I copy the dspace*.war files to the webapps directory, they do not unpack. All I see are 2 war files, no dspace directory. Thanks for your help so far. -Peter -Original Message- From: Christian Voelker [mailto:[EMAIL PROTECTED] Sent: Monday, October 15, 2007 5:01 PM To: Peter Urban Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Completed install but page cannot be displayed Am 15.10.2007 um 21:39 schrieb Peter Urban: when we launch a browser and try to access the site usinng http:// ipaddress:8080/dspace, we get a 'page cannot be displayed' message. What do you get under http://ipaddress:8080 ? The Tomcat Homepage? So, is Tomcat actually running? If not, stick with this problem. Can you start it manually using catalina.sh? If this is not your issue, did you get any error msgs during your ant fresh-install? (ant-optional pkg is installed?). Does your automatic deployment work properly? So, if you drop your dspace.war into the webapps dir, does it get unpacked to a dspace subdir to the webapps dir? You are not yet at the point where the trouble with the database and the jdbc connector usually starts ;-) - no, sorry, I did not say that, I do not want you to shy away. There is really no reason to do so, just work through it step by step with getting tomcat up and running being the very first of them. Bye, Christian - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
