date:20120202

Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1

2012-02-02 Thread Claudia Jürgen

Hello Susan,


while updating to 1.6 did you get some errors like that:

psql:database_schema_15-16.sql:105: ERROR:  constraint
community2collection_collection_id_fkey of relation
community2collection does not exist
ALTER TABLE
psql:database_schema_15-16.sql:108: ERROR:  constraint
community2community_child_comm_id_fkey of relation
community2community does not exist
ALTER TABLE
psql:database_schema_15-16.sql:111: ERROR:  constraint
collection2item_item_id_fkey of relation collection2item does not exist

If so, inspect your database and use the references for the foreign keys
to delete them, e.g::

psql [YourDBName]
\d [TableName]
will show you the foreign keys, e.g.:
\d community2collection

Table public.community2collection
  Column |  Type   | Modifiers
---+-+---
id| integer | not null
community_id  | integer |
collection_id | integer |
Indexes:
  community2collection_pkey PRIMARY KEY, btree (id)
  community2collection_collection_id_idx btree (collection_id)
  community2collection_community_id_idx btree (community_id)
Foreign-key constraints:
  $1 FOREIGN KEY (community_id) REFERENCES community(community_id)
  $2 FOREIGN KEY (collection_id) REFERENCES collection(collection_id)

In that case you got to run:

ALTER TABLE collection2item DROP CONSTRAINT $2;
ALTER TABLE community2community DROP CONSTRAINT $2;
ALTER TABLE community2collection DROP CONSTRAINT $2;

The reason for this is:

In Step 7 Update the database it can happen that not all the commands in
the database_schema_15-16.sql are executed properly.

The commands to drop foreign keys:

ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey;

ALTER TABLE community2community DROP CONSTRAINT
community2community_child_comm_id_fkey;

ALTER TABLE community2collection DROP CONSTRAINT
community2collection_collection_id_fkey;

assume that the keys got default names, whereas depending on the
database version and operating system on which your instance started,
they can have no names and just be counted internally.

If you got no names or other names the script will skip the commands,
with the above mentioned ERROR.

This will lead to errors running DSpace as now 2 contraints exist and
one is unable to delete items, collections etc.

Hope that helps

Claudia Jürgen



Am 01.02.2012 20:46, schrieb Thornton, Susan M. (LARC-B702)[LITES]:
 Hello,
   After recently upgrading from DSpace 1.5.1 to 1.7.1, we are getting the 
 following error whenever we try to delete an Item online:

 2012-02-01 14:40:17,883 WARN  org.dspace.app.webui.servlet.DSpaceServlet @ 
 susan.m.thorn...@nasa.gov:session_id=B6C011F3369B678E2FB9ED4B0050:ip_addr=999.99.99.999:database_error:org.postgresql.util.PSQLException\colon;
  ERROR\colon; update or delete on table item violates foreign key 
 constraint $2 on table collection2item
Detail\colon; Key (item_id)=(429349) is still referenced from table 
 collection2item.
 org.postgresql.util.PSQLException: ERROR: update or delete on table item 
 violates foreign key constraint $2 on table collection2item
