Hi Don, Tom & Francis, I notice the code that Tom mentions patching in EPerson.java didn't appear until DSpace 5.6. It was applied in this PR: https://github.com/DSpace/DSpace/pull/1229
Don, you mentioned you are running DSpace 5.5. So, this has got me wondering if the problem you are seeing is actually the same one as Francis, or something different (but similar in nature)? That might explain why this patch works for Francis (who is running 5.6), but not for Don. Don, could you perhaps share a more complete error stacktrace (from the logs) for the "ORA-00932: inconsistent datatypes: expected - got CLOB " message you are seeing? It's always possible this is happening in different scenarios in DSpace 5.5 vs 5.6. - Tim On Thu, Jan 25, 2018 at 2:28 PM Donald Bynum <byn...@gmail.com> wrote: > I copied the EPerson.java to > dspace\modules\additions\src\main\java\org\dspace\eperson (I had ti create > the additions folder) and rebuilt. Still not good. How can I be sure that > the new java class exists? meaning, where can I look to make sure that the > newly compiled class is in place? I am going to try one other thing. But > would appreciate any further guidance you can give me. > > -Don > > > On Wednesday, January 24, 2018 at 5:29:44 AM UTC-5, Tom Desair (Atmire) > wrote: > >> Hi Francis, >> >> That's good news! Thanks for testing and your feedback. I hope that this >> workaround then also works for Don. >> >> Best regards, >> Tom >> >> [image: logo] Tom Desair >> 250-B Suite 3A, Lucius Gordon Drive, West Henrietta, NY 14586 >> <https://maps.google.com/?q=3A,+Lucius+Gordon+Drive,+West+Henrietta,+NY+14586&entry=gmail&source=g> >> Gaston Geenslaan 14, Leuven 3001, Belgium >> <https://maps.google.com/?q=Gaston+Geenslaan+14,+Leuven+3001,+Belgium&entry=gmail&source=g> >> www.atmire.com >> <http://atmire.com/website/?q=services&utm_source=emailfooter&utm_medium=email&utm_campaign=tomdesair> >> >> On Wednesday, January 24, 2018 at 11:22:40 AM UTC+1, Francis Brouns wrote: >>> >>> Dear Tom, >>> >>> this workaround seems to work by changing m.text_value in line 502 and >>> line 510 in EPerson.java for Dspace release 5.6. The error no longer occurs >>> when selecting epersons or trying to add epersons to a group. >>> >>> case LANGUAGE: >>> s = "m.text_value"; >>> t = "language"; >>> break; >>> >>> >>> default: >>> s = "m.text_value"; >>> t = "lastname"; >>> >>> >>> 2018-01-24 11:14:49,448 DEBUG org.dspace.storage.rdbms.DatabaseManager @ >>> Running query "SELECT * FROM eperson e LEFT JOIN metadatavalue m on >>> (m.resource_id = e.eperson_id and m.resource_type_id = ? and >>> m.metadata_field_id = ?) ORDER BY dbms_lob.substr(m.text_value,0,4000)" >>> with parameters: 7,125 >>> >>> I'll try this in release 5.8 as well and see if we can proceed with the >>> upgrade. >>> >>> Thanks for now. >>> Francis Brouns >>> Open Universiteit >>> >> -- > You received this message because you are subscribed to the Google Groups > "DSpace Technical Support" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to dspace-tech+unsubscr...@googlegroups.com. > To post to this group, send email to dspace-tech@googlegroups.com. > Visit this group at https://groups.google.com/group/dspace-tech. > For more options, visit https://groups.google.com/d/optout. > -- Tim Donohue Technical Lead for DSpace & DSpaceDirect DuraSpace.org | DSpace.org | DSpaceDirect.org -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
