subject:"\[Dspace\-tech\] Statistics error\?"

[Dspace-tech] Statistics Error

2014-09-22 Thread Naveen Srinivasan

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

2012-01-13 Thread Clive Gould

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

2012-01-13 Thread Tim Donohue

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

2012-01-13 Thread Clive Gould

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?

2009-02-03 Thread Zaya Kh

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?

2009-02-03 Thread Kim Shepherd

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?

2009-02-03 Thread Yin Latt

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?

2009-02-03 Thread Zaya Kh

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)

2008-12-10 Thread mikan.d.dspace listmail

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)

2008-12-08 Thread Stuart Lewis

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)

2008-12-08 Thread mikan.d.dspace listmail

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)

2008-12-08 Thread Stuart Lewis

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)

2008-12-08 Thread mikan.d.dspace listmail

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

2008-11-25 Thread Shali 9846303531

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

2008-11-25 Thread Shali 9846303531

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

2008-11-25 Thread Stuart Lewis

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

[Dspace-tech] Statistics Error

[Dspace-tech] Statistics error with DSpace 1.8.1

Re: [Dspace-tech] Statistics error with DSpace 1.8.1

Re: [Dspace-tech] Statistics error with DSpace 1.8.1

[Dspace-tech] Statistics error?

Re: [Dspace-tech] Statistics error?

Re: [Dspace-tech] Statistics error?

Re: [Dspace-tech] Statistics error?

Re: [Dspace-tech] Statistics error (stat-monthly)

Re: [Dspace-tech] Statistics error (stat-monthly)

Re: [Dspace-tech] Statistics error (stat-monthly)

Re: [Dspace-tech] Statistics error (stat-monthly)

[Dspace-tech] Statistics error (stat-monthly)

[Dspace-tech] statistics error

[Dspace-tech] statistics error

Re: [Dspace-tech] statistics error

16 matches

Site Navigation

Mail list logo

Footer information