Detail: Key (item_id)=(429349) is still referenced from table 
 collection2item.


 I found some old dspace-tech postings regarding this error and am wondering 
 if the recommended fix is correct?

 Not sure how this one happened:  after upgrading to dspace 1.6, we're having
 trouble deleting items from dspace.  We get an error message explaining that
 'update or delete on item violates foreign key constraint $2 on
 collection2item'.  Describing collection2item yields:

 Table public.collection2item
  Column |  Type   | Modifiers
 ---+-+---
 id| integer | not null
 collection_id | integer |
   item_id   | integer |
 Indexes:
  collection2item_pkey PRIMARY KEY, btree (id)
  collection2item_collection_idx btree (collection_id)
  collection2item_item_id_idx btree (item_id)
 Foreign-key constraints:
  $1 FOREIGN KEY (collection_id) REFERENCES collection(collection_id)
  $2 FOREIGN KEY (item_id) REFERENCES item(item_id)
  coll2item_item_fk FOREIGN KEY (item_id) REFERENCES item(item_id)
 DEFERRABLE

 I ran the database scheme update script, and it seems to have added the final,
 deferrable foreign key constraint; but I can't find any reference at all to 
 the
 first two FKCs ($1 and $2).  As far as I can tell, they aren't supposed to
 exist at all; I assume they're left over from some previous version of dspace,
 didn't get removed at some point in the past, and just never caused problems
 until now.  Can anybody confirm that I can go ahead and drop these constraints
 (and similar constraints in Community2Collection?

 Bill Anderson
 Software Developer
 Digital Library Development
 Georgia Tech Library

 Thanks in advance!
 Sue

 Sue Walker-Thornton
 Software Developer/Database Administrator
 NASA Langley Research Center - LITES Contract
 susan.m.thorn...@nasa.gov
 (W)

[Dspace-tech] full text search utf issue

2012-02-02 Thread Eimar Koort

Hi,

I'm encountering the same problem with Dspace 1.8.1 as described here :

https://jira.duraspace.org/browse/DS-112


How to repeat:
Open http://domain/xmlui/search

Enter to Full text search some problematic chars:
ä ü ö õ ('a uml', 'u uml', 'o uml' or 'o tilde')

Hit Go. Press Go button again to see more fun.

As for now this input entry seems to be the only bad one.

If i force from browser for a moment ISO-8859-1 charset, enter some
problematic chars and press Go, then search is fine. Second Go and
problem again.


I checked http://cocoon.apache.org/2.2/1366_1_1.html too, but this
doesn't seem to be issue.

Any hints?

Regards
--
Eimar Koort
(e-mail: eimar.ko...@emu.ee)
(http://www.emu.ee)

--
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

[Dspace-tech] PostgreSQL to Oracle 11g

2012-02-02 Thread Wellaway, Ian

Hi,

We are looking at migrating our DSpace databases from PostgreSQL to Oracle.

Has anyone done this? If so could you let me know how it went?

Also, does DSpace work with Oracle 11g?

Thanks

Ian



Ian Wellaway

Senior System Support  Development Officer - Academic Systems (Room 911) Mons, 
Tues and alternate Fridays

Technical Developer, Open Exeter - Infrastructure Systems (Level 5) Weds, Thurs 
and alternate Fridays

Exeter IT
Laver Building
University of Exeter
EX4 4QE
UK

--
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

[Dspace-tech] Making DSpace read only

2012-02-02 Thread Claire Webster

Hello,

I need to make our DSpace installation read-only is there an easy way to 
do this, or instructions available? Any help very gratefully received.

kind regards,
Claire
-- 
Claire Webster (nee Lumber)
Developer, Library Systems
University of Bristol
Email: claire.webs...@bristol.ac.uk
Tel: (0117) 331 6739 (internal: 16739)

--
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] Making DSpace read only

2012-02-02 Thread Henry, Matt - OPS District Computer Technician

When you say read only do you mean that no one is able to submit or edit
new items?  Or do you mean that no one should be able to just edit items?

I have never tried that before but if you want to just disallow
submissions you can change permissions for anonymous and authenticated to
deny 'add.'  If you need to simply prevent the editing of items this can
be done via group permissions as well.

It would be helpful for people to know what version you are using, what
environment you are in, and more detail on what you are trying to
accomplish.

Hope this helps!
Matt Henry

On 2/2/12 6:51 AM, Claire Webster claire.webs...@bristol.ac.uk wrote:

Hello,

I need to make our DSpace installation read-only is there an easy way to
do this, or instructions available? Any help very gratefully received.

kind regards,
Claire
-- 
Claire Webster (nee Lumber)
Developer, Library Systems
University of Bristol
Email: claire.webs...@bristol.ac.uk
Tel: (0117) 331 6739 (internal: 16739)

--

Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech




--
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] Changing advanced search drop down in XMLUI

2012-02-02 Thread Henry, Matt - OPS District Computer Technician

Thank you for the help!  What an obscure website by the way.  Would have never 
found that on my own.  It did prove to be quite helpful however I am still not 
100% on this.

If I click Advanced Search then the drop down is still the default 10:
[cid:image001.png@01CCE188.127F5B80]

If I type anything into any field and click go then the dropdown is updated 
with the correct values:
[cid:image002.png@01CCE188.A8280A60]

The current configs are as follows:

Dspace.cfg:

###  changing these will change your search results, ###
###  but will NOT automatically change your search displays  ###

