Re: [Dspace-tech] [Dspace-devel] statistics
Hi Pradip, (cc’ing to dspace-tech) I can’t guarantee this is the problem, but I’ve encountered this SQL error running stat-initial when I’ve had two metadata schemas that both had element/qualifier combinations that some Dspace queries expect to be unique. For instance, on one of my instances I have “uow.date.accessioned”, an accession date from a previous repository stored in our custom “uow” metadata schema, but the subquery run by stat-initial (when it’s getting a count of non-withdrawn items) looks for metadata with element ‘date’ and qualifier ‘accessioned’ but ignores schema ID – both results are returned, and the exception is thrown because the subquery should only have returned one result. The quick fix would be to rename the custom metadata field to something other than date.accessioned, or to modify the item count query so that “element=’date’ AND qualifier=’accessioned’ AND metadata_schema_id=1”. It seems pretty likely that Dublin core is always going to be schema ID ‘1’ but I guess I wouldn’t want to automatically assume that, either. Cheers, Kim From: Pradip Patel [mailto:pradi...@gmail.com] Sent: Monday, 10 August 2009 8:52 p.m. To: dspace-de...@lists.sourceforge.net Subject: [Dspace-devel] statistics Dear sir we are using the following version of Dspace Dspace 1.4.1 PostgreSQL 8.2 Apache 2.2 Apache ant 1.5 Java JRE/JDK 1.6.0 we installed perl and modify the stat* files # Details used ## $in_prefix = dspace-log-general-; $in_suffix = .dat; $out_prefix = report-general-; $out_suffix = .html; $dsrun = f:/dspace/bin/dsrun; $in_directory = f:/dspace/reports; $out_directory = f:/dspace/reports/; ## but when we retun the command f:\perl dspace\bin\stat-initial we found error1(attachment) and when run the command f:\perl dspace\bin\stat-report-initial we found error 2 (attachment) 2 screen shot and a last lo file we are sending to you. what we have to do next. and why we found that errors? and why ous dspace doesn't show statistics? pls help sir -- Pradip Gujarat India -- 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] [Dspace-devel] statistics
On 17/08/2009, at 5:56 AM, Kim Shepherd wrote: the subquery run by stat-initial (when it’s getting a count of non-withdrawn items) looks for metadata with element ‘date’ and qualifier ‘accessioned’ but ignores schema ID – both results are returned, and the exception is thrown because the subquery should only have returned one result. There is a definable schema `search_path' mentioned in section 5.7.3 Postgresql 8.1 manual which might help. Van Ly vly at usyd dot edu dot au -- 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] [Dspace-devel] statistics
I assume this is to do with database schema rather than metadata registry schema, so it probably isn't relevant.. sorry if I didn't explain what I meant by 'schema' very well. If you inspect your metadatafieldregistry table, you'll see the schema ID I'm talking about. Cheers, Kim -Original Message- From: Van Ly [mailto:v...@usyd.edu.au] Sent: Monday, 17 August 2009 11:36 a.m. To: DSpace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] [Dspace-devel] statistics On 17/08/2009, at 5:56 AM, Kim Shepherd wrote: the subquery run by stat-initial (when it’s getting a count of non-withdrawn items) looks for metadata with element ‘date’ and qualifier ‘accessioned’ but ignores schema ID – both results are returned, and the exception is thrown because the subquery should only have returned one result. There is a definable schema `search_path' mentioned in section 5.7.3 Postgresql 8.1 manual which might help. Van Ly vly at usyd dot edu dot au --- --- 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 -- 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] [Dspace-devel] statistics
On 17/08/2009, at 9:46 AM, Kim Shepherd wrote: I assume this is to do with database schema rather than metadata registry schema, so it probably isn't relevant.. sorry if I didn't explain what I meant by 'schema' very well. If you inspect your metadatafieldregistry table, you'll see the schema ID I'm talking about. Yep, that would be the `metadata_schema_id'. Thanks. Cheers, Kim -Original Message- From: Van Ly [mailto:v...@usyd.edu.au] Sent: Monday, 17 August 2009 11:36 a.m. To: DSpace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] [Dspace-devel] statistics On 17/08/2009, at 5:56 AM, Kim Shepherd wrote: the subquery run by stat-initial (when it’s getting a count of non-withdrawn items) looks for metadata with element ‘date’ and qualifier ‘accessioned’ but ignores schema ID – both results are returned, and the exception is thrown because the subquery should only have returned one result. There is a definable schema `search_path' mentioned in section 5.7.3 Postgresql 8.1 manual which might help. Van Ly vly at usyd dot edu dot au -- 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