Tom, In my version of EPerson.java there are two occurrences of "m_text_value" rather then "m.text_value" as you suggested and which is also in the github repository. That seems odd to me. Any thoughts on that? I will go ahead and do the suggested substitution on those two lines all the same.
For reference, my original codefile is dated 3/21/2016 -Don. On Tuesday, January 23, 2018 at 11:05:37 AM UTC-5, Tom Desair (Atmire) wrote: > > Hi Don, > > We're discussing a permanent fix in this ticket > https://jira.duraspace.org/browse/DS-3649 > > But as a temporary workaround for you, can you try this: > > In file EPerson.java ( > https://github.com/dspace/DSpace/blob/dspace-5_x/dspace-api/src/main/java/org/dspace/eperson/EPerson.java#L535), > > replace each occurrence of "m.text_value" by "dbms_lob.substr(m.text_value, > 0, 4000)". > > If you do not have a "dspace-api" directory, please copy the EPerson.java > file to > dspace/modules/additions/src/main/java/org/dspace/eperson/EPerson.java and > execute the replace there. > > Does this prevent the error? Note that this is only a temporary workaround > for people using Oracle. > > Best regards, > Tom > > > [image: logo] Tom Desair > 250-B Suite 3A, Lucius Gordon Drive, West Henrietta, NY 14586 > Gaston Geenslaan 14, Leuven 3001, Belgium > www.atmire.com > <http://atmire.com/website/?q=services&utm_source=emailfooter&utm_medium=email&utm_campaign=tomdesair> > > 2018-01-23 16:44 GMT+01:00 Donald Bynum <byn...@gmail.com <javascript:>>: > >> Verified that the issue exists in my dev environment as well as >> production. Running Oracle 12.2. Is there any workaround available for >> this. Cannot add people to groups, cannot manage eperson records. >> >> -Don. >> >> >> On Monday, January 22, 2018 at 3:57:33 PM UTC-5, Donald Bynum wrote: >>> >>> No database changes have been made for the longest time. Definitely no >>> code changes. I will test in my dev environment tomorrow. I also have a >>> dev DB instance and will play around with combinations and see if there is >>> any pointers. Either way, I'm a bit dead in the water without being able >>> to maintain groups/etc. >>> >>> -Don. >>> >>> On Monday, January 22, 2018 at 2:36:33 PM UTC-5, Tim Donohue wrote: >>>> >>>> Hi Don, >>>> >>>> This error sounds similar to this reported issue: >>>> >>>> https://jira.duraspace.org/browse/DS-3649 >>>> >>>> However, in this situation the error was said to start with version >>>> 5.6, not version 5.5. Looking at the ticket again, it looks like we don't >>>> yet have a solution. But, maybe it'll give you (or others reading this) >>>> hints as to what might be happening. >>>> >>>> - Tim >>>> >>>> On Mon, Jan 22, 2018 at 12:46 PM Donald Bynum <byn...@gmail.com> wrote: >>>> >>>>> I am running DSpace 5.5 with XMLUI and Oracle. I have been running >>>>> just fine for a long time. Today I went to add a new collection and edit >>>>> some groups. When I click on Add eperson (or for that matter the eperson >>>>> link on the admin page) I get an Oracle error: >>>>> >>>>> oracle - ORA-00932: inconsistent datatypes: expected - got CLOB >>>>> >>>>> I have no idea what might have changed, given that any changes would >>>>> have been done by me. Guessing that something at the data layer has been >>>>> corrupted in some way. Can anyone provide some insight/assistance. >>>>> >>>>> Best regards, >>>>> >>>>> Don Bynum >>>>> >>>>> -- >>>>> 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...@googlegroups.com. >>>>> To post to this group, send email to dspac...@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...@googlegroups.com <javascript:>. >> To post to this group, send email to dspac...@googlegroups.com >> <javascript:>. >> Visit this group at https://groups.google.com/group/dspace-tech. >> For more options, visit https://groups.google.com/d/optout. >> > > -- 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.