#search.index.1 = author:dc.contributor.*
#search.index.2 = author:dc.creator.*
#search.index.3 = title:dc.title.*
#search.index.4 = keyword:dc.subject.*
#search.index.5 = abstract:dc.description.abstract
#search.index.6 = author:dc.description.statementofresponsibility
#search.index.7 = series:dc.relation.ispartofseries
#search.index.8 = abstract:dc.description.tableofcontents
#search.index.9 = mime:dc.format.mimetype
#search.index.10 = sponsor:dc.description.sponsorship
#search.index.11 = identifier:dc.identifier.*
#search.index.12 = language:dc.language.iso

search.index.1 = description:dc.description
search.index.2 = title:dc.title.*
search.index.3 = kentuckycorecontent:dc.kentuckycorecontent.*
search.index.4 = commoncore:dc.commoncore.*
search.index.5 = nwea:dc.nwea.*
search.index.6 = collegereadiness:dc.collegereadiness.*
search.index.7 = keyword:dc.description.keyword
search.index.8 = coursearea:dc.coursearea.*
search.index.9 = gradelevel:dc.description.gradelevel
search.index.10 = lessontype:dc.description.lessontype
search.index.11 = mime:dc.format.mimetype


messages.xml:

message 
key=xmlui.ArtifactBrowser.AdvancedSearch.type_descriptionDescription/message
message 
key=xmlui.ArtifactBrowser.AdvancedSearch.type_titleTitle/message
message 
key=xmlui.ArtifactBrowser.AdvancedSearch.type_kentuckycorecontentKentucky 
Core Content/message
message 
key=xmlui.ArtifactBrowser.AdvancedSearch.type_commoncoreCommon Core/message
message key=xmlui.ArtifactBrowser.AdvancedSearch.type_nweaNWEA 
(Decartes)/message
message 
key=xmlui.ArtifactBrowser.AdvancedSearch.type_collegereadinessCollege 
Readiness/message
message 
key=xmlui.ArtifactBrowser.AdvancedSearch.type_keywordKeyword/message
message 
key=xmlui.ArtifactBrowser.AdvancedSearch.type_courseareaCourse Area/message
message 
key=xmlui.ArtifactBrowser.AdvancedSearch.type_gradelevelGrade Level/message
message 
key=xmlui.ArtifactBrowser.AdvancedSearch.type_lessontypeLesson Type/message
message 
key=xmlui.ArtifactBrowser.AdvancedSearch.type_mimeMime-Type/message

What am I doing wrong?

Thanks,
Matt

From: Hilton Gibson [mailto:hilton.gib...@gmail.com]
Sent: Wednesday, February 01, 2012 5:49 PM
To: Henry, Matt - OPS District Computer Technician
Subject: Re: [Dspace-tech] Changing advanced search drop down in XMLUI

Try this: http://wiki.lib.sun.ac.za/index.php/SUNScholar/Indexes
On 1 February 2012 23:59, Henry, Matt - OPS District Computer Technician 
matt.he...@owensboro.kyschools.usmailto:matt.he...@owensboro.kyschools.us 
wrote:
OK.  This may be a noob question but I cannot for the life of me find 
documentation detailing how to change the current drop downs of the XMLUI 
advanced search.  I changed search.index in the cfg files which reveals an 
interesting outcome though.  Upon clicking advanced search you see the default 
drop down list.  If you click search it fills in the drop down with the custom 
field's long names.

Can anyone tell me how to do this?

Thanks,
Matt Henry

--
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.netmailto:DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech



--
Hilton Gibson
Systems Administrator
JS Gericke Library
Room 1025D
Stellenbosch University
Private Bag X5036
Stellenbosch
7599
South Africa

Cell: +27 846 464 758 | Phone: +27 21 808 4100

inline: image001.pnginline: image002.png--
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net

Re: [Dspace-tech] full text search utf issue

2012-02-02 Thread Tim Donohue

Eimar,

When you installed DSpace, did you make sure to setup Tomcat Java to
run in UTF-8 encoding?

Specifically, if you look at the DSpace install instructions under the
Servlet Engine there are a few notes which show how you can ensure
everything in DSpace is using UTF-8 encoding:

https://wiki.duraspace.org/display/DSDOC18/Installation#Installation-ServletEngine%3A%28ApacheTomcat5.5or6%2CJetty%2CCauchoResinorequivalent%29.

Specifically, you should make sure your Tomcat Connector has
URIEncoding='UTF-8' (see the page above), and you should ensure that
your JAVA_OPTS environment variable has -Dfile.encoding=UTF-8.

After changing any of these settings you should do the following:
* Stop Tomcat
* Re-index your DSpace content : [dspace]/bin/dspace index-init
* Start Tomcat
* Try the search again. Hopefully this time it will work.

Let us know on this list if this still doesn't work for you.

- Tim

On 2/2/2012 3:15 AM, Eimar Koort wrote:
Hi,

I'm encountering the same problem with Dspace 1.8.1 as described here :

https://jira.duraspace.org/browse/DS-112

How to repeat:
Open http://domain/xmlui/search

Enter to Full text search some problematic chars:
ä ü ö õ ('a uml', 'u uml', 'o uml' or 'o tilde')

Hit Go. Press Go button again to see more fun.

As for now this input entry seems to be the only bad one.

If i force from browser for a moment ISO-8859-1 charset, enter some
problematic chars and press Go, then search is fine. Second Go and
problem again.

I checked http://cocoon.apache.org/2.2/1366_1_1.html too, but this
doesn't seem to be issue.

Any hints?

Regards
--
Eimar Koort
(e-mail: eimar.ko...@emu.ee)
(http://www.emu.ee)

--
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] full text search utf issue

2012-02-02 Thread Eimar Koort

Hi,

Thanks Brian and Tim!

This AJP hint helped out.

 !-- Define an AJP 1.3 Connector on port 8009 --
 Connector port=8009 protocol=AJP/1.3 redirectPort=8443 
URIEncoding=UTF-8 /

Tomcat restart - et voila!

Regards
--
Eimar Koort
(e-mail: eimar.ko...@emu.ee)
(http://www.emu.ee)

On 02.02.2012 17:29, Brian Freels-Stendel wrote:
 Good morning,

 We had this same problem, and it turned out that we needed to specify
 URIEncoding=UTF-8 in our AJP connector as well as the regular port
 connector (in Tomcat's server.xml file.)  I can't say you're having the
 same problem, but it may be worth checking out.

 B--

 On 2/2/2012 at 2:15 AM, in message4f2a541e.3080...@emu.ee, Eimar
 Koort
 eimar.ko...@emu.ee  wrote:
 Hi,

 I'm encountering the same problem with Dspace 1.8.1 as described here
 :

 https://jira.duraspace.org/browse/DS-112


 How to repeat:
 Open http://domain/xmlui/search

 Enter to Full text search some problematic chars:
 ä ü ö õ ('a uml', 'u uml', 'o uml' or 'o tilde')

 Hit Go. Press Go button again to see more fun.

 As for now this input entry seems to be the only bad one.

 If i force from browser for a moment ISO-8859-1 charset, enter some
 problematic chars and press Go, then search is fine. Second Go
 and
 problem again.


 I checked http://cocoon.apache.org/2.2/1366_1_1.html too, but this
 doesn't seem to be issue.

 Any hints?

 Regards
 --
 Eimar Koort
 (e-mail: eimar.ko...@emu.ee)
 (http://www.emu.ee)


 
 --
 Keep Your Developer Skills Current with LearnDevNow!
 The most comprehensive online learning library for Microsoft
 developers
 is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3,
 MVC3,
 Metro Style Apps, more. Free future releases when you subscribe now!
 http://p.sf.net/sfu/learndevnow-d2d
 ___
 DSpace-tech mailing list
 DSpace-tech@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/dspace-tech

--
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

[Dspace-tech] xmlui / creative commons / cert issue

2012-02-02 Thread Ron Peterson

Running 1.8.0, using XMLUI Mirage theme.

Clicking the link to an item's associated Creative Commons license
doesn't work.  If I understand correctly, it should link to the
appropriate page at the CC site; but instead the link just reloads the
same page.

The cocoon log registers the following error:

2012-02-02 12:09:32,915 WARN  
org.apache.cocoon.components.xslt.TraxErrorListener  - Can not load requested 
doc: sun.security.validator.ValidatorException: PKIX path building failed: 
sun.security.provider.certpath.SunCertPathBuilderException: unable to find 
valid certification path to requested target at 
jndi:/localhost/xmlui/themes/Mirage/lib/xsl/aspect/artifactbrowser/item-view.xsl:431:136

What certificate would it be looking for here?  I don't use any
certificates in our Tomcat installation.  I proxy using mod_ajp, so my
only certs are in Apache.

TIA

-- 
Ron Peterson
Network  Systems Administrator
Mount Holyoke College
http://www.mtholyoke.edu/~rpeterso

--
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] xmlui / creative commons / cert issue

2012-02-02 Thread Ron Peterson

Got it. We had updated the XMLUI to address some known XMLUI CC issues,
as per this message:

http://dspace.2283337.n4.nabble.com/Creative-Common-License-Does-not-Show-Properly-in-xmlui-td3699273.html#a3710575

..replacing http://scholarspace.manoa.hawaii.edu with the URL to our own
installation of course. Our url was an https url. Replacing that with
an http://localhost:port/... url fixed the problem.

Still not sure why it didn't like our cert though. I had imported our
cert and the signing chain up to the root level into a custom keystore,
and pointed to that keystore in the JAVA_OPTS read by Tomcat like so:

-Djavax.net.ssl.keyStore=/path/to/my/keystore.jks
-Djavax.net.ssl.keyStorePassword=somethingsomething

Thought that would do it, but it obviously didn't.

--
Ron Peterson
Network Systems Administrator
Mount Holyoke College
http://www.mtholyoke.edu/~rpeterso

2012-02-02_12:32:36-0500 Ron Peterson rpete...@mtholyoke.edu:
Running 1.8.0, using XMLUI Mirage theme.

Clicking the link to an item's associated Creative Commons license
doesn't work. If I understand correctly, it should link to the
appropriate page at the CC site; but instead the link just reloads the
same page.

The cocoon log registers the following error:

2012-02-02 12:09:32,915 WARN
org.apache.cocoon.components.xslt.TraxErrorListener - Can not load requested
doc: sun.security.validator.ValidatorException: PKIX path building failed:
sun.security.provider.certpath.SunCertPathBuilderException: unable to find
valid certification path to requested target at
jndi:/localhost/xmlui/themes/Mirage/lib/xsl/aspect/artifactbrowser/item-view.xsl:431:136

What certificate would it be looking for here? I don't use any
certificates in our Tomcat installation. I proxy using mod_ajp, so my
only certs are in Apache.

TIA

--
Ron Peterson
Network Systems Administrator
Mount Holyoke College
http://www.mtholyoke.edu/~rpeterso

Re: [Dspace-tech] search can't sort by date issued

2012-02-02 Thread Thornton, Susan M. (LARC-B702)[LITES]

Thanks Peter.  I've spent several hours researching this issue, especially why 
we have it in one DSpace instance and not another (running same versions).  
Although I'm not 100% sure, I suspect the issue is caused by invalid data in 
the date.issued field(s) in the respository.  The solution for this, of course, 
would be to clean up the bad dates we have and then put some edits on the date 
fields that end up in DSpace so we do not allow bad dates to get IN our 
repository.  But again, I'm not 100% sure of this and I won't be able to get 
back to looking into this for awhile.
Best regards,
Sue

Sue Walker-Thornton
Software Developer|Database Administrator
NASA Langley Research Center
SGT, Inc.|LITES Contract
130 Research Drive
Hampton, VA  23666
Office: (757) 864-2368|Fax: (757) 224-4001|Mobile: (757) 506-9903
Email:  susan.m.thorn...@nasa.gov

From: Peter Dietz [pdiet...@gmail.com]
Sent: Wednesday, February 01, 2012 12:29 PM
To: Cristian Romanescu
Cc: dspace-tech@lists.sourceforge.net
Subject: Re: [Dspace-tech] search can't sort by date issued

Hi All,

I've just started digging into this as well. Its really unfortunate to only get 
relevance results for searches.

In digging in, I've spit out the stack trace, and its telling me a few things.
1) Do we have bad metadata for dc.date.issued?
-- (I've already harassed my content folks to have them review all our 
metadata) ;)

2) Are we doing the comparison of dates incorrectly. The error below says is 
the value of dateissued an INT.
-- I've been reading this thread, which is very similar: 
http://www.gossamer-threads.com/lists/lucene/java-user/109530


