[dspace-tech] Re: REST API not working

2018-01-23 Thread Paul Warner
Hi, It sounds like you are having other problems, George, but I just struggled with Dspace's Rest interface, and I can confirm the Apache Proxy/ReverseProxy problem. That stumped me for a while, because we are running https through Apache, and I thought I should leave the https in. But we ar

Re: [dspace-tech] Error during database migration (upgrading 4.3 to 6.2)

2018-01-23 Thread Anthony Petryk
The database migration was successful after removing those views. Many thanks. Anthony On Tuesday, January 23, 2018 at 9:57:06 AM UTC-5, Anthony Petryk wrote: > > Hi Tim, > > > > I inherited our DSpace instance around version 1.8 I believe. We’ve been > running it for 8+ years. In any case

Re: [dspace-tech] Database error when trying to edit epersons (oracle - ORA-00932: inconsistent datatypes: expected -

2018-01-23 Thread Tom Desair (Atmire)
It could also be useful to temporarily enabled debug logging for the "org.dspace.storage.rdbms" package. You can do this by adding "log4j.logger.org.dspace.storage.rdbms=DEBUG" at the end of the dspace/config/log4j.properties file. After updating the log4j.properties file you'll have to restart

Re: [dspace-tech] Database error when trying to edit epersons (oracle - ORA-00932: inconsistent datatypes: expected -

2018-01-23 Thread Donald Bynum
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

Re: [dspace-tech] Database error when trying to edit epersons (oracle - ORA-00932: inconsistent datatypes: expected -

2018-01-23 Thread Francis Brouns
> > Hi Tim, > > > 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_val

Re: [dspace-tech] Database error when trying to edit epersons (oracle - ORA-00932: inconsistent datatypes: expected -

2018-01-23 Thread Francis Brouns
> > Hi Tim, > > However, in this situation the error was said to start with version 5.6, > not version 5.5. > It might have been me who reported that issue. We never upgraded to 5.5 (although I had installed the security patch for 5.5). We upgraded from 5.4 to 5.6 and that is when I noticed t

Re: [dspace-tech] Database error when trying to edit epersons (oracle - ORA-00932: inconsistent datatypes: expected -

2018-01-23 Thread Tom Desair
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), repla

Re: [dspace-tech] Database error when trying to edit epersons (oracle - ORA-00932: inconsistent datatypes: expected -

2018-01-23 Thread Tim Donohue
Hi Don, It sounds like this is an Oracle-specific bug in the DSpace codebase. There's some new discussion taking place in the ticket I mentioned: https://jira.duraspace.org/browse/DS-3649 I'm not aware of a "quick fix" or workaround quite yet...but I'm hoping one of our volunteers will be able to

Re: [dspace-tech] Database error when trying to edit epersons (oracle - ORA-00932: inconsistent datatypes: expected -

2018-01-23 Thread Donald Bynum
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

Re: [dspace-tech] Error during database migration (upgrading 4.3 to 6.2)

2018-01-23 Thread Anthony Petryk
Hi Tim, I inherited our DSpace instance around version 1.8 I believe. We’ve been running it for 8+ years. In any case, thanks for your help – I’ll remove those views and re-run the database migration. Cheers, Anthony On Monday, January 22, 2018 at 4:50:49 PM UTC-5, Tim Donohue

Re: [dspace-tech] REST API not working

2018-01-23 Thread Mark H. Wood
On Monday, January 22, 2018 at 4:13:24 PM UTC-5, George Kozak wrote: > > Hi, Hardy: > I think I found the problem in the catalina.out log. > I see: > SEVERE: Error listenerStart > SEVERE: Context [/rest] startup failed due to previous errors > SEVERE: Exception sending context destroyed event to li