Re: [Dspace-tech] Problem with statistics
Hi Rev, the best way to explore whether the standard DSpace stats address your problems, is to experiment with them on http://demo.dspace.org Make sure you do your testing with the User interface you wish to use (subtle differences in the XML User interface and in the JSP user interface. Also, some more background information on the SOLR stats is available in Ben Bosman's presentation slides from last week: Slides http://bit.ly/bXCyFb and Whitepaper http://bit.ly/9QCwCg If you're still confronted with specific questions that aren't addressed by these materials or the DSpace documentation, please shoot. best regards, Bram Luyten @mire - http://www.atmire.com Technologielaan 9 - 3001 Heverlee - Belgium 533 2nd Street - Encinitas, CA 92024 - USA http://www.togather.eu - Before getting together, get t...@ther On Mon, Sep 27, 2010 at 4:05 AM, revskill revskil...@gmail.com wrote: Hi all , i'm new with dspace platform. My University 's using dspace version 5.2, and i have some questions: - The statistics features of this version of dspace is weak and it's hard for administrators to monitor some stats such as number of downloads of items, or top viewed items,... - How to upgrade from 5.2 to 6.x version ( rebuild index, set up the SOLR ) with minimal efforts - Does the SOLR features of 6.x version solves our problems in statistics as above ? I just don't know how much the SOLR can do for us. Can you show me some real world dspace projects with those stats features ? Really appreciate your help. Rev HPU ( Haiphong Private University of Vietnam ) -- Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech -- Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Problem with statistics
Hi all , i'm new with dspace platform. My University 's using dspace version 5.2, and i have some questions: - The statistics features of this version of dspace is weak and it's hard for administrators to monitor some stats such as number of downloads of items, or top viewed items,... - How to upgrade from 5.2 to 6.x version ( rebuild index, set up the SOLR ) with minimal efforts - Does the SOLR features of 6.x version solves our problems in statistics as above ? I just don't know how much the SOLR can do for us. Can you show me some real world dspace projects with those stats features ? Really appreciate your help. Rev HPU ( Haiphong Private University of Vietnam ) -- Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Problem with Statistics [SEC=UNCLASSIFIED]
UNCLASSIFIED Thankyou Stuart, Just to confirm, if what you say is happening all older stats other than what is being displayed have been lost. Regards, Hamish IMPORTANT: This email remains the property of the Australian Defence Organisation and is subject to the jurisdiction of section 70 of the Crimes Act 1914. If you have received this email in error, you are requested to contact the sender and delete the email. From: Stuart Lewis [mailto:s.le...@auckland.ac.nz] Sent: Thursday, 3 September 2009 3:21 PM To: Brett, Hamish Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Problem with Statistics [SEC=UNCLASSIFIED] Hi Brett, On 3/09/2009, at 4:34 PM, Brett, Hamish wrote: I am attempting to reconfigure our statistics. However when I run the required scripts I am not getting any stats older than 2 months ago. When I look in the .dat files in /dspace/log that have been generated they are almost except for the last 2 months empty even though a lot has occured for the last 3 years. I am pretty sure I have all the log files. I have only changed the date in the dstat.cfg file. An example of an empty dat file is below. Any advice for me I suspect what is happening is that your dspace.log.* files have rolled over their limit. In [dspace]/config/log4j.properties you can specify how many log files to keep, and how big each one can be before it rolls over. The default configuration is quite small (100 files at 1Mb each). So it sounds like you are getting through that many log files each 2 months. The problem with the stats module as it stands, is that despite creating .dat files for log files which have now rolled over and been lost, it recreates them all each time. This means you lose all the older stats. The easy short-term solution is to increase the size and/or number of log files that DSpace creates. The better solution would be for someone to look at making sure current .dat files are not overwritten by the stats system. However... the stat system is getting a complete rewrite in the upcoming 1.6 release, so a lot of people are waiting for that instead. I hope this helps, Stuart Lewis IT Innovations Analyst and Developer Te Tumu Herenga The University of Auckland Library Auckland Mail Centre, Private Bag 92019, Auckland 1142, New Zealand Ph: 64 9 373-7599 x81928 http://www.library.auckland.ac.nz/ -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Problem with Statistics [SEC=UNCLASSIFIED]
Hi Brett, I've not double-checked the behaviour recently, but I think the old reports (.html) files stay, so you can see older stats, but newer stats only contain data from the past few months rather than back to the inception of your installation. Thanks, Stuart Lewis IT Innovations Analyst and Developer Te Tumu Herenga The University of Auckland Library Auckland Mail Centre, Private Bag 92019, Auckland 1142, New Zealand Ph: 64 9 373-7599 x81928 http://www.library.auckland.ac.nz/ On 3/09/2009, at 6:34 PM, Brett, Hamish wrote: UNCLASSIFIED Thankyou Stuart, Just to confirm, if what you say is happening all older stats other than what is being displayed have been lost. Regards, Hamish IMPORTANT: This email remains the property of the Australian Defence Organisation and is subject to the jurisdiction of section 70 of the Crimes Act 1914. If you have received this email in error, you are requested to contact the sender and delete the email. From: Stuart Lewis [mailto:s.le...@auckland.ac.nz] Sent: Thursday, 3 September 2009 3:21 PM To: Brett, Hamish Cc: dspace-tech@lists.sourceforge.netmailto:dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Problem with Statistics [SEC=UNCLASSIFIED] Hi Brett, On 3/09/2009, at 4:34 PM, Brett, Hamish wrote: I am attempting to reconfigure our statistics. However when I run the required scripts I am not getting any stats older than 2 months ago. When I look in the .dat files in /dspace/log that have been generated they are almost except for the last 2 months empty even though a lot has occured for the last 3 years. I am pretty sure I have all the log files. I have only changed the date in the dstat.cfg file. An example of an empty dat file is below. Any advice for me I suspect what is happening is that your dspace.log.* files have rolled over their limit. In [dspace]/config/log4j.properties you can specify how many log files to keep, and how big each one can be before it rolls over. The default configuration is quite small (100 files at 1Mb each). So it sounds like you are getting through that many log files each 2 months. The problem with the stats module as it stands, is that despite creating .dat files for log files which have now rolled over and been lost, it recreates them all each time. This means you lose all the older stats. The easy short-term solution is to increase the size and/or number of log files that DSpace creates. The better solution would be for someone to look at making sure current .dat files are not overwritten by the stats system. However... the stat system is getting a complete rewrite in the upcoming 1.6 release, so a lot of people are waiting for that instead. I hope this helps, Stuart Lewis IT Innovations Analyst and Developer Te Tumu Herenga The University of Auckland Library Auckland Mail Centre, Private Bag 92019, Auckland 1142, New Zealand Ph: 64 9 373-7599 x81928 http://www.library.auckland.ac.nz/ -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Problem with Statistics [SEC=UNCLASSIFIED]
UNCLASSIFIED Thanks again Stuart, Problem being I overwrote those old html files trying to get it going. Oh well. Hamish IMPORTANT: This email remains the property of the Australian Defence Organisation and is subject to the jurisdiction of section 70 of the Crimes Act 1914. If you have received this email in error, you are requested to contact the sender and delete the email. From: Stuart Lewis [mailto:s.le...@auckland.ac.nz] Sent: Thursday, 3 September 2009 6:54 PM To: Brett, Hamish Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Problem with Statistics [SEC=UNCLASSIFIED] Hi Brett, I've not double-checked the behaviour recently, but I think the old reports (.html) files stay, so you can see older stats, but newer stats only contain data from the past few months rather than back to the inception of your installation. Thanks, Stuart Lewis IT Innovations Analyst and Developer Te Tumu Herenga The University of Auckland Library Auckland Mail Centre, Private Bag 92019, Auckland 1142, New Zealand Ph: 64 9 373-7599 x81928 http://www.library.auckland.ac.nz/ On 3/09/2009, at 6:34 PM, Brett, Hamish wrote: UNCLASSIFIED Thankyou Stuart, Just to confirm, if what you say is happening all older stats other than what is being displayed have been lost. Regards, Hamish IMPORTANT: This email remains the property of the Australian Defence Organisation and is subject to the jurisdiction of section 70 of the Crimes Act 1914. If you have received this email in error, you are requested to contact the sender and delete the email. From: Stuart Lewis [mailto:s.le...@auckland.ac.nz] Sent: Thursday, 3 September 2009 3:21 PM To: Brett, Hamish Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Problem with Statistics [SEC=UNCLASSIFIED] Hi Brett, On 3/09/2009, at 4:34 PM, Brett, Hamish wrote: I am attempting to reconfigure our statistics. However when I run the required scripts I am not getting any stats older than 2 months ago. When I look in the .dat files in /dspace/log that have been generated they are almost except for the last 2 months empty even though a lot has occured for the last 3 years. I am pretty sure I have all the log files. I have only changed the date in the dstat.cfg file. An example of an empty dat file is below. Any advice for me I suspect what is happening is that your dspace.log.* files have rolled over their limit. In [dspace]/config/log4j.properties you can specify how many log files to keep, and how big each one can be before it rolls over. The default configuration is quite small (100 files at 1Mb each). So it sounds like you are getting through that many log files each 2 months. The problem with the stats module as it stands, is that despite creating .dat files for log files which have now rolled over and been lost, it recreates them all each time. This means you lose all the older stats. The easy short-term solution is to increase the size and/or number of log files that DSpace creates. The better solution would be for someone to look at making sure current .dat files are not overwritten by the stats system. However... the stat system is getting a complete rewrite in the upcoming 1.6 release, so a lot of people are waiting for that instead. I hope this helps, Stuart Lewis IT Innovations Analyst and Developer Te Tumu Herenga The University of Auckland Library Auckland Mail Centre, Private Bag 92019, Auckland 1142, New Zealand Ph: 64 9 373-7599 x81928 http://www.library.auckland.ac.nz/ -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Problem with Statistics [SEC=UNCLASSIFIED]
UNCLASSIFIED Hi I am attempting to reconfigure our statistics. However when I run the required scripts I am not getting any stats older than 2 months ago. When I look in the .dat files in /dspace/log that have been generated they are almost except for the last 2 months empty even though a lot has occured for the last 3 years. I am pretty sure I have all the log files. I have only changed the date in the dstat.cfg file. An example of an empty dat file is below. Any advice for me Thanks Hamish log_lines=0 warnings=0 general_summary=archive_item general_summary=view_bitstream general_summary=view_item general_summary=view_collection general_summary=view_community general_summary=login general_summary=search general_summary=reject_licence general_summary=oai_request server_name=dspace-dsto.dsto.defence.gov.au service_name=DSTO Publications Online start_date=01/11/2007 end_date=30/11/2007 archive.Preprint=0 archive.Thesis or Dissertation=0 archive.All Items=78 archive.Research Paper=0 action.archive_item=0 action.search=0 action.view_bitstream=0 action.view_collection=0 action.view_community=0 action.oai_request=0 action.reject_licence=0 action.login=0 action.view_item=0 user_email=alias search_floor=5 item_floor=20 host_url=http://dspace-dsto.dsto.defence.gov.au/dspace/ item_lookup=10 analysis_process_time=0 IMPORTANT: This email remains the property of the Australian Defence Organisation and is subject to the jurisdiction of section 70 of the Crimes Act 1914. If you have received this email in error, you are requested to contact the sender and delete the email. -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Problem with Statistics [SEC=UNCLASSIFIED]
Hi Brett, On 3/09/2009, at 4:34 PM, Brett, Hamish wrote: I am attempting to reconfigure our statistics. However when I run the required scripts I am not getting any stats older than 2 months ago. When I look in the .dat files in /dspace/log that have been generated they are almost except for the last 2 months empty even though a lot has occured for the last 3 years. I am pretty sure I have all the log files. I have only changed the date in the dstat.cfg file. An example of an empty dat file is below. Any advice for me I suspect what is happening is that your dspace.log.* files have rolled over their limit. In [dspace]/config/log4j.properties you can specify how many log files to keep, and how big each one can be before it rolls over. The default configuration is quite small (100 files at 1Mb each). So it sounds like you are getting through that many log files each 2 months. The problem with the stats module as it stands, is that despite creating .dat files for log files which have now rolled over and been lost, it recreates them all each time. This means you lose all the older stats. The easy short-term solution is to increase the size and/or number of log files that DSpace creates. The better solution would be for someone to look at making sure current .dat files are not overwritten by the stats system. However... the stat system is getting a complete rewrite in the upcoming 1.6 release, so a lot of people are waiting for that instead. I hope this helps, Stuart Lewis IT Innovations Analyst and Developer Te Tumu Herenga The University of Auckland Library Auckland Mail Centre, Private Bag 92019, Auckland 1142, New Zealand Ph: 64 9 373-7599 x81928 http://www.library.auckland.ac.nz/ -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] problem initializing statistics v 1.5.1
Thank you Claudia, I'll see if I can find a new jar file. Snowy greetings Stephen -Original Message- From: Claudia Jürgen [mailto:[EMAIL PROTECTED] Sent: November 19, 2008 2:49 AM To: Stephen Wilkinson Subject: Re: [Dspace-tech] problem initializing statistics v 1.5.1 Hi Stephen, as you're not using the source release, these classes are in the dspace-api jar pulled from the repository. Sunny greetings Claudia Stephen Wilkinson schrieb: Hi Claudia thanks ever so much for trying, I don't seem to have the same directory structure as you at all. I have [dspace-source]/dspace (no dspace-api) there is a src/main under that but all it contains is/config/build.xml; Lots of other */src/main/ as well but I don't see the files anywhere. I've attached the directory listing I have if you're interested, they wouldn't be in .jar files would they? Thanks again Stephen -Original Message- From: Claudia Jürgen [mailto:[EMAIL PROTECTED] Sent: November 18, 2008 11:38 AM To: Stephen Wilkinson Subject: Re: [Dspace-tech] problem initializing statistics v 1.5.1 Hi Stephen they are in [dspace-source]/dspace-api/src/main/java/org/dspace/app/statistics Claudia Stephen Wilkinson schrieb: Thanks Claudia, I seem to be having a problem finding these files, can you please tell me where they are located. -Original Message- From: Claudia Jürgen [mailto:[EMAIL PROTECTED] Sent: November 18, 2008 10:39 AM To: Stephen Wilkinson Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] problem initializing statistics v 1.5.1 Hi Stephen, the best thing would be to change org.dspace.app.statistics.CreateStatReport to use the report.dir instead of the log.dir for the output. This will work with both UI's. If you're only working with the XMLUI you might change org.dspace.app.statistics.StatisticsLoader to use the log.dir instead of the report.dir. Hope that helps Claudia Stephen Wilkinson schrieb: Hello all and thanks again, I created a dspace.log and checker.log right off of / And ran stat-initial again, this now completes without errors. Does anyone know if this will cause me grief latter on? I am using the xmlui interface. -Original Message- From: Claudia Jürgen [mailto:[EMAIL PROTECTED] Sent: November 18, 2008 2:54 AM To: Stephen Wilkinson Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] problem initializing statistics v 1.5.1 Hi Stephen, if you're using the xmlui you might be affected by this bug: http://sourceforge.net/tracker/index.php?func=detailaid=2137425group_id= 19984atid=119984 Hope that helps Claudia Jürgen Stephen Wilkinson schrieb: Hello all, I'm setting up a dspace server using v1.5.1, with tomcat and postgresql as the backend. Dspace seems to be functioning properly but I'm getting an error when trying to initialize the statistics. As the user dspace I tried to run [dspace]/bin/stat-initial; first I got a permission denied error which I fixed by making the files in the bin dir executable but I now get JAVA errors. I'd appreciate it If anyone can point me in the right direction (pretty new to both dspace and linux btw). The error I get is below where /apps/dspace is the install dir and dspace.log and checker.log which are mentioned in the error are in /apps/dspace/log. [EMAIL PROTECTED] ~]$ /apps/dspace/bin/stat-initial log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /dspace.log (Permission denied) at java.io.FileOutputStream.openAppend(Native Method) at java.io.FileOutputStream.init(FileOutputStream.java:177) at java.io.FileOutputStream.init(FileOutputStream.java:102) at org.apache.log4j.FileAppender.setFile(FileAppender.java:289) at org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:167) at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:163) at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:256) at org.apache.log4j.xml.DOMConfigurator.parseAppender(DOMConfigurator.java:22 0) at org.apache.log4j.xml.DOMConfigurator.findAppenderByName(DOMConfigurator.ja va:150) at org.apache.log4j.xml.DOMConfigurator.findAppenderByReference(DOMConfigurat or.java:163) at org.apache.log4j.xml.DOMConfigurator.parseChildrenOfLoggerElement(DOMConfi gurator.java:425) at org.apache.log4j.xml.DOMConfigurator.parseRoot(DOMConfigurator.java:394) at org.apache.log4j.xml.DOMConfigurator.parse(DOMConfigurator.java:829) at org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:712) at org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:618) at org.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverte r.java:470) at org.apache.log4j.LogManager.clinit(LogManager.java
Re: [Dspace-tech] problem initializing statistics v 1.5.1
Thanks Claudia I am using xmlui Stephen - Original Message - From: Claudia Jürgen [EMAIL PROTECTED] To: Stephen Wilkinson [EMAIL PROTECTED] Cc: dspace-tech@lists.sourceforge.net dspace-tech@lists.sourceforge.net Sent: Tue Nov 18 02:53:49 2008 Subject: Re: [Dspace-tech] problem initializing statistics v 1.5.1 Hi Stephen, if you're using the xmlui you might be affected by this bug: http://sourceforge.net/tracker/index.php?func=detailaid=2137425group_id=19984atid=119984 Hope that helps Claudia Jürgen Stephen Wilkinson schrieb: Hello all, I'm setting up a dspace server using v1.5.1, with tomcat and postgresql as the backend. Dspace seems to be functioning properly but I'm getting an error when trying to initialize the statistics. As the user dspace I tried to run [dspace]/bin/stat-initial; first I got a permission denied error which I fixed by making the files in the bin dir executable but I now get JAVA errors. I'd appreciate it If anyone can point me in the right direction (pretty new to both dspace and linux btw). The error I get is below where /apps/dspace is the install dir and dspace.log and checker.log which are mentioned in the error are in /apps/dspace/log. [EMAIL PROTECTED] ~]$ /apps/dspace/bin/stat-initial log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /dspace.log (Permission denied) at java.io.FileOutputStream.openAppend(Native Method) at java.io.FileOutputStream.init(FileOutputStream.java:177) at java.io.FileOutputStream.init(FileOutputStream.java:102) at org.apache.log4j.FileAppender.setFile(FileAppender.java:289) at org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:167) at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:163) at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:256) at org.apache.log4j.xml.DOMConfigurator.parseAppender(DOMConfigurator.java:22 0) at org.apache.log4j.xml.DOMConfigurator.findAppenderByName(DOMConfigurator.ja va:150) at org.apache.log4j.xml.DOMConfigurator.findAppenderByReference(DOMConfigurat or.java:163) at org.apache.log4j.xml.DOMConfigurator.parseChildrenOfLoggerElement(DOMConfi gurator.java:425) at org.apache.log4j.xml.DOMConfigurator.parseRoot(DOMConfigurator.java:394) at org.apache.log4j.xml.DOMConfigurator.parse(DOMConfigurator.java:829) at org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:712) at org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:618) at org.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverte r.java:470) at org.apache.log4j.LogManager.clinit(LogManager.java:122) at org.apache.log4j.Logger.getLogger(Logger.java:117) at org.dspace.core.ConfigurationManager.clinit(ConfigurationManager.java:88 ) at org.dspace.app.statistics.CreateStatReport.clinit(CreateStatReport.java: 90) log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /dspace.log (Permission denied) at java.io.FileOutputStream.openAppend(Native Method) at java.io.FileOutputStream.init(FileOutputStream.java:177) at java.io.FileOutputStream.init(FileOutputStream.java:102) at org.apache.log4j.FileAppender.setFile(FileAppender.java:289) at org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:167) at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:163) at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:256) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:1 32) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:9 6) at org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.j ava:654) at org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.j ava:612) at org.apache.log4j.PropertyConfigurator.configureRootCategory(PropertyConfig urator.java:509) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.jav a:415) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.jav a:441) at org.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverte r.java:470) at org.dspace.core.ConfigurationManager.loadConfig(ConfigurationManager.java: 703) at org.dspace.core.ConfigurationManager.getProperty(ConfigurationManager.java :135) at org.dspace.app.statistics.CreateStatReport.clinit(CreateStatReport.java: 90) log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /checker.log (Permission denied) at java.io.FileOutputStream.openAppend(Native Method
Re: [Dspace-tech] problem initializing statistics v 1.5.1
Hello all and thanks again, I created a dspace.log and checker.log right off of / And ran stat-initial again, this now completes without errors. Does anyone know if this will cause me grief latter on? I am using the xmlui interface. -Original Message- From: Claudia Jürgen [mailto:[EMAIL PROTECTED] Sent: November 18, 2008 2:54 AM To: Stephen Wilkinson Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] problem initializing statistics v 1.5.1 Hi Stephen, if you're using the xmlui you might be affected by this bug: http://sourceforge.net/tracker/index.php?func=detailaid=2137425group_id= 19984atid=119984 Hope that helps Claudia Jürgen Stephen Wilkinson schrieb: Hello all, I'm setting up a dspace server using v1.5.1, with tomcat and postgresql as the backend. Dspace seems to be functioning properly but I'm getting an error when trying to initialize the statistics. As the user dspace I tried to run [dspace]/bin/stat-initial; first I got a permission denied error which I fixed by making the files in the bin dir executable but I now get JAVA errors. I'd appreciate it If anyone can point me in the right direction (pretty new to both dspace and linux btw). The error I get is below where /apps/dspace is the install dir and dspace.log and checker.log which are mentioned in the error are in /apps/dspace/log. [EMAIL PROTECTED] ~]$ /apps/dspace/bin/stat-initial log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /dspace.log (Permission denied) at java.io.FileOutputStream.openAppend(Native Method) at java.io.FileOutputStream.init(FileOutputStream.java:177) at java.io.FileOutputStream.init(FileOutputStream.java:102) at org.apache.log4j.FileAppender.setFile(FileAppender.java:289) at org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:167) at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:163) at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:256) at org.apache.log4j.xml.DOMConfigurator.parseAppender(DOMConfigurator.java:22 0) at org.apache.log4j.xml.DOMConfigurator.findAppenderByName(DOMConfigurator.ja va:150) at org.apache.log4j.xml.DOMConfigurator.findAppenderByReference(DOMConfigurat or.java:163) at org.apache.log4j.xml.DOMConfigurator.parseChildrenOfLoggerElement(DOMConfi gurator.java:425) at org.apache.log4j.xml.DOMConfigurator.parseRoot(DOMConfigurator.java:394) at org.apache.log4j.xml.DOMConfigurator.parse(DOMConfigurator.java:829) at org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:712) at org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:618) at org.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverte r.java:470) at org.apache.log4j.LogManager.clinit(LogManager.java:122) at org.apache.log4j.Logger.getLogger(Logger.java:117) at org.dspace.core.ConfigurationManager.clinit(ConfigurationManager.java:88 ) at org.dspace.app.statistics.CreateStatReport.clinit(CreateStatReport.java: 90) log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /dspace.log (Permission denied) at java.io.FileOutputStream.openAppend(Native Method) at java.io.FileOutputStream.init(FileOutputStream.java:177) at java.io.FileOutputStream.init(FileOutputStream.java:102) at org.apache.log4j.FileAppender.setFile(FileAppender.java:289) at org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:167) at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:163) at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:256) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:1 32) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:9 6) at org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.j ava:654) at org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.j ava:612) at org.apache.log4j.PropertyConfigurator.configureRootCategory(PropertyConfig urator.java:509) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.jav a:415) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.jav a:441) at org.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverte r.java:470) at org.dspace.core.ConfigurationManager.loadConfig(ConfigurationManager.java: 703) at org.dspace.core.ConfigurationManager.getProperty(ConfigurationManager.java :135) at org.dspace.app.statistics.CreateStatReport.clinit(CreateStatReport.java: 90) log4j:ERROR setFile(null,true) call
[Dspace-tech] problem initializing statistics v 1.5.1
Hello all, I'm setting up a dspace server using v1.5.1, with tomcat and postgresql as the backend. Dspace seems to be functioning properly but I'm getting an error when trying to initialize the statistics. As the user dspace I tried to run [dspace]/bin/stat-initial; first I got a permission denied error which I fixed by making the files in the bin dir executable but I now get JAVA errors. I'd appreciate it If anyone can point me in the right direction (pretty new to both dspace and linux btw). The error I get is below where /apps/dspace is the install dir and dspace.log and checker.log which are mentioned in the error are in /apps/dspace/log. [EMAIL PROTECTED] ~]$ /apps/dspace/bin/stat-initial log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /dspace.log (Permission denied) at java.io.FileOutputStream.openAppend(Native Method) at java.io.FileOutputStream.init(FileOutputStream.java:177) at java.io.FileOutputStream.init(FileOutputStream.java:102) at org.apache.log4j.FileAppender.setFile(FileAppender.java:289) at org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:167) at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:163) at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:256) at org.apache.log4j.xml.DOMConfigurator.parseAppender(DOMConfigurator.java:22 0) at org.apache.log4j.xml.DOMConfigurator.findAppenderByName(DOMConfigurator.ja va:150) at org.apache.log4j.xml.DOMConfigurator.findAppenderByReference(DOMConfigurat or.java:163) at org.apache.log4j.xml.DOMConfigurator.parseChildrenOfLoggerElement(DOMConfi gurator.java:425) at org.apache.log4j.xml.DOMConfigurator.parseRoot(DOMConfigurator.java:394) at org.apache.log4j.xml.DOMConfigurator.parse(DOMConfigurator.java:829) at org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:712) at org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:618) at org.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverte r.java:470) at org.apache.log4j.LogManager.clinit(LogManager.java:122) at org.apache.log4j.Logger.getLogger(Logger.java:117) at org.dspace.core.ConfigurationManager.clinit(ConfigurationManager.java:88 ) at org.dspace.app.statistics.CreateStatReport.clinit(CreateStatReport.java: 90) log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /dspace.log (Permission denied) at java.io.FileOutputStream.openAppend(Native Method) at java.io.FileOutputStream.init(FileOutputStream.java:177) at java.io.FileOutputStream.init(FileOutputStream.java:102) at org.apache.log4j.FileAppender.setFile(FileAppender.java:289) at org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:167) at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:163) at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:256) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:1 32) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:9 6) at org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.j ava:654) at org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.j ava:612) at org.apache.log4j.PropertyConfigurator.configureRootCategory(PropertyConfig urator.java:509) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.jav a:415) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.jav a:441) at org.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverte r.java:470) at org.dspace.core.ConfigurationManager.loadConfig(ConfigurationManager.java: 703) at org.dspace.core.ConfigurationManager.getProperty(ConfigurationManager.java :135) at org.dspace.app.statistics.CreateStatReport.clinit(CreateStatReport.java: 90) log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /checker.log (Permission denied) at java.io.FileOutputStream.openAppend(Native Method) at java.io.FileOutputStream.init(FileOutputStream.java:177) at java.io.FileOutputStream.init(FileOutputStream.java:102) at org.apache.log4j.FileAppender.setFile(FileAppender.java:289) at org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:167) at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:163) at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:256) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:1 32) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:9 6) at
Re: [Dspace-tech] problem initializing statistics v 1.5.1
Hi Kim and thank you,
From dspace.cfg
dspace.dir=/apps/dspace
Log.dir = ${dspace.dir)/log (the default)
And all files in /apps/dspace are owned by dspace:dspace which I think is
the tomcat user as well (I know that dspace is the owner of the complete
tomcat directory as well).
I believe that answers most of what you asked.
I guess I can try hard-coding the log dir instead of relying on a variable.
Thanks again
From: Kim Shepherd [mailto:[EMAIL PROTECTED]
Sent: November 17, 2008 4:46 PM
To: Stephen Wilkinson
Subject: RE: [Dspace-tech] problem initializing statistics v 1.5.1
Hi Stephen,
Have a look at [dspace]/config/dspace.cfg and make sure that log.dir is set
to the right path (I think the default should be ${dspace.dir)/log, and that
your tomcat/dspace user has access to write to it.
It looks as though it’s searching for /dspace.log instead of
/apps/dspace/log/dspace.log
I have a feeling that log4j.properties has your log directory correct, but
dspace.cfg doesn’t.
Cheers,
Kim
From: Stephen Wilkinson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 18 November 2008 10:06 a.m.
To: dspace-tech@lists.sourceforge.net
Subject: [Dspace-tech] problem initializing statistics v 1.5.1
Hello all, I’m setting up a dspace server using v1.5.1, with tomcat and
postgresql as the backend.
Dspace seems to be functioning properly but I’m getting an error when trying
to initialize the statistics.
As the user dspace I tried to run [dspace]/bin/stat-initial; first I got a
permission denied error which I fixed by making the files in the bin dir
executable but I now get JAVA errors. I’d appreciate it If anyone can point
me in the right direction (pretty new to both dspace and linux btw).
The error I get is below where /apps/dspace is the install dir and
dspace.log and checker.log which are mentioned in the error are in
/apps/dspace/log.
[EMAIL PROTECTED] ~]$ /apps/dspace/bin/stat-initial
log4j:ERROR setFile(null,true) call failed.
java.io.FileNotFoundException: /dspace.log (Permission denied)
at java.io.FileOutputStream.openAppend(Native Method)
at java.io.FileOutputStream.init(FileOutputStream.java:177)
at java.io.FileOutputStream.init(FileOutputStream.java:102)
at org.apache.log4j.FileAppender.setFile(FileAppender.java:289)
at
org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:167)
at
org.apache.log4j.FileAppender.activateOptions(FileAppender.java:163)
at
org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:256)
at
org.apache.log4j.xml.DOMConfigurator.parseAppender(DOMConfigurator.java:220)
at
org.apache.log4j.xml.DOMConfigurator.findAppenderByName(DOMConfigurator.java:150)
at
org.apache.log4j.xml.DOMConfigurator.findAppenderByReference(DOMConfigurator.java:163)
at
org.apache.log4j.xml.DOMConfigurator.parseChildrenOfLoggerElement(DOMConfigurator.java:425)
at
org.apache.log4j.xml.DOMConfigurator.parseRoot(DOMConfigurator.java:394)
at
org.apache.log4j.xml.DOMConfigurator.parse(DOMConfigurator.java:829)
at
org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:712)
at
org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:618)
at
org.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverter.java:470)
at org.apache.log4j.LogManager.clinit(LogManager.java:122)
at org.apache.log4j.Logger.getLogger(Logger.java:117)
at
org.dspace.core.ConfigurationManager.clinit(ConfigurationManager.java:88)
at
org.dspace.app.statistics.CreateStatReport.clinit(CreateStatReport.java:90)
log4j:ERROR setFile(null,true) call failed.
java.io.FileNotFoundException: /dspace.log (Permission denied)
at java.io.FileOutputStream.openAppend(Native Method)
at java.io.FileOutputStream.init(FileOutputStream.java:177)
at java.io.FileOutputStream.init(FileOutputStream.java:102)
at org.apache.log4j.FileAppender.setFile(FileAppender.java:289)
at
org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:167)
at
org.apache.log4j.FileAppender.activateOptions(FileAppender.java:163)
at
org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:256)
at
org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:132)
at
org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:96)
at
org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.java:654)
at
org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.java:612)
at
org.apache.log4j.PropertyConfigurator.configureRootCategory(PropertyConfigurator.java:509)
at
org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:415
Re: [Dspace-tech] problem initializing statistics v 1.5.1
Hi Stephen, perhaps check [dspace]/config/log4j.properties then. I presume logs
are being written correctly?
From: Stephen Wilkinson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 18 November 2008 11:05 a.m.
To: Kim Shepherd
Cc: dspace-tech@lists.sourceforge.net
Subject: RE: [Dspace-tech] problem initializing statistics v 1.5.1
Hi Kim and thank you,
From dspace.cfg
dspace.dir=/apps/dspace
Log.dir = ${dspace.dir)/log (the default)
And all files in /apps/dspace are owned by dspace:dspace which I think is the
tomcat user as well (I know that dspace is the owner of the complete tomcat
directory as well).
I believe that answers most of what you asked.
I guess I can try hard-coding the log dir instead of relying on a variable.
Thanks again
From: Kim Shepherd [mailto:[EMAIL PROTECTED]
Sent: November 17, 2008 4:46 PM
To: Stephen Wilkinson
Subject: RE: [Dspace-tech] problem initializing statistics v 1.5.1
Hi Stephen,
Have a look at [dspace]/config/dspace.cfg and make sure that log.dir is set to
the right path (I think the default should be ${dspace.dir)/log, and that your
tomcat/dspace user has access to write to it.
It looks as though it’s searching for /dspace.log instead of
/apps/dspace/log/dspace.log
I have a feeling that log4j.properties has your log directory correct, but
dspace.cfg doesn’t.
Cheers,
Kim
From: Stephen Wilkinson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 18 November 2008 10:06 a.m.
To: dspace-tech@lists.sourceforge.net
Subject: [Dspace-tech] problem initializing statistics v 1.5.1
Hello all, I’m setting up a dspace server using v1.5.1, with tomcat and
postgresql as the backend.
Dspace seems to be functioning properly but I’m getting an error when trying to
initialize the statistics.
As the user dspace I tried to run [dspace]/bin/stat-initial; first I got a
permission denied error which I fixed by making the files in the bin dir
executable but I now get JAVA errors. I’d appreciate it If anyone can point me
in the right direction (pretty new to both dspace and linux btw).
The error I get is below where /apps/dspace is the install dir and dspace.log
and checker.log which are mentioned in the error are in /apps/dspace/log.
[EMAIL PROTECTED] ~]$ /apps/dspace/bin/stat-initial
log4j:ERROR setFile(null,true) call failed.
java.io.FileNotFoundException: /dspace.log (Permission denied)
at java.io.FileOutputStream.openAppend(Native Method)
at java.io.FileOutputStream.init(FileOutputStream.java:177)
at java.io.FileOutputStream.init(FileOutputStream.java:102)
at org.apache.log4j.FileAppender.setFile(FileAppender.java:289)
at
org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:167)
at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:163)
at
org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:256)
at
org.apache.log4j.xml.DOMConfigurator.parseAppender(DOMConfigurator.java:220)
at
org.apache.log4j.xml.DOMConfigurator.findAppenderByName(DOMConfigurator.java:150)
at
org.apache.log4j.xml.DOMConfigurator.findAppenderByReference(DOMConfigurator.java:163)
at
org.apache.log4j.xml.DOMConfigurator.parseChildrenOfLoggerElement(DOMConfigurator.java:425)
at
org.apache.log4j.xml.DOMConfigurator.parseRoot(DOMConfigurator.java:394)
at org.apache.log4j.xml.DOMConfigurator.parse(DOMConfigurator.java:829)
at
org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:712)
at
org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:618)
at
org.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverter.java:470)
at org.apache.log4j.LogManager.clinit(LogManager.java:122)
at org.apache.log4j.Logger.getLogger(Logger.java:117)
at
org.dspace.core.ConfigurationManager.clinit(ConfigurationManager.java:88)
at
org.dspace.app.statistics.CreateStatReport.clinit(CreateStatReport.java:90)
log4j:ERROR setFile(null,true) call failed.
java.io.FileNotFoundException: /dspace.log (Permission denied)
at java.io.FileOutputStream.openAppend(Native Method)
at java.io.FileOutputStream.init(FileOutputStream.java:177)
at java.io.FileOutputStream.init(FileOutputStream.java:102)
at org.apache.log4j.FileAppender.setFile(FileAppender.java:289)
at
org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:167)
at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:163)
at
org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:256)
at
org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:132)
at
org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:96)
at
org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.java:654
Re: [Dspace-tech] problem initializing statistics v 1.5.1
Hi Kim that's a tougher file to read but it is the one created by the build
I've never edited it nor the template it says to edit. I'll look more deeply
at it in the am
dspace.log seems to be updating properly.
Thanks again
Stephen
_
From: Kim Shepherd
To: Stephen Wilkinson
Cc: dspace-tech@lists.sourceforge.net
Sent: Mon Nov 17 17:09:50 2008
Subject: RE: [Dspace-tech] problem initializing statistics v 1.5.1
Hi Stephen, perhaps check [dspace]/config/log4j.properties then. I presume
logs are being written correctly?
From: Stephen Wilkinson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 18 November 2008 11:05 a.m.
To: Kim Shepherd
Cc: dspace-tech@lists.sourceforge.net
Subject: RE: [Dspace-tech] problem initializing statistics v 1.5.1
Hi Kim and thank you,
From dspace.cfg
dspace.dir=/apps/dspace
Log.dir = ${dspace.dir)/log (the default)
And all files in /apps/dspace are owned by dspace:dspace which I think is
the tomcat user as well (I know that dspace is the owner of the complete
tomcat directory as well).
I believe that answers most of what you asked.
I guess I can try hard-coding the log dir instead of relying on a variable.
Thanks again
From: Kim Shepherd [mailto:[EMAIL PROTECTED]
Sent: November 17, 2008 4:46 PM
To: Stephen Wilkinson
Subject: RE: [Dspace-tech] problem initializing statistics v 1.5.1
Hi Stephen,
Have a look at [dspace]/config/dspace.cfg and make sure that log.dir is set
to the right path (I think the default should be ${dspace.dir)/log, and that
your tomcat/dspace user has access to write to it.
It looks as though it’s searching for /dspace.log instead of
/apps/dspace/log/dspace.log
I have a feeling that log4j.properties has your log directory correct, but
dspace.cfg doesn’t.
Cheers,
Kim
From: Stephen Wilkinson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 18 November 2008 10:06 a.m.
To: dspace-tech@lists.sourceforge.net
Subject: [Dspace-tech] problem initializing statistics v 1.5.1
Hello all, I’m setting up a dspace server using v1.5.1, with tomcat and
postgresql as the backend.
Dspace seems to be functioning properly but I’m getting an error when trying
to initialize the statistics.
As the user dspace I tried to run [dspace]/bin/stat-initial; first I got a
permission denied error which I fixed by making the files in the bin dir
executable but I now get JAVA errors. I’d appreciate it If anyone can point
me in the right direction (pretty new to both dspace and linux btw).
The error I get is below where /apps/dspace is the install dir and
dspace.log and checker.log which are mentioned in the error are in
/apps/dspace/log.
[EMAIL PROTECTED] ~]$ /apps/dspace/bin/stat-initial
log4j:ERROR setFile(null,true) call failed.
java.io.FileNotFoundException: /dspace.log (Permission denied)
at java.io.FileOutputStream.openAppend(Native Method)
at java.io.FileOutputStream.init(FileOutputStream.java:177)
at java.io.FileOutputStream.init(FileOutputStream.java:102)
at org.apache.log4j.FileAppender.setFile(FileAppender.java:289)
at
org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:167)
at
org.apache.log4j.FileAppender.activateOptions(FileAppender.java:163)
at
org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:256)
at
org.apache.log4j.xml.DOMConfigurator.parseAppender(DOMConfigurator.java:220)
at
org.apache.log4j.xml.DOMConfigurator.findAppenderByName(DOMConfigurator.java:150)
at
org.apache.log4j.xml.DOMConfigurator.findAppenderByReference(DOMConfigurator.java:163)
at
org.apache.log4j.xml.DOMConfigurator.parseChildrenOfLoggerElement(DOMConfigurator.java:425)
at
org.apache.log4j.xml.DOMConfigurator.parseRoot(DOMConfigurator.java:394)
at
org.apache.log4j.xml.DOMConfigurator.parse(DOMConfigurator.java:829)
at
org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:712)
at
org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:618)
at
org.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverter.java:470)
at org.apache.log4j.LogManager.clinit(LogManager.java:122)
at org.apache.log4j.Logger.getLogger(Logger.java:117)
at
org.dspace.core.ConfigurationManager.clinit(ConfigurationManager.java:88)
at
org.dspace.app.statistics.CreateStatReport.clinit(CreateStatReport.java:90)
log4j:ERROR setFile(null,true) call failed.
java.io.FileNotFoundException: /dspace.log (Permission denied)
at java.io.FileOutputStream.openAppend(Native Method)
at java.io.FileOutputStream.init(FileOutputStream.java:177)
at java.io.FileOutputStream.init(FileOutputStream.java:102)
at org.apache.log4j.FileAppender.setFile(FileAppender.java:289)
at
org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:167
Re: [Dspace-tech] problem initializing statistics v 1.5.1
Hi Stephen, if you're using the xmlui you might be affected by this bug: http://sourceforge.net/tracker/index.php?func=detailaid=2137425group_id=19984atid=119984 Hope that helps Claudia Jürgen Stephen Wilkinson schrieb: Hello all, I'm setting up a dspace server using v1.5.1, with tomcat and postgresql as the backend. Dspace seems to be functioning properly but I'm getting an error when trying to initialize the statistics. As the user dspace I tried to run [dspace]/bin/stat-initial; first I got a permission denied error which I fixed by making the files in the bin dir executable but I now get JAVA errors. I'd appreciate it If anyone can point me in the right direction (pretty new to both dspace and linux btw). The error I get is below where /apps/dspace is the install dir and dspace.log and checker.log which are mentioned in the error are in /apps/dspace/log. [EMAIL PROTECTED] ~]$ /apps/dspace/bin/stat-initial log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /dspace.log (Permission denied) at java.io.FileOutputStream.openAppend(Native Method) at java.io.FileOutputStream.init(FileOutputStream.java:177) at java.io.FileOutputStream.init(FileOutputStream.java:102) at org.apache.log4j.FileAppender.setFile(FileAppender.java:289) at org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:167) at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:163) at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:256) at org.apache.log4j.xml.DOMConfigurator.parseAppender(DOMConfigurator.java:22 0) at org.apache.log4j.xml.DOMConfigurator.findAppenderByName(DOMConfigurator.ja va:150) at org.apache.log4j.xml.DOMConfigurator.findAppenderByReference(DOMConfigurat or.java:163) at org.apache.log4j.xml.DOMConfigurator.parseChildrenOfLoggerElement(DOMConfi gurator.java:425) at org.apache.log4j.xml.DOMConfigurator.parseRoot(DOMConfigurator.java:394) at org.apache.log4j.xml.DOMConfigurator.parse(DOMConfigurator.java:829) at org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:712) at org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java:618) at org.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverte r.java:470) at org.apache.log4j.LogManager.clinit(LogManager.java:122) at org.apache.log4j.Logger.getLogger(Logger.java:117) at org.dspace.core.ConfigurationManager.clinit(ConfigurationManager.java:88 ) at org.dspace.app.statistics.CreateStatReport.clinit(CreateStatReport.java: 90) log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /dspace.log (Permission denied) at java.io.FileOutputStream.openAppend(Native Method) at java.io.FileOutputStream.init(FileOutputStream.java:177) at java.io.FileOutputStream.init(FileOutputStream.java:102) at org.apache.log4j.FileAppender.setFile(FileAppender.java:289) at org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:167) at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:163) at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:256) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:1 32) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:9 6) at org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.j ava:654) at org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.j ava:612) at org.apache.log4j.PropertyConfigurator.configureRootCategory(PropertyConfig urator.java:509) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.jav a:415) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.jav a:441) at org.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverte r.java:470) at org.dspace.core.ConfigurationManager.loadConfig(ConfigurationManager.java: 703) at org.dspace.core.ConfigurationManager.getProperty(ConfigurationManager.java :135) at org.dspace.app.statistics.CreateStatReport.clinit(CreateStatReport.java: 90) log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /checker.log (Permission denied) at java.io.FileOutputStream.openAppend(Native Method) at java.io.FileOutputStream.init(FileOutputStream.java:177) at java.io.FileOutputStream.init(FileOutputStream.java:102) at org.apache.log4j.FileAppender.setFile(FileAppender.java:289) at
[Dspace-tech] --- Problem with Statistics Add-on--
Hello, I've experienced some problems with the Statistics Add-On. The installation process was fairly straight, also thansk to the wiki instructions. But once installed the server started responding very slowly, and after two days even activities such as browsing and accessing the items resulted in an Internal Error. The RAM was alwasy monopolized by Postgres, and even restarting application was only a temporary solution. Moreover I discovered a 10GB Postgres log , caused by a continuos warning about a missing library, geoip.dat. The Add-On expects this library to be in the standard dpspace.dir path (/dspace), without using the actual one set in dpace.cfg, and I've still not found any information about how to set it. Anyway, even putting the library in the standard path and having therefore the warning issue solved, it would be very useful to have some some feedback before trying to reinstall the AddOn again and having the same problem. Of the Dspace installations with this Add-On, how many of you have experienced a similar problem? Probably this could be only an hardware issue and for running the Statistics Add-On there is need for a more performing machine. If it's like this then probably it would be very usueful to add some some server requirements in the wiki page. Rick -- Riccardo Fazio CASPUR - settore automazione biblioteche - tel: 0039 0644486084 add: Via dei Tizii 6/b, Roma email: [EMAIL PROTECTED] - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Problem with statistics
Hi, Well, the relevant part of this is the only thing that's not in English!! But the context is clear enough - it's having trouble parsing a valid date. Can you confirm that the start / end dates that you are passing to the script are of the form '-mm-dd'. If your input is valid, then you've got a problem with one of the metadata value fields. You'll need to check the text_value of all the dc.date.accessioned entries (probably metadata_field_id=11). It looks like the offending item is of the correct format (-mm-ddThh:mi:ssZ), but contains invalid data. G On Mon, 2007-09-10 at 08:49 +, Andrea Garrido Fernández wrote: Hi: I have a problem when I try to execute the perl scripts for generating statistics. When I try to run the LogAnalyser class with a start or end date, I have an error like this: java.sql.SQLException: ORA-01841: el valor (completo) del año debe estar entre -4713 y +, y no debe ser igual a 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:745) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1062) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:850) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3384) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) 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.processLogs(LogAnalyser.java:535) at org.dspace.app.statistics.LogAnalyser.main(LogAnalyser.java:327) -- I have tried many things, incluiding the solution given in this forum before, using the REGEXP_REPLACE , but I find it impossible because oracle don´t recognize this expression. Colud yo help me, please? I am a bit lost. Thanks, Andrea _ Dale rienda suelta a tu tiempo libre. Mil ideas para exprimir tu ocio con MSN Entretenimiento. http://entretenimiento.msn.es/ - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech This email has been scanned by Postini. For more information please visit http://www.postini.com - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Problem with statistics
Sorry, I have realized that the query that doesn't work is :
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-10-21', '-MM-dd') ) AND item_id IN ( SELECT item_id FROM
metadatavalue WHERE text_value LIKE '%Thesis or Dissertation%' AND
metadata_field_id = ( SELECT metadata_field_id FROM metadatafieldregistry
WHERE element = 'type' AND qualifier IS NULL) )
This query gives me error in dspace and in my sql+ worksheet.
Sorry and thank yoy very much,
Andrea Garrido
From: Graham Triggs [EMAIL PROTECTED]
To: Andrea Garrido Fernández [EMAIL PROTECTED]
CC: dspace-tech@lists.sourceforge.net
Subject: Re: [Dspace-tech] Problem with statistics
Date: Tue, 11 Sep 2007 09:42:50 +0100
Hi,
Well, the relevant part of this is the only thing that's not in
English!! But the context is clear enough - it's having trouble parsing
a valid date.
Can you confirm that the start / end dates that you are passing to the
script are of the form '-mm-dd'.
If your input is valid, then you've got a problem with one of the
metadata value fields. You'll need to check the text_value of all the
dc.date.accessioned entries (probably metadata_field_id=11). It looks
like the offending item is of the correct format (-mm-ddThh:mi:ssZ),
but contains invalid data.
G
On Mon, 2007-09-10 at 08:49 +, Andrea Garrido Fernández wrote:
Hi:
I have a problem when I try to execute the perl scripts for generating
statistics.
When I try to run the LogAnalyser class with a start or end date, I have
an
error like this:
java.sql.SQLException: ORA-01841: el valor (completo) del año debe
estar
entre -4713 y +, y no debe ser igual a 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:745)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1062)
at
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:850)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3384)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
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.processLogs(LogAnalyser.java:535)
at org.dspace.app.statistics.LogAnalyser.main(LogAnalyser.java:327)
--
I have tried many things, incluiding the solution given in this forum
before, using the REGEXP_REPLACE , but I find it impossible because
oracle
don´t recognize this expression.
Colud yo help me, please? I am a bit lost.
Thanks,
Andrea
_
Dale rienda suelta a tu tiempo libre. Mil ideas para exprimir tu ocio
con
MSN Entretenimiento. http://entretenimiento.msn.es/
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
This email has been scanned by Postini.
For more information please visit http://www.postini.com
_
Acepta el reto MSN Premium: Correos más divertidos con fotos y textos
increíbles en MSN
Re: [Dspace-tech] Problem with statistics
Andrea,
It looks like this is an optimizer issue in Oracle - ie. that it is
applying the TO_TIMESTAMP to all the records first, rather than just
those that match the metadata_field_id.
I've tried rewriting the query so that it uses an inline view to obtain
all the metadata records for the date accessioned field, and then apply
the TO_TIMESTAMP to that... but bizarrely that doesn't seem to be
working either.
For now, I suggest that you separate out:
SELECT metadata_field_id FROM metadatafieldregistry WHERE element =
'date' AND qualifier = 'accessioned'
As a distinct query, store the result in a variable, and then replace
the:
metadata_field_id = (
SELECT metadata_field_id FROM metadatafieldregistry WHERE element =
'date'
AND qualifier = 'accessioned')
with a ...metadata_field_id = + variable + ...
That should at least make it work. File a bug report, and add list a
reference to it under Bug Fixes / To Do here:
http://wiki.dspace.org/index.php/Next_Release_Status
and I'll address it properly for the 1.5 release when I check / add-in
the Oracle support.
G
On Tue, 2007-09-11 at 10:32 +, Andrea Garrido Fernández wrote:
Sorry, I have realized that the query that doesn't work is :
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-10-21', '-MM-dd') ) AND item_id IN ( SELECT item_id FROM
metadatavalue WHERE text_value LIKE '%Thesis or Dissertation%' AND
metadata_field_id = ( SELECT metadata_field_id FROM metadatafieldregistry
WHERE element = 'type' AND qualifier IS NULL) )
This query gives me error in dspace and in my sql+ worksheet.
Sorry and thank yoy very much,
Andrea Garrido
From: Graham Triggs [EMAIL PROTECTED]
To: Andrea Garrido Fernández [EMAIL PROTECTED]
CC: dspace-tech@lists.sourceforge.net
Subject: Re: [Dspace-tech] Problem with statistics
Date: Tue, 11 Sep 2007 09:42:50 +0100
Hi,
Well, the relevant part of this is the only thing that's not in
English!! But the context is clear enough - it's having trouble parsing
a valid date.
Can you confirm that the start / end dates that you are passing to the
script are of the form '-mm-dd'.
If your input is valid, then you've got a problem with one of the
metadata value fields. You'll need to check the text_value of all the
dc.date.accessioned entries (probably metadata_field_id=11). It looks
like the offending item is of the correct format (-mm-ddThh:mi:ssZ),
but contains invalid data.
G
On Mon, 2007-09-10 at 08:49 +, Andrea Garrido Fernández wrote:
Hi:
I have a problem when I try to execute the perl scripts for generating
statistics.
When I try to run the LogAnalyser class with a start or end date, I have
an
error like this:
java.sql.SQLException: ORA-01841: el valor (completo) del año debe
estar
entre -4713 y +, y no debe ser igual a 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:745)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1062)
at
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:850)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3384)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
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.processLogs(LogAnalyser.java:535)
at org.dspace.app.statistics.LogAnalyser.main(LogAnalyser.java
Re: [Dspace-tech] Problem with statistics
Thank you, I´ve solved it!
The problem was that in LogAnalyser.java there were two if clauses in a
wrong order, i.e, I changed
in the method public static Integer getNumItems(Context context, String
type) these if clauses:
if (type != null)
{
query.append( AND item_id IN ( +
typeQuery + ) );
}
if (startDate != null || endDate != null)
{
query.append( AND item_id IN ( +
dateQuery.toString() + ) );
}
This is the right order, before if (startDate != null || endDate != null)
{. was first, so when you ran the query it gave the error because it
was looking for in an empty set (or something similar).
Thank yoy very much for your help, I will fix it as a bug.
Best regards,
Andrea
From: Graham Triggs [EMAIL PROTECTED]
To: Andrea Garrido Fernández [EMAIL PROTECTED]
CC: dspace-tech@lists.sourceforge.net
Subject: Re: [Dspace-tech] Problem with statistics
Date: Tue, 11 Sep 2007 12:37:22 +0100
Andrea,
It looks like this is an optimizer issue in Oracle - ie. that it is
applying the TO_TIMESTAMP to all the records first, rather than just
those that match the metadata_field_id.
I've tried rewriting the query so that it uses an inline view to obtain
all the metadata records for the date accessioned field, and then apply
the TO_TIMESTAMP to that... but bizarrely that doesn't seem to be
working either.
For now, I suggest that you separate out:
SELECT metadata_field_id FROM metadatafieldregistry WHERE element =
'date' AND qualifier = 'accessioned'
As a distinct query, store the result in a variable, and then replace
the:
metadata_field_id = (
SELECT metadata_field_id FROM metadatafieldregistry WHERE element =
'date'
AND qualifier = 'accessioned')
with a ...metadata_field_id = + variable + ...
That should at least make it work. File a bug report, and add list a
reference to it under Bug Fixes / To Do here:
http://wiki.dspace.org/index.php/Next_Release_Status
and I'll address it properly for the 1.5 release when I check / add-in
the Oracle support.
G
On Tue, 2007-09-11 at 10:32 +, Andrea Garrido Fernández wrote:
Sorry, I have realized that the query that doesn't work is :
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-10-21', '-MM-dd') ) AND item_id IN ( SELECT item_id
FROM
metadatavalue WHERE text_value LIKE '%Thesis or Dissertation%' AND
metadata_field_id = ( SELECT metadata_field_id FROM
metadatafieldregistry
WHERE element = 'type' AND qualifier IS NULL) )
This query gives me error in dspace and in my sql+ worksheet.
Sorry and thank yoy very much,
Andrea Garrido
From: Graham Triggs [EMAIL PROTECTED]
To: Andrea Garrido Fernández [EMAIL PROTECTED]
CC: dspace-tech@lists.sourceforge.net
Subject: Re: [Dspace-tech] Problem with statistics
Date: Tue, 11 Sep 2007 09:42:50 +0100
Hi,
Well, the relevant part of this is the only thing that's not in
English!! But the context is clear enough - it's having trouble parsing
a valid date.
Can you confirm that the start / end dates that you are passing to the
script are of the form '-mm-dd'.
If your input is valid, then you've got a problem with one of the
metadata value fields. You'll need to check the text_value of all the
dc.date.accessioned entries (probably metadata_field_id=11). It looks
like the offending item is of the correct format
(-mm-ddThh:mi:ssZ),
but contains invalid data.
G
On Mon, 2007-09-10 at 08:49 +, Andrea Garrido Fernández wrote:
Hi:
I have a problem when I try to execute the perl scripts for
generating
statistics.
When I try to run the LogAnalyser class with a start or end date, I
have
an
error like this:
java.sql.SQLException: ORA-01841: el valor (completo) del año
debe
estar
entre -4713 y +, y no debe ser igual a 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:745)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java
[Dspace-tech] Problem with statistics
Hi: I have a problem when I try to execute the perl scripts for generating statistics. When I try to run the LogAnalyser class with a start or end date, I have an error like this: java.sql.SQLException: ORA-01841: el valor (completo) del año debe estar entre -4713 y +, y no debe ser igual a 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:745) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1062) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:850) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3384) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) 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.processLogs(LogAnalyser.java:535) at org.dspace.app.statistics.LogAnalyser.main(LogAnalyser.java:327) -- I have tried many things, incluiding the solution given in this forum before, using the REGEXP_REPLACE , but I find it impossible because oracle don´t recognize this expression. Colud yo help me, please? I am a bit lost. Thanks, Andrea _ Dale rienda suelta a tu tiempo libre. Mil ideas para exprimir tu ocio con MSN Entretenimiento. http://entretenimiento.msn.es/ - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