2012-01-31 17tel:2012-01-31%2017:47:02,475 ERROR org.dspace.search.DSQuery @ 
Unable to use speficied sort option: dateissued
2012-01-31 17tel:2012-01-31%2017:47:02,475 ERROR org.dspace.search.DSQuery @ 
Invalid shift value in prefixCoded string (is encoded value really an INT?)
2012-01-31 17tel:2012-01-31%2017:47:02,476 ERROR org.dspace.search.DSQuery @ 
java.lang.NumberFormatException: Invalid shift value in prefixCoded string (is 
encoded value really an INT?)
at org.apache.lucene.util.NumericUtils.prefixCodedToInt(NumericUtils.java:233)
at org.apache.lucene.search.FieldCache$7.parseInt(FieldCache.java:237)
at 
org.apache.lucene.search.FieldCacheImpl$IntCache.createValue(FieldCacheImpl.java:457)
at org.apache.lucene.search.FieldCacheImpl$Cache.get(FieldCacheImpl.java:224)
at org.apache.lucene.search.FieldCacheImpl.getInts(FieldCacheImpl.java:430)
at 
org.apache.lucene.search.FieldCacheImpl$IntCache.createValue(FieldCacheImpl.java:447)
at org.apache.lucene.search.FieldCacheImpl$Cache.get(FieldCacheImpl.java:224)
at org.apache.lucene.search.FieldCacheImpl.getInts(FieldCacheImpl.java:430)
at 
org.apache.lucene.search.FieldComparator$IntComparator.setNextReader(FieldComparator.java:332)
at 
org.apache.lucene.search.TopFieldCollector$MultiComparatorNonScoringCollector.setNextReader(TopFieldCollector.java:435)
at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:249)
at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:240)
at org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:181)
at org.apache.lucene.search.Hits.getMoreDocs(Hits.java:113)
at org.apache.lucene.search.Hits.init(Hits.java:90)
at org.apache.lucene.search.Searcher.search(Searcher.java:63)
at org.dspace.search.DSQuery.doQuery(DSQuery.java:151)
at org.dspace.search.DSQuery.doQuery(DSQuery.java:309)
at 
org.dspace.app.xmlui.aspect.artifactbrowser.AbstractSearch.performSearch(AbstractSearch.java:438)


Just for fun, I enabled Discovery on our development machines, and sorting by 
date issued works perfectly in a search. So, a quick-fix would be to switch to 
using discovery. But, none-the-less, I look forward to getting a resolution to 
this issue.


Peter Dietz



On Wed, Feb 1, 2012 at 7:15 AM, Cristian Romanescu 
cristian.romane...@eaudeweb.romailto:cristian.romane...@eaudeweb.ro wrote:
Greetings,

Have you tried to look into the lucene indexes with Luke tool?
(http://www.getopt.org/luke/).
We are using:
 search.index.13 = dc_date:dc.date.issued:date
to filter by time interval and it works.

But first, we had to remove the old indexes and re-create them to have
correct indexing (ie rm -rf $builddir/search and run
./$builddir/bin/dspace index-init). It only worked when data inside
index looks like 20120101 ... - when you look with luke tool

HTH,
Cristian


On 02/01/2012 12:46 PM, Päivi Rosenström wrote:
 Any solution for this found yet ?


 Thanks!

 Päivi


 Re: [Dspace-tech] search can't sort by date issued
 From: James Bardinjbardin@bu...  - 2011-10-27 19:23
 On Thu, Oct 27, 2011 at 1:52 PM, Blanco, Joseblancoj@...  wrote:
 # Browse indexes
 webui.browse.index.1 = title:item:title
 webui.browse.index.2 = author:metadata:dc.contributor.author:text
 webui.browse.index.3 = subject:metadata:dc.subject.*:text
 webui.browse.index.4 = dateissued:item:dateissued

 #

Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1

[Dspace-tech] full text search utf issue

[Dspace-tech] PostgreSQL to Oracle 11g

[Dspace-tech] Making DSpace read only

Re: [Dspace-tech] Making DSpace read only

Re: [Dspace-tech] Changing advanced search drop down in XMLUI

Re: [Dspace-tech] full text search utf issue

Re: [Dspace-tech] full text search utf issue

[Dspace-tech] xmlui / creative commons / cert issue

Re: [Dspace-tech] xmlui / creative commons / cert issue

Re: [Dspace-tech] search can't sort by date issued

11 matches

Site Navigation

Mail list logo

Footer information