[Dspace-tech] Statistics Error
Hi , Main issue is ,In the Repository ,When I click Administrative section --Statistics page ,i am getting the below message *There are currently no reports available for this service. Please check back later.* I came to know that I need to setup the cron jobs to run this ,For the cron job to run we need files such as dsrun ,stat-* files in the bin folder. I am using Dspace *3.1 * version (Linux environment). I am not able to find dsrun and stat-* files in the bin directory .I have downloaded the source files again but i am not able to find the required files. *Somehow i go the files from the different version folder.* Cron job: 0 1 * * * [dspace]/bin/stat-general 0 1 * * * [dspace]/bin/stat-monthly 0 2 * * * [dspace]/bin/stat-report-general 0 2 * * * [dspace]/bin/stat-report-monthly Now i am able to run the dsrun.bat file (but i need to specify .bat extension). Please let me know is this process correct to solve the issue ? Could i get the dsrun ans stat-* files without extension to use in my environment .I believe the files i have downloaded is not appropriate.Thanks Regards, Naveen Illinois Institute of Technology Graduate (MCS) Mob : (312) 774-1687 -- Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer http://pubads.g.doubleclick.net/gampad/clk?id=154622311iu=/4140/ostg.clktrk___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
[Dspace-tech] Statistics error with DSpace 1.8.1
Hi I am having problem with the dspace stats script following an upgrade from 1.7.1 to 1.8.1 The solr server is running and lynx http://127.0.0.1/solr/statistics/select?q=*:* works fine and returns the statistics file However when I try to run the dspace stats script I get the following error [dspace@standbyvle bin]$ dspace stats-util -b -r Exception: Error executing query org.apache.solr.client.solrj.SolrServerException: Error executing query at org.apache.solr.client.solrj.request.QueryRequest.process(QueryRequest.java:95) at org.apache.solr.client.solrj.SolrServer.query(SolrServer.java:118) at org.dspace.statistics.SolrLogger.reindexBitstreamHits(SolrLogger.java:1009) at org.dspace.statistics.util.StatisticsClient.main(StatisticsClient.java:96) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:183) Caused by: org.apache.solr.common.SolrException: /solr/statistics/select /solr/statistics/select request: http://localhost:8080/solr/statistics/select?q=*:*fq=type:0fq=-bundleName:[* TO *]rows=0wt=javabinversion=2 at org.apache.solr.client.solrj.impl.CommonsHttpSolrServer.request(CommonsHttpSolrServer.java:435) at org.apache.solr.client.solrj.impl.CommonsHttpSolrServer.request(CommonsHttpSolrServer.java:244) at org.apache.solr.client.solrj.request.QueryRequest.process(QueryRequest.java:89) ... 8 more It looks as if it is looking for solr at localhost:8080. Any idea how I can change the URL/port number its looking for here please? I have already set the entries in the appropriate config/modules files to point to the correct URL for solr. Thanks very much Clive -- RSA(R) Conference 2012 Mar 27 - Feb 2 Save $400 by Jan. 27 Register now! http://p.sf.net/sfu/rsa-sfdev2dev2 ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Statistics error with DSpace 1.8.1
Clive, You can change the URL/port where DSpace looks for the Solr Statistics server in the following config file: [dspace]/modules/solr-statistics.cfg Look for this entry: server = http://localhost:8080/solr/statistics It looks like you need it to instead be set to: server = http://127.0.0.1/solr/statistics More info can be found in the Solr Statistics Documentation at: https://wiki.duraspace.org/display/DSDOC18/DSpace+Statistics#DSpaceStatistics-ConfigurationsettingsforStatistics (Side Note: if you plan to use Discovery (Solr-based faceted search/browse), you likely will also need to similarly edit the Solr 'search.server' setting in the [dspace]/modules/discover.cfg config file.) - Tim On 1/13/2012 7:03 AM, Clive Gould wrote: Hi I am having problem with the dspace stats script following an upgrade from 1.7.1 to 1.8.1 The solr server is running and lynx http://127.0.0.1/solr/statistics/select?q=*:* works fine and returns the statistics file However when I try to run the dspace stats script I get the following error [dspace@standbyvle bin]$ dspace stats-util -b -r Exception: Error executing query org.apache.solr.client.solrj.SolrServerException: Error executing query at org.apache.solr.client.solrj.request.QueryRequest.process(QueryRequest.java:95) at org.apache.solr.client.solrj.SolrServer.query(SolrServer.java:118) at org.dspace.statistics.SolrLogger.reindexBitstreamHits(SolrLogger.java:1009) at org.dspace.statistics.util.StatisticsClient.main(StatisticsClient.java:96) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:183) Caused by: org.apache.solr.common.SolrException: /solr/statistics/select /solr/statistics/select request: http://localhost:8080/solr/statistics/select?q=*:*fq=type:0fq=-bundleName:[* TO *]rows=0wt=javabinversion=2 at org.apache.solr.client.solrj.impl.CommonsHttpSolrServer.request(CommonsHttpSolrServer.java:435) at org.apache.solr.client.solrj.impl.CommonsHttpSolrServer.request(CommonsHttpSolrServer.java:244) at org.apache.solr.client.solrj.request.QueryRequest.process(QueryRequest.java:89) ... 8 more It looks as if it is looking for solr at localhost:8080. Any idea how I can change the URL/port number its looking for here please? I have already set the entries in the appropriate config/modules files to point to the correct URL for solr. Thanks very much Clive -- RSA(R) Conference 2012 Mar 27 - Feb 2 Save $400 by Jan. 27 Register now! http://p.sf.net/sfu/rsa-sfdev2dev2 ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech -- RSA(R) Conference 2012 Mar 27 - Feb 2 Save $400 by Jan. 27 Register now! http://p.sf.net/sfu/rsa-sfdev2dev2 ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Statistics error with DSpace 1.8.1
Hi Tim Thanks for this, but what is worrying me is that the solr-statistics.cfg file already contains the required changes :( I've run mvn and ant update Could this be a bug??? See below Clive /home/dspace/dspace-1.8.1-src-release/dspace/config/modules [dspace@standbyvle modules]$ cat solr-statistics.cfg #---# #--SOLR STATISTICS CONFIGURATIONS---# #---# # These configs are only used by the SOLR interface/webapp to # # track usage statistics. # #---# # Usage Logging # # set this to be the port you run the dspace solr webapp # on, by default, we are assuming a test configuration with # tomcat still running on port 8080 server = http://127.0.0.1/solr/statistics etc. and [dspace@standbyvle modules]$ cat discovery.cfg #---# #-DISCOVERY CONFIGURATIONS--# #---# # Configuration properties used solely by the Discovery # # faceted-search system.# #---# # Search Indexing # search.server = http://127.0.0.1/solr/search etc On Fri, Jan 13, 2012 at 3:02 PM, Tim Donohue tdono...@duraspace.org wrote: Clive, You can change the URL/port where DSpace looks for the Solr Statistics server in the following config file: [dspace]/modules/solr-statistics.cfg Look for this entry: server = http://localhost:8080/solr/statistics It looks like you need it to instead be set to: server = http://127.0.0.1/solr/statistics More info can be found in the Solr Statistics Documentation at: https://wiki.duraspace.org/display/DSDOC18/DSpace+Statistics#DSpaceStatistics-ConfigurationsettingsforStatistics (Side Note: if you plan to use Discovery (Solr-based faceted search/browse), you likely will also need to similarly edit the Solr 'search.server' setting in the [dspace]/modules/discover.cfg config file.) - Tim On 1/13/2012 7:03 AM, Clive Gould wrote: Hi I am having problem with the dspace stats script following an upgrade from 1.7.1 to 1.8.1 The solr server is running and lynx http://127.0.0.1/solr/statistics/select?q=*:* works fine and returns the statistics file However when I try to run the dspace stats script I get the following error [dspace@standbyvle bin]$ dspace stats-util -b -r Exception: Error executing query org.apache.solr.client.solrj.SolrServerException: Error executing query at org.apache.solr.client.solrj.request.QueryRequest.process(QueryRequest.java:95) at org.apache.solr.client.solrj.SolrServer.query(SolrServer.java:118) at org.dspace.statistics.SolrLogger.reindexBitstreamHits(SolrLogger.java:1009) at org.dspace.statistics.util.StatisticsClient.main(StatisticsClient.java:96) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:183) Caused by: org.apache.solr.common.SolrException: /solr/statistics/select /solr/statistics/select request: http://localhost:8080/solr/statistics/select?q=*:*fq=type:0fq=-bundleName:[* TO *]rows=0wt=javabinversion=2 at org.apache.solr.client.solrj.impl.CommonsHttpSolrServer.request(CommonsHttpSolrServer.java:435) at org.apache.solr.client.solrj.impl.CommonsHttpSolrServer.request(CommonsHttpSolrServer.java:244) at org.apache.solr.client.solrj.request.QueryRequest.process(QueryRequest.java:89) ... 8 more It looks as if it is looking for solr at localhost:8080. Any idea how I can change the URL/port number its looking for here please? I have already set the entries in the appropriate config/modules files to point to the correct URL for solr. Thanks very much Clive -- RSA(R) Conference 2012 Mar 27 - Feb 2 Save $400 by Jan. 27 Register now! http://p.sf.net/sfu/rsa-sfdev2dev2 ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech -- RSA(R) Conference 2012 Mar 27 - Feb 2 Save $400 by Jan. 27 Register now! http://p.sf.net/sfu/rsa-sfdev2dev2 ___ DSpace-tech mailing list
[Dspace-tech] Statistics error?
Hello again, I have a question? When I start DSpace's statistics this error show me. [r...@localhost bin]# ./stat-initial Exception in thread main org.postgresql.util.PSQLException: ERROR: syntax error at or near FROM at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:250) 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:209) at org.dspace.storage.rdbms.DatabaseManager.querySingle(DatabaseManager.java:279) at org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1273) at org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1302) at org.dspace.app.statistics.LogAnalyser.processLogs(LogAnalyser.java:543) at org.dspace.app.statistics.CreateStatReport.statInitial(CreateStatReport.java:291) at org.dspace.app.statistics.CreateStatReport.main(CreateStatReport.java:162) [r...@localhost bin]# Can you advice me? Best regard, Zoloo -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Statistics error?
Hi Zaya, It might be easier to track this problem down with debug-level logging. To do this, edit your [dspace]/config/log4j.properties and change log4j.rootCategory=INFO, A1 to log4j.rootCategory=DEBUG, A1. Then restart Dspace. Now you’ll be able to see all the SQL queries in your log, which should shed some more light on why the one being used by stat-initial is upsetting PostgreSQL. Cheers, Kim From: Zaya Kh [mailto:zayak...@gmail.com] Sent: Wednesday, 4 February 2009 1:23 a.m. To: dspace-tech Subject: [Dspace-tech] Statistics error? Hello again, I have a question? When I start DSpace's statistics this error show me. [r...@localhost bin]# ./stat-initial Exception in thread main org.postgresql.util.PSQLException: ERROR: syntax error at or near FROM at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:250) 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:209) at org.dspace.storage.rdbms.DatabaseManager.querySingle(DatabaseManager.java:279) at org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1273) at org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1302) at org.dspace.app.statistics.LogAnalyser.processLogs(LogAnalyser.java:543) at org.dspace.app.statistics.CreateStatReport.statInitial(CreateStatReport.java:291) at org.dspace.app.statistics.CreateStatReport.main(CreateStatReport.java:162) [r...@localhost bin]# Can you advice me? Best regard, Zoloo -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Statistics error?
Hi Zaya, It is bug http://sourceforge.net/tracker/index.php?func=detailaid=1931799group_i d=19984atid=119984 which have been fixed. Regards, YinYin From: Zaya Kh [mailto:zayak...@gmail.com] Sent: Wednesday, 4 February 2009 1:23 a.m. To: dspace-tech Subject: [Dspace-tech] Statistics error? Hello again, I have a question? When I start DSpace's statistics this error show me. [r...@localhost bin]# ./stat-initial Exception in thread main org.postgresql.util.PSQLException: ERROR: syntax error at or near FROM at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecu torImpl.java:1512) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp l.java:1297) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java: 188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme nt.java:430) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb c2Statement.java:346) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2St atement.java:250) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat ingPreparedStatement.java:92) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat ingPreparedStatement.java:92) at org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:209) at org.dspace.storage.rdbms.DatabaseManager.querySingle(DatabaseManager.jav a:279) at org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1273) at org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1302) at org.dspace.app.statistics.LogAnalyser.processLogs(LogAnalyser.java:543) at org.dspace.app.statistics.CreateStatReport.statInitial(CreateStatReport. java:291) at org.dspace.app.statistics.CreateStatReport.main(CreateStatReport.java:16 2) [r...@localhost bin]# Can you advice me? Best regard, Zoloo -- next part -- An HTML attachment was scrubbed... -- -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Statistics error?
hi, Yin I understood, this is bug, then How can I change this bug in my system, Can you help me detials? Cheers, Zoloo On 2/4/09, Yin Latt y.l...@auckland.ac.nz wrote: Hi Zaya, It is bug http://sourceforge.net/tracker/index.php?func=detailaid=1931799group_i d=19984atid=119984 which have been fixed. Regards, YinYin From: Zaya Kh [mailto:zayak...@gmail.com] Sent: Wednesday, 4 February 2009 1:23 a.m. To: dspace-tech Subject: [Dspace-tech] Statistics error? Hello again, I have a question? When I start DSpace's statistics this error show me. [r...@localhost bin]# ./stat-initial Exception in thread main org.postgresql.util.PSQLException: ERROR: syntax error at or near FROM at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecu torImpl.java:1512) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp l.java:1297) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java: 188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme nt.java:430) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb c2Statement.java:346) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2St atement.java:250) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat ingPreparedStatement.java:92) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat ingPreparedStatement.java:92) at org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:209) at org.dspace.storage.rdbms.DatabaseManager.querySingle(DatabaseManager.jav a:279) at org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1273) at org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1302) at org.dspace.app.statistics.LogAnalyser.processLogs(LogAnalyser.java:543) at org.dspace.app.statistics.CreateStatReport.statInitial(CreateStatReport. java:291) at org.dspace.app.statistics.CreateStatReport.main(CreateStatReport.java:16 2) [r...@localhost bin]# Can you advice me? Best regard, Zoloo -- next part -- An HTML attachment was scrubbed... -- -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today- http://p.sf.net/sfu/adobe-com ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Statistics error (stat-monthly)
Hi Stuart, Im afraid Im still stuck with this. I have installed some system updates a few weeks ago by apt-get, but nothing that I could think of causing this. I looked into item data and found data that looks ok to me: 3288 |4 | t | f | 2008-11-13 16:40:55.408+02 |18 3246 |4 | t | f | 2008-11-13 16:37:36.596+02 |18 3289 |4 | t | f | 2008-11-13 16:40:55.518+02 |18 3410 |3 | t | f | 2008-12-10 14:23:03.80+02 |36 For some reason the query doesnt work with the year+timestamp data. Any ideas? -Mika 2008/12/8 Stuart Lewis [EMAIL PROTECTED]: Weird - that should work fine. I presume this has just started to happen? If so, have you upgraded your database recently, or changed anything on your server such as time zone etc? On 08/12/2008 13:46, mikan.d.dspace listmail [EMAIL PROTECTED] wrote: Im getting the following: tds=# SELECT COUNT(*) AS num FROM item WHERE in_archive = true AND withdrawn = tds-# false AND item_id IN (SELECT item_id FROM metadatavalue WHERE tds(# metadata_field_id = (SELECT metadata_field_id FROM metadatafieldregistry tds(# WHERE element = 'date' AND qualifier = 'accessioned') AND tds(# text_value::timestamp '2008-12-01'::timestamp AND text_value::timestamp tds(# '2008-12-31'::timestamp); ERROR: invalid input syntax for type timestamp: 2008 -Mika 2008/12/8 Stuart Lewis [EMAIL PROTECTED]: Hi Mika, 2008-12-08 14:10:56,445 INFO org.dspace.core.ConfigurationManager @ Loading: /home/dspace/tds/dspace/config/log4j.properties 2008-12-08 14:10:57,681 DEBUG org.dspace.storage.rdbms.DatabaseManager @ Running query SELECT COUNT(*) AS num FROM item WHERE in_archive = true AND withdrawn = false 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 text_value::timestamp '2008-12-01'::timestamp AND text_value::timestamp '2008-12-31'::timestamp ) with parameters: Any ideas? Try running that query directly in Postgres, and see if it works. It should work fine, and return a number. If it doesn't work, then we'll need to know the error message. If it does work, then I'll be puzzled as that is the query that DSpace is running. SELECT COUNT(*) AS num FROM item WHERE in_archive = true AND withdrawn = false 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 text_value::timestamp '2008-12-01'::timestamp AND text_value::timestamp '2008-12-31'::timestamp); Thanks, Stuart _ Gwasanaethau Gwybodaeth Information Services Prifysgol Aberystwyth Aberystwyth University E-bost / E-mail: [EMAIL PROTECTED] Ffon / Tel: (01970) 622860 _ -- SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Statistics error (stat-monthly)
Hi Mika, When running stat-monthly I get the following. Any ideas whats wrong? I can see the statistics fine till November. org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1270) at org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1299) This is the query where is trying to count the total number of items in your repository. Could you set your log level to DEBUG, re-run stat-monthly, and forward the log trace to us. We should be able to see what query DSpace is trying to run, and hope to see what might be going wrong. For some reason it sounds like the dates for the start and end of the month are not getting set properly. Thanks, Stuart _ Gwasanaethau Gwybodaeth Information Services Prifysgol Aberystwyth Aberystwyth University E-bost / E-mail: [EMAIL PROTECTED] Ffon / Tel: (01970) 622860 _ -- SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Statistics error (stat-monthly)
Stuart, Here goes: 2008-12-08 14:10:56,445 INFO org.dspace.core.ConfigurationManager @ Loading: /home/dspace/tds/dspace/config/log4j.properties 2008-12-08 14:10:57,681 DEBUG org.dspace.storage.rdbms.DatabaseManager @ Running query SELECT COUNT(*) AS num FROM item WHERE in_archive = true AND withdrawn = false 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 text_value::timestamp '2008-12-01'::timestamp AND text_value::timestamp '2008-12-31'::timestamp ) with parameters: Any ideas? Mika 2008/12/8 Stuart Lewis [EMAIL PROTECTED]: Hi Mika, When running stat-monthly I get the following. Any ideas whats wrong? I can see the statistics fine till November. org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1270) at org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1299) This is the query where is trying to count the total number of items in your repository. Could you set your log level to DEBUG, re-run stat-monthly, and forward the log trace to us. We should be able to see what query DSpace is trying to run, and hope to see what might be going wrong. For some reason it sounds like the dates for the start and end of the month are not getting set properly. Thanks, Stuart _ Gwasanaethau Gwybodaeth Information Services Prifysgol Aberystwyth Aberystwyth University E-bost / E-mail: [EMAIL PROTECTED] Ffon / Tel: (01970) 622860 _ -- SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Statistics error (stat-monthly)
Hi Mika, 2008-12-08 14:10:56,445 INFO org.dspace.core.ConfigurationManager @ Loading: /home/dspace/tds/dspace/config/log4j.properties 2008-12-08 14:10:57,681 DEBUG org.dspace.storage.rdbms.DatabaseManager @ Running query SELECT COUNT(*) AS num FROM item WHERE in_archive = true AND withdrawn = false 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 text_value::timestamp '2008-12-01'::timestamp AND text_value::timestamp '2008-12-31'::timestamp ) with parameters: Any ideas? Try running that query directly in Postgres, and see if it works. It should work fine, and return a number. If it doesn't work, then we'll need to know the error message. If it does work, then I'll be puzzled as that is the query that DSpace is running. SELECT COUNT(*) AS num FROM item WHERE in_archive = true AND withdrawn = false 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 text_value::timestamp '2008-12-01'::timestamp AND text_value::timestamp '2008-12-31'::timestamp); Thanks, Stuart _ Gwasanaethau Gwybodaeth Information Services Prifysgol Aberystwyth Aberystwyth University E-bost / E-mail: [EMAIL PROTECTED] Ffon / Tel: (01970) 622860 _ -- SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Statistics error (stat-monthly)
When running stat-monthly I get the following. Any ideas whats wrong? I can see the statistics fine till November. Exception in thread main org.postgresql.util.PSQLException: ERROR: invalid input syntax for type timestamp: 2008 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) at org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:221) at org.dspace.storage.rdbms.DatabaseManager.querySingle(DatabaseManager.java:302) at org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1270) at org.dspace.app.statistics.LogAnalyser.getNumItems(LogAnalyser.java:1299) at org.dspace.app.statistics.LogAnalyser.processLogs(LogAnalyser.java:541) at org.dspace.app.statistics.CreateStatReport.statMonthly(CreateStatReport.java:214) at org.dspace.app.statistics.CreateStatReport.main(CreateStatReport.java:154) Thanks, Mika -- SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] statistics error
Dear sir, When i am taking the statistics of dspace ,*the Most recent general report*will display but cant getting the monthly report after December 2007, how can i change the settings in statistics. thanking you, -- Shali.K.R Asst.Librarian(Digital) Vidya Academy of Science Technology Thrissur, Kerala. Mob:9846303531 - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] statistics error
Dear sir , i am getting only 2005 to 2007 on report *Monthly reports:* 01/2005http://10.1.1.5:8080/dspace/statistics?date=2005-1 | 02/2005 http://10.1.1.5:8080/dspace/statistics?date=2005-2 | 03/2005http://10.1.1.5:8080/dspace/statistics?date=2005-3 | 04/2005 http://10.1.1.5:8080/dspace/statistics?date=2005-4 | 05/2005http://10.1.1.5:8080/dspace/statistics?date=2005-5 | 06/2005 http://10.1.1.5:8080/dspace/statistics?date=2005-6 | 07/2005http://10.1.1.5:8080/dspace/statistics?date=2005-7 | 08/2005 http://10.1.1.5:8080/dspace/statistics?date=2005-8 | 09/2005http://10.1.1.5:8080/dspace/statistics?date=2005-9 | 10/2005 http://10.1.1.5:8080/dspace/statistics?date=2005-10 | 11/2005http://10.1.1.5:8080/dspace/statistics?date=2005-11 | 12/2005 http://10.1.1.5:8080/dspace/statistics?date=2005-12 | 01/2006http://10.1.1.5:8080/dspace/statistics?date=2006-1 | 02/2006 http://10.1.1.5:8080/dspace/statistics?date=2006-2 | 03/2006http://10.1.1.5:8080/dspace/statistics?date=2006-3 | 04/2006 http://10.1.1.5:8080/dspace/statistics?date=2006-4 | 05/2006http://10.1.1.5:8080/dspace/statistics?date=2006-5 | 06/2006 http://10.1.1.5:8080/dspace/statistics?date=2006-6 | 07/2006http://10.1.1.5:8080/dspace/statistics?date=2006-7 | 08/2006 http://10.1.1.5:8080/dspace/statistics?date=2006-8 | 09/2006http://10.1.1.5:8080/dspace/statistics?date=2006-9 | 10/2006 http://10.1.1.5:8080/dspace/statistics?date=2006-10 | 11/2006http://10.1.1.5:8080/dspace/statistics?date=2006-11 | 12/2006 http://10.1.1.5:8080/dspace/statistics?date=2006-12 | *01/2007* | 02/2007 http://10.1.1.5:8080/dspace/statistics?date=2007-2 | 03/2007http://10.1.1.5:8080/dspace/statistics?date=2007-3 | 04/2007 http://10.1.1.5:8080/dspace/statistics?date=2007-4 | 05/2007http://10.1.1.5:8080/dspace/statistics?date=2007-5 | 06/2007 http://10.1.1.5:8080/dspace/statistics?date=2007-6 | 07/2007http://10.1.1.5:8080/dspace/statistics?date=2007-7 | 08/2007 http://10.1.1.5:8080/dspace/statistics?date=2007-8 | 09/2007http://10.1.1.5:8080/dspace/statistics?date=2007-9 | 10/2007 http://10.1.1.5:8080/dspace/statistics?date=2007-10 | 11/2007http://10.1.1.5:8080/dspace/statistics?date=2007-11 | 12/2007 http://10.1.1.5:8080/dspace/statistics?date=2007-12 i cant getting the report of year 2008 how can i set the date option for report generation, anybody please help me -- Shali.K.R Asst.Librarian(Digital) Vidya Academy of Science Technology Thrissur, Kerala. Mob:9846303531 - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] statistics error
Hi, i am getting only 2005 to 2007 on report Monthly reports: 01/2005 http://10.1.1.5:8080/dspace/statistics?date=2005-1 | 02/2005 http://10.1.1.5:8080/dspace/statistics?date=2005-2 | 03/2005 ... http://10.1.1.5:8080/dspace/statistics?date=2007-10 | 11/2007 http://10.1.1.5:8080/dspace/statistics?date=2007-11 | 12/2007 http://10.1.1.5:8080/dspace/statistics?date=2007-12 i cant getting the report of year 2008 how can i set the date option for report generation, anybody please help me This is a curious problem as DSpace allows you to specify a start for the generation of statistics, but not an end date. Which version of DSpace are you using? On your statistics homepage, what is the date range it shows at the top? (Statistics for XYZ / Month Day, Year to Month Day, Year) Do you have dspace.log.* files in [dspace]/log/ for 2008, and do you also have monthly .dat files in the same directory for 2008? It sounds like something is going wrong with the collection of processing of your log files for 2008. Thanks, Stuart _ Gwasanaethau Gwybodaeth Information Services Prifysgol Aberystwyth Aberystwyth University E-bost / E-mail: [EMAIL PROTECTED] Ffon / Tel: (01970) 622860 _ - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